Skip to main content

Hi,

I’m trying to get row ids using an IFS REST call as below and not fetching values as expected in the workflow. When I run the Get sheets call in Postman I get results that show row ids.

 

Many thanks for your inputs on this issue.

Best regards,

Uvini

Workflow uses JsonPath(A query language for JSON) to access response variables. 
It seems your JsonPath expression is not pointing to what you want. For example, if you want to get columns.id try something like 
$.columnsl0].id. (Because columns is an Array and you need to specify which array object you need id of)


@Buddhi Gunasekara  Is it possible to obtain the entire JSON response in a single variable(without pointing to one response variable)?


Yes. You just have to use JsonPath expression $
Then the whole response will be assigned to the variable you specify.


Reply