How to load JSON data in SAP BO Data Services

[former_member557846]

Hello, I wanted to know how can I load json data in Data Services.

I looked for this example (https://blogs.sap.com/2015/07/28/how-to-use-a-baseuserdefined-transform-in-data-services-4x-to-return-json-web-service-data/) but i'm getting some errors related with the phyton codes and libraries, when the "Base_UserDefined" transform calls the function/executes the phyton code from the linked example. It looks like there are some missing libraries or they are not as SAP Data Services/function call would expect to be

Error examples:

1) Transform <Base_UserDefined>: Traceback (most recent call last): File "EXPRESSION", line 3, in <module> File "C:\SAPBO\Data Services\DataQuality\python\lib\urllib2.py", line 120, in <module> from urllib import unwrap, unquote, splittype, splithost, \ ImportError: cannot import name splitgophertype.

2) Transform Base_UserDefined Transform <Base_UserDefined>: Traceback (most recent call last): File "EXPRESSION", line 3, in <module> File "C:\SAPBO\Data Services\DataQuality\python\lib\urllib2.py", line 106, in <module> import gopherlib

3) Transform Base_UserDefined Transform <Base_UserDefined>: Traceback (most recent call last): File "EXPRESSION", line 21, in <module> File "EXPRESSION", line 6, in main File "flpythonmodulesu.py", line 90, in <lambda> __getattr__ = lambda self, name: _swig_getattr(self, FlDataCollection, name) File "flpythonmodulesu.py", line 34, in _swig_getattr raise AttributeError,name AttributeError: size.

Is there another way to load JSON data (for exemple from a URI) to Data Services. I read something about Adapters, but i'm not familiar with that, can anyone help me to understand how does that work (if using Adapters it is actually the "best" solution, because the examples i saw where a little bit old, so i think there must be more recent solutions).

Thank you.