Consuming SOAP Web Service with DataFlux DM Studio

ea33 — Tue, 30 Mar 2021 23:10:09 GMT

I'm trying to consume a 3rd Party SOAP Web Service using a Job in Data Management Studio, the "Web Service Node" under "Data Integration" to be specific.

I'm having 2 issues with this. They're separate issues but I figured I'd include them both here.

Issue 1:

One of the available SOAP Actions (GetTables) has different metadata response formats based on what parameter you send (I think this means response is complex type, not very familiar with SOAP/SOAP XMLs). Using "Discovery" in the Web Service Node I get the following when selecting this particular action:

I've tried manually entering the response for a specific parameter, but no luck.

Issue 2:

A response for an Action (GetUpdatedFC) returns up to 1,000 rows, I've added all the response fields to the output and it runs with no problems but the result of this call is only 1 row, it seems to be the first row returned, nothing about the other 999 rows.

For reference:

Will like to keep this strictly to DM Job if possible (no SAS code, but if needed, that's fine)

General flow of data job is: 1.Authenticate and get a token 2.Use token for following calls

WSDL for Web Service:

https://www.argusmedia.com/ArgusWSVSTO/ArgusFC.asmx?wsdl

Also, all the actions work in SOAPUI with no issues, so there no issues on the vendor's side.

Re: Consuming SOAP Web Service with DataFlux DM Studio

VincentRejany — Tue, 06 Apr 2021 20:04:34 GMT

As far as I know the web service node has some limitations:

it supports on WSDL 1.1
the call is made for each record
it is not possible to output the XML response, you only have the parsed input.

If your endpoint supports REST, you should prefer that approach or use an external command with curl

topic Consuming SOAP Web Service with DataFlux DM Studio in SAS Data Management

Consuming SOAP Web Service with DataFlux DM Studio

Re: Consuming SOAP Web Service with DataFlux DM Studio