JSON being converted to string in DATA Transformation upon API triggering

43 views
Skip to first unread message

Unni J

unread,
Mar 15, 2023, 11:06:39 AM3/15/23
to integra
Hi, 
      I have been working in Integra.Sky for some time now. I am using SAP B1 Service layer to get Data and have a flow set by using a API Gateway trigger as its first point of contact.
The data coming from Data Transformation module upon testing in individual module seems fine but when the entire flow is triggered using the API generated, in the Data Transformation module it takes the input as a string and thus does not give an output and hence the data never returns the endpoint .

This is when testing in individual Module 
Integra.SKY ss1.PNG

when Testing by triggering the flow with same input the same json data is converted to String .
Note : I am dealing with a single JSON Object with key value pairs .
IF it was a JSON array this does not occur .
Integra.SKY ss2.PNG
Kindly suggest a work around for the issue .

Felipe Laera Ignacio

unread,
Mar 15, 2023, 11:26:00 AM3/15/23
to integra, un...@sociusus.com
Hi!
I think it's an scape problem. Maybe some character like '\' in your input data is breaking your JSON.
Can you send the input data of this component at runtime to my email? So we can continue the investigation here...  

Thanks!
Message has been deleted

Felipe Laera Ignacio

unread,
Mar 23, 2023, 9:24:41 AM3/23/23
to integra, Felipe Laera Ignacio, un...@sociusus.com
Hi!
We identify the problem. It is the backslash in the address field inside the transformation module
To solve this problem now, you can use a Transformation module by passing the parameter {} I4zxM8rS: Address {/} as input and using the expression $escape(result). This way the output will be escaped and can be included in the address field of the Transformation module that is having problems.

We are working on a feature that will make this easier. I will update this post as soon as we have completed the approval.
Reply all
Reply to author
Forward
0 new messages