Create Reference for the Query_Field_IDs Accessible Via Query API

We're starting to use Power Automate to pull data into Power BI for reporting. As part of this process, we convert queries in NXT into JSON, where each field has a unique "query_field_ID." Because these are numerical values, it would be very helpful to have a reference that lists the query_field_ID along with the field description. If I need to add a field to the query output, for example, I have to go back into Query in NXT to generate new JSON code, as I don't know the appropriate field ID. A reference would make it much easier to simply edit the existing JSON.

  • James Belich
  • May 20 2025
  • Reviewed: Voting Open
  • Attach files