How to fetch and pass CLOB data in machine steps or scripts?

Flow Classic
1

Hi,

Here I have an IFS API which returns CLOB data in an entity type output.
I tried accessing this CLOB data from the return, but in the debug console this CLOB data value shows as a “Microsoft.Odata.Client.DataServiceStreamLink” and when I tried to fetch CLOB value as an output, flow throws error “Object not set to an instance of an object”.

image
image938×340 16.2 KB

image
image1382×718 20.9 KB

I need to see any way in novacura to fetch these returning CLOB values and how to pass any CLOB value into an API.

Thanks.

2

Hey,

I haven’t been in the OData connector for Classic much, and it’s been a while. So I had to use AI to check some source code files to get an answer for you:

"don’t map Entity.ClobData into a text output—the screenshot shows an OData stream link, not its contents. Use the IFS stream’s read URL for a separate Classic REST GET, with a String output; to write it, send the text to its edit URL using the method and content type specified by that IFS endpoint. The read/edit URLs must come from the actual IFS response or metadata; LobId alone does not establish either URL. If the receiving API instead expects a JSON field, use an object/model so the text is JSON-escaped, rather than sending the stream link or manually adding quotes."