Skip to Content
0

Extracting JSON data using Data services

Jun 23, 2017 at 02:38 PM

424

avatar image
Former Member

Hi Experts,

We have one column in Mysql DB(long data type) holding the data in JSON format.

What should be the best approach to extract the data considering I dont know how to write SDK.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
Jun 27, 2017 at 07:57 AM
-1

RT*M. SAP Data Services Reference Guide (help.sap.com).

Extract_from_json built-in function.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for the reply Dirk.

As I said we have long data type which BODS cant work with so I converted it to varchar and used as JSON field in Extract_from_json.

Got following error after this:

Row size too large. The maximum row size for the used table type, not counting 2112418484DBS-07040427/06/2017 11:02:02BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs>. The SQL

0

When do you get this error? Not when executing the function, I assume. Correct?

There's no limit on varchar lengths in DS. From the same Reference Guide:

1
Former Member

Thanks for pointing out.

Checking with DBA if there's any limit.

0