extract data via api v2
hi folks,

i have been tasked to extract data from 3 keys boards for mgmt reporting, i’m trying to extract all rows and columns from the board i’m using python request. i just started writing the script and it seem like this will be a very complex task.

does anyone have an previous code they can s…
thanks i was able to use something similar. i have just seen online that we’re not able to extract column values for calculated columns? is there any other way of extracting this data?

query = """ query { boards (ids: %s limit: 20, page: 1) { id name columns …
hi [@mateus\_cruz](/u/mateus_cruz),

thanks again for your details that really helped and i’m able to extract logs successfully as expected.

below steps:

authenticate and fetch the access token using endpoint <https://account.uipath.com/oauth/token>

get the job key using endpoint [uipath](https://cloud.uipath.com/%5baccountlogicalname%5d/%5btenantlogicalname%5d/odata/jobs?%24filter=releasename) eq ‘processname’&$orderby=sta… done. [links to api, release notes, derived formulas, etc](https://community.weatherflow.com/t/links-to-api-release-notes-derived-formulas-etc/2450) .

thanks for the request / suggestion [@vinceskahan](/u/vinceskahan) ! You could try using the in line view like this:


Select table1.col1, table1.col2, table1…., table2.col1, table2.col2, table2….  

 from  

(SELECT *  

FROM dbo.Shaft\_Scales  

WHERE dbo.Shaft\_Scales.ID = (SELECT max(ID) from dbo.Shaft\_Scales ID) as table1,  

(SELECT *  

FROM OtherTable  

WHERE dbo.OtherTable.ID = (SELECT max(ID) from dbo.OtherTable ID) as table2


—————- another approach from meandyou 


This works on [at least some] SQL processors


SELECT T1.* , T2.*  

FROM table1 T1, table2 T2  

WHERE …


Do we have to discuss why not to use “SELECT * ” in your SQL?<pre>


Try this


SELECT * FROM T1 as a, T2 as b WHERE a.ID = (SELECT max(ID) from T1)  

and b.ID = (SELECT max(ID) from T2);</pre> your link leads to an inactive developer message btw.

rest does not yet provide a way to list tags except by id. you can use the standard api with the same oauth2 access key that you would use for rest… using the data object you would want to query on the group table using the groupname field. You need to iterate over the resource...

 
```
while ($row = mysql_fetch_object($tariff_query)) {
    echo $row->somefield;
    echo $row->someotherfield;
}

```
 So you now get all the records not just the first one.

 BTW, if you want to use an object, why not use PDO or mysqli? mysql is dead - or as good as. Hi, this would not be possible as clients would not normally let you pass this along, but if you go to Prince2 sites you can get a list of documents they require at the different points in a project.


The list below is what I copied from some where in the distant past,so apologies if i have not got permission or not recognized you as the owner of this list.


<b>Pre-Project;</b>  

<ol>  

Business case  

Feasibility study  

Investment appraisal for projects  

Issue management  

Project life cycle  

Project opportunities  

Risk management  

Sensitivity analysis  

Small project  

Stakeholders -identification-communication-power map  

Terms of reference</ol>


<b>Planning & Starting a Project;</b>  

<ol>  

Approval  

Authorization  

Back-scheduling  

baseline and baselining  

Communications plan  

Constraints  

Critical success factors  

Estimating  

Filing & document management  

Handover options  

Issues management  

Milestones and milestone plans  

Network analysis and critical path  

Objective (s)  

Planning checklist  

Programme or project identification?  

Project life-cycle  

Project opportunities  

Project strategy  

Quality in project work  

Risk management  

Scheduling  

Scope  

Stage or Phase  

Task checklist  

Terms of reference  

Tuning or scaling a project  

Two level planing  

Work breakdown structure  

Work distribution model  

Work packages  

</ol>


<b>During a Project;</b>  

<ol>  

Budget control  

Business case review  

Channel control  

Controlling against schedule  

Decisions in projects  

Earned value analysis  

Filing & document management in a project  

Impact analysis  

Issue management  

Lessons learnt  

Project health checks  

Quality in a project work  

Reports projects and programs  

Request for change  

Risk management  

Stages – start and end procedures  

Task checklist  

</ol>


<b>Closing a Project;</b>  

<ol>  

Closing a project  

Handover options  

Lessons learnt  

Post project review</ol>


<b>Project Organization</b>  

<ol>  

Champion  

Matrix management  

Prince 2 project board  

Responsibility matrix  

Sponsor  

Steering group  

</ol>


<b>Project Finance</b>  

<ol>  

Authorization  

Budget control  

Budgets for project work  

Earned value Analysis  

Impact Analysis  

Investment appraisal for projects  

Benefit realization planning  

</ol>


I have some templates for reports and business cases i can let you have if you need them, but there are many different types and ones which companies use. ><snip angsty whining> I am supposed to read numbers out  

>of a file piano.data and put the results into report.out.  

How are the results to be formatted? Give us an example run of the program.



>The piano file is structured like this  

Exactly like that? Or are you adding your own commentary? The difference is in how you parse the data, and that's a pretty big difference. as long as you write down the hierarchy manually, there’s certainly the possibility to simplify such transitive from implementations with a macro. [i’ve written one here, feel free to take a look.](https://play.rust-lang.org/?version=stable&mode=debug&edition=2018&gist=337cce675aa28e99ac030ca783c1c155) going even further one could try to use procedural macros with global state that uses annotations on the… There is not an existing script but you could probably do it thru the Lotus COM interface. The easiest way is to create an agent in Lotus Notes to extract the information from Excel, and then using the NOTESACL objects of NotesDatabase add the references.


Does this help? If you need further assistance, please be a little more descriptive and I will see if I can help further.


Mike K. [image] simas:

[image] virgilwashere:

<https://domain.com/mautic/mautic_segments_update.sh>

i doubt that is the intended way to invoke the bash script.

well, that’s what i was told to use in the command line to invoke the script… and from the output file support says it’s working from their…