POST API Variables

[superjesse]

Hello folks. I'm trying to POST to Service Now via an API using the download tool. My biggest challenge is passing the variables along with it. I have 8 variables I need to send. I was reading another solution about creating a JSON file with JSON Build.  I just can't figure out how to create a separate JSON for each record that comes through.

Example data below.

[apathetichell · Accepted solution]

you need to use a transpose to get these into a format where the json can be in a key/value pair. Basically whatever you are sending in your api call should be found in your body variable in your first record (or each body in each record). This usually means you need to use a summarize tool to concatenate your payload to create your body.

[superjesse]

Thank you for the quick response. I do understand the transpose and key/pair.  But how do I separate them by each instance?  If I transpose, doesn’t it go down the whole column? How does it know when the next record starts?  

[ArtApa · Accepted solution]

Hi @superjesse - You need to add Record ID before transpose. Then select RecordID field as a Key Column in Transpose. Finally, You will group by RecordID in JSON Build: