Skip to main content
Nintex Community Menu Bar
Solved

API reporting - How do I know what fields are reportable?

  • May 10, 2023
  • 1 reply
  • 76 views
  • Translate

Forum|alt.badge.img

I’ve created an API key and am attempting to run queries using the Excel template.
I can’t seem to filter the data in the way I want.

For example, I just want to see level 1 and 2 process groups, but when I select these it doesn’t count any processes in their related child groups.

Also, is it possible to report on processes with particular tags?

 

Best answer by EddieThomas

The API currently provides the following:

  • Processes
  • Processes Historical
  • ProcessGroups
  • ProcessGroupsHistorical
  • ProcessReviews
  • ProcessReviewsHistorical
  • ProcessViews

If you look at the Processes table and then split the ProcessGroupPath into separate values you can then count how many processes are related to each group (L1, L2 or any other sub group). You can also the group structure to turn the groups into a hierarchy in PowerBI (or excel/PowerQuery) that will automatically update with the data is refreshed. 

It doesnt provide the tags unfortunately. Its possible to analyse these when exporting the data from Promapp via XML file but this takes some fiddling.

Here is a link to the API Documentation for Promapp but it doesnt include a list of the tables or fields that are available from it Reporting API (nintex.com) .

 

View original
Did this topic help you find an answer to your question?

1 reply

EddieThomas
Forum|alt.badge.img+6
  • Scholar
  • 39 replies
  • Answer
  • May 16, 2023

The API currently provides the following:

  • Processes
  • Processes Historical
  • ProcessGroups
  • ProcessGroupsHistorical
  • ProcessReviews
  • ProcessReviewsHistorical
  • ProcessViews

If you look at the Processes table and then split the ProcessGroupPath into separate values you can then count how many processes are related to each group (L1, L2 or any other sub group). You can also the group structure to turn the groups into a hierarchy in PowerBI (or excel/PowerQuery) that will automatically update with the data is refreshed. 

It doesnt provide the tags unfortunately. Its possible to analyse these when exporting the data from Promapp via XML file but this takes some fiddling.

Here is a link to the API Documentation for Promapp but it doesnt include a list of the tables or fields that are available from it Reporting API (nintex.com) .

 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings