Has anybody consumed RESTFUL webservice in data services 4.2 ?
I am finding issues using it, not sure if WADL file is not in right format (with correct grammar), however I am able to preview it using SOAPUI.
The output format is JSON.
Can somebody provide me the clue or step by step process to consume ?
I am attaching a job (atl file) and verbose trace log, that I created created to consume REST webservice, though I am not getting any error, but nothing has been loaded to table.
In verbose trace log I could see the transactions in JSON format, but some how those transactions are not trapped into target table.
There are no input Parameters for this job.
The wadl has been tested using soapUI
I have also Unnested the Reply Schema as well
Can you please have a look at the job and let me know if I am missing something.
let me take a look, you are able to get a response, but looks like DS is having problem converting the JSON to NRDM (DS Nested Structure), this issue usually happens if there is schema mismatch, but I don’t think that is the case
looking at the DS version in the trace and XML, you are on Ds 4.2 SP2 Patch, there were some fixes related to JSON to NRDM conversion when result has multiple records, possibly it’s the same issue
let me check that
is it possible for you to use the latest DS 4.2 version ? DS 4.2 SP04
can you try this, you can use JSON as source also, so lets see if DS is able to parse the JSON returned by the service
use the attached JSON to create a JSON format
create a JSON source using this format in DF, enter the file location pointing to the location of attached file
Click on the magnifying glass icon to see the data, if this works then I would expect the RESTFul service response to work too aircraftDetails.zip (0.0 KB)