SAP Data Services webservice json gives only last record

[Former Member]

Hi,

I have a Data Services job which gets data from a webservice in JSON format.

I have a datastore with a correct WADL. I imported the function and build a flow where I call the function and unnest the output. However, I only get the last record in my table.
If I check the debugger I see that right after the call I only have the last record available. However, in my trace file, if I trace Transforms, I see that the webservice call is succesful and that it gets all the records, but it passes the last record to my Query.

I have tried using extract_from_json right after the call in a Query, but thats pointless as I only get the last record from my Query where I am doing the call.

Does anyone know how I can get all the records with my function call?

[Former Member]

Hi Dirk,

Unfortunatly this is not a public service. Its one protected with keys etc.
It always gets the last record, so I guess the processing of arrays is not being handled correctly.
I will be making a ticket for SAP in the coming days.

[christian_kinne]

Hi G K,

can you please share the answer from SAP, we have the same problem and no idea anymore - his would help us very much.

[former_member744493]

Have the same problem rendering single record. Need help. Thank you.

[former_member187605]

Is this a public service anyone can test? Just asking. Because I don't even manage to get a single record in my tests:-(.

Tracing transforms shows all records though, as for you.

Have you contacted SAP support?