RTDM – approach to web service and get grid variable in Reply

[RTDM_User]

Hi,

I need to approach a web service from rtdm campaign to Web Service and get in return few variables that one of them is in data grid structure.

I guess it’s possible with OOTB Web Process or Groovy / DS2 code in sas process and then parse it in the suitable structure.

What would be the better option and how to implement it?

TNX.

[JamesAnderson]

Hi,

The RTDM Web Process only supports a SOAP web service call and doesn't support Data grid data type (see Pg 162 of the RTDM 6.5 admin guide for supported types).

So your choices are coding it in DS2, Groovy or Jython. The type of webservice you are calling is likely to impact your choice of language.

SAS 9.4 M3 introduced the DS2 JSON package, so if you are on a release prior to that its a bit messy to work with JSON (although possible). So if you need to call a REST JSON webservice and you are on an older release, then use Groovy or Jython. Otherwise its really a choice of what you prefer to code with, and what is more suited to your organsation/customer.

Regards

James