Solved

IFS REST call output values are not fetching in the workflow

  • 5 December 2023
  • 3 replies
  • 124 views

Badge +3

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

icon

Best answer by Buddhi Gunasekara 6 December 2023, 04:29

View original

3 replies

Userlevel 3
Badge +5

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 
$.columns[0].id. (Because columns is an Array and you need to specify which array object you need id of)

Badge +3

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

Userlevel 3
Badge +5

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

Reply