The CPI URL is not showing any data

[Akash]

Hi,

I have consumed the Odata url in CPI iFlow. After successfully generating the CPI URL, I tested it via Postman with a particular date range. It gave a status code of 200, but I didn't get any response. This odata url has more than 80k records for a particular date range. If I test this odata url in the gateway client, it shows a status code of 200. Please help me.

[ajos]

Can you put a screenshot of your iflow?

[Bais]

Did you try to use $top and $skip for paging? $count=true for checking how many records are you trying to download?

[Ivan-Mirisola]

Hi @Akash,

If you carefully read the answer given by your back-end system (HTTP 200), there is an error tag named: TOO_LARGE_BODY

That error is not an SAP error from any standard interface. 

I'd suggest you get in touch with the person that create the OData interface named: Z_DCC_SALES_REGIS_V3_SRV to investigate issues with the data returned. 

Apparently the developer has made it work with a fixed maximum amount of data to be returned (maybe because this is also the same amount of data that their Administrator has setup for regular users logging in via SAPGui as a restriction to avoid long running processes).

Best regards,
Ivan

[Akash]

[ajos]

Can you trace the data call going to gateway system using IWFND/TRACES and compare it with the params in the direct call?

[Akash]

but data is stored in the Data Store point. but I can't see the response in Postman.