Unable to Extract Data From Odata Service Exposed in S4

[hsonnenahalli]

Hello All-

I am working on a scenario in which I need to extract the data using Odata services exposed in S4 1909 On - Premise system using a CDS view. I have only 52 records in the table. I have tested the Odata service in POSTMAN and it is working as expected. When I configure the same and do a select using GET query in SAP CPI, The flow is stuck in processing for many hours and it will fail during which am unable to deploy any other flows. If I use the filter like $tops=52. I will get the response immediately. I am not sure why am unable to do a mear GET and retrieve all data. I know the option of Pages and Processing which is part of the Odata adapter but I think there something which is missing to get the data processed from S4. Please let me know if you have any thoughts and ideas to resolve this issue.

Regards

Hari Sonnenahalli

[hsonnenahalli · Accepted solution]

I resolved this issue the culprit was SAML2 single sign on which is activated in S4. That had to be disabled through custom query and second was the head session which has to be set to integration flow in main integration.