Extracting JSON data using Data services

[former_member185138]

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.

[former_member187605 · Accepted solution]

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

Extract_from_json built-in function.

[former_member185138 · Accepted solution]

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

[former_member187605 · Accepted solution]

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:

[former_member185138 · Accepted solution]

Thanks for pointing out.

Checking with DBA if there's any limit.