Skip to Content
G K

SAP Data Services webservice json gives only last record

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 08, 2018 at 09:10 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 21, 2018 at 08:47 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded