Five Stars

Example usage for textractjsonfields against Oracle database

Is there an example of how to extract JSON fields if the JSON is stored in a database e.g. Oracle? If so, how would it work in conjunction with tJSONExtractFields component?

7 REPLIES
Twelve Stars

Re: Example usage for textractjsonfields against Oracle database

Please find the example in below link.

 

http://umashanthan.blogspot.in/2015/11/json-path-expression-for.html

Manohar B
Five Stars

Re: Example usage for textractjsonfields against Oracle database

Thanks for the example, but I do not see any example where the JSON is coming from a database e.g. Oracle. Please advise.

Twelve Stars

Re: Example usage for textractjsonfields against Oracle database

Can you show me the data of Json field?

Manohar B
Five Stars

Re: Example usage for textractjsonfields against Oracle database

Attached

Five Stars

Re: Example usage for textractjsonfields against Oracle database

Bumping

Twelve Stars

Re: Example usage for textractjsonfields against Oracle database

can you just provide the smaple data for that json column ,which is coming from orcale

Manohar B
Twelve Stars

Re: Example usage for textractjsonfields against Oracle database

@js_support,still you have this issue?

Manohar B