Unanswered

Creating a data table from elements of a JSON response

(0) Share

Report

Posted on by IAQG

Hi all,

My goal is to call an API from the Invoke Web Service call and, from the JSON response, extract certain elements that can be referenced in a data table. For this project, I'm calling a service that displays customer information. The call will return an array of customers, and I'm extracting a customer's name and ID (this part is complete). What I'd like to do is create a table that I can search a Name and pull their ID. From what I've seen lists are only index to value. I know you can create a table off of a SQL query or an Excel extract, but is there any way to create from a JSON object, a converted custom object, or some other way that I don't know of? Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

tkuehara 667 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @IAQG

I don't think it's possible to create from a JSON object, but you can try creating a multidimensional array (list of lists) if that suits your needs.
The variable matrix will be kind of a data table:
Then you can access those values like %Matrix[0][0]% (for ID) and %Matrix[1][0]% (for name)
I know this is not a data table per se but it's a similar approach. Also, please note it will only work properly in case all your "inner lists" have the same size (in the example above, both List1 and List2 have the same number of items).

Was this reply helpful? Yes No
IAQG 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Disappointing that there's no way to make an object outside of the previously mentioned methods, but I'll see if this method helps. I'll leave the post open for now in case another solution presents itself, otherwise I'll accept yours as the solution. Thanks for posting! I hadn't thought about doing it like that.

Was this reply helpful? Yes No