โ01-11-2022 01:23 PM
We have an API thatโs expecting raw text as the body of the call and Iโm not clear on how to get SnapLogic to pass the data as raw unformatted text. If I map my text into $content and then pass that to the API
The problem is that when I look at how this is being passed, the receiving API is getting this:
I need it to be somehow stripped down to:
SELECT * from ENTRY
without the [โโ]
I understand that SnapLogic deals in JSON, so Iโm not sure how I get around a system that doesnโt want itโs data that way. Iโve looked into passing it as JSON, but they donโt seem to accommodate it.
Solved! Go to Solution.
โ01-11-2022 05:26 PM
I should have remembered this because I used batch size=0 to solve this sort of problem before but Support steered me in this direction:
This worked and removed the json formatting around the raw text.
โ01-11-2022 02:22 PM
It is possible that could be from the API side.
I have no idea what other can be.
โ01-11-2022 02:30 PM
I can send the body successfully as raw text using Postman. Also Iโve verified that SnapLogic is adding the [โโ] in when I send the same call to a RequestBin that I use for testing. I may need to log a ticket on this. All great ideas to try from you though and I appreciate it!
โ01-11-2022 02:31 PM
Iโve created one pipeline which I am triggering with REST Post snap.
In that pipeline I donโt do anything, just passing the data back as respone.
In HTTP entity I pass string and as response I get the same string back so it means that REST Post snap is not adding anything.
Here is the response that Iโve got:
โ01-11-2022 03:52 PM
I donโt think thatโs quite true. Iโm using an outside API Request bin (using pipedream.net) to test:
When I send from Snaplogic:
I see this in the request bin:
If I submit the same thing from Postman:
I get:
I suspect that SnapLogic is handling all of what you see internally.
Ultimately, I know itโs unusual to have an API that requires RAW text, but this one does, so Iโm in a bad spot because SnapLogic seems to force minimal JSON formatting even if I donโt want it there.
โ01-11-2022 05:26 PM
I should have remembered this because I used batch size=0 to solve this sort of problem before but Support steered me in this direction:
This worked and removed the json formatting around the raw text.