Flow Error : JSON must be an object or an array

[IndiraH]

We are encountering an error in some cases within a flow that handles our HR Profiles via IntegrationHub. The error message is as follows:

"Failed to iterate on data stream: com.glide.transform.transformer.exceptions.InvalidStructureException: JsonStreamParser[0]: JSON must be an object or an array: '<'"

This issue does not occur in all executions of the flow — only in some instances. Notably, the error only appears during automatic runs of the flow. When the job is triggered manually, it completes successfully without any issues.

We attempted to debug the flow (refer to the attached file for more details),

Could anyone please help me to understand better where the issue could be and what to check?

#integration Error  

Could anyone please help me to understand better where the issue could be and what to check?

[Bhimashankar H]

Hi @IndiraH ,

It seems like the structure of JSON is not valid, there might be adding some characters to payload breaking the structure of JSON. I would suggest copy the payload when it failed and try to format and see in bg script.

or else log the JSON payload then copy from there and format payload on any online JSON formatter or bg script screen.

Then it will show if the JSON structure where it is breaking.. 

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[Bhimashankar H]

Hey @IndiraH ,

did you get a chance to go through my previous reply.

If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. It will help future readers as well having similar kind of questions and close the thread.

Thanks,
Bhimashankar H