Skip to Content
0

Extracting JSON data using Data services

Jun 23, 2017 at 02:38 PM

321

avatar image
S N

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

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

Thanks for pointing out.

Checking with DBA if there's any limit.

0