@Robert_Petitto I really need to find some time to sit down and play with all of this, but it looks like jq query may be able to pull back multiple values at once. From what I see with your setup, you are making three separate api calls, which works, but could be better if it was a single call. I wonder if you can specify all values and have them returned in a delimited list, which could be split into an array and separated out with single value columns. That’s the hard way…on the other hand, you could retrieve the entire json object and use David’s json transformation column (Jq (JSON transformation) Column) to get the values you need. Either way, it would reduce three api calls down to one…especially if there are limits on how many calls you can make within a given time period.
4 Likes