Can't access data from API response within Do while Loop in API flow

Ricky Mccarthy · 2025-06-18T13:25:42+00:00

There was an error rendering this rich post.

I'm hoping someone can give me some assistance with this. I'm new to API flows.
I have an API flow which calls 3 datalake APIs .
The submit box calls the DATAFABRIC/compass/v2/jobs/ API
The JobStatus box calls the DATAFABRIC/compass/v2/jobs/{queryId}/status/ API
The Result box calls the DATAFABRIC/compass/v2/jobs/{queryId}/result/ API

I'm submitting a job to the Datalake API (Select * from table where PI_CODE = 'X' and date = 'Y') and passing the QueryID from the API response to the status API.
I've added the JobStatus box to the do while loop so I can loop until the status from the response is FINISHED. However with the JobStatus box within loop, I'm unable to access any information from the response to add to the do while parameter. I've tried typing the value ${JobStatus.Body}.status but that gives an error.

I can get this to work by creating a dataflow which calls a workflow. In the workflow the looping works and returns the FINISHED status I'm looking. However I'd prefer to do this in an API flow. Is it possible ?

Find more posts tagged with

API Usage

Infor Data Fabric

Accepted answers

All comments

Brandon Watson

Were you able to get around the content-type issue with the API call, in that text/plain is not supported in an API flow? I think this would be the first issue. Are you setting the Output Parameter to a Name of 'Body', with a BODY Response Type? In the second screenshot below I used StatusResponse, so the path/value would be ${Status.StatusResponse}.status, would give me the value from the Status API Response node of 'status'.

Ricky Mccarthy

Hi Brandon

I took the Submit box out of the API flow and put it into a dataflow (The Job API is now a connection point) so it can now handle text/plain content type

The dataflow should be passing the queryId to the API flow, So the flow looks like this . A test of the status box shows it's working.

Where I'm stuck is in the do while loop. I need the output of the status box (the status field) to use in the loop but I can only see the input.QueryStatus. The status from the input will be "RUNNING" and it'll be static so the loop will crash out after 100 loops (I assume).

I tried entering ${Status.body}.status but I'm getting the error "Parameter with name ‘Status.body’ does not exist."

Move the Status box to the left of the loop and it's available as a do while parameter.

Is there a way I can get this to work ?

Copyright © 2025 Infor. All rights reserved.