topic Re: Example usage for textractjsonfields against Oracle database in Talend Studio

Example usage for textractjsonfields against Oracle database

js_support — Tue, 06 Mar 2018 00:26:24 GMT

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?

Re: Example usage for textractjsonfields against Oracle database

manodwhb — Tue, 06 Mar 2018 06:47:09 GMT

Please find the example in below link.

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

Re: Example usage for textractjsonfields against Oracle database

js_support — Tue, 06 Mar 2018 17:02:01 GMT

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

Re: Example usage for textractjsonfields against Oracle database

manodwhb — Wed, 07 Mar 2018 11:45:44 GMT

Can you show me the data of Json field?

Re: Example usage for textractjsonfields against Oracle database

js_support — Wed, 07 Mar 2018 15:49:22 GMT

Attached

jsonextract_sample.zip

Re: Example usage for textractjsonfields against Oracle database

js_support — Thu, 08 Mar 2018 16:57:38 GMT

Bumping

Re: Example usage for textractjsonfields against Oracle database

manodwhb — Fri, 09 Mar 2018 04:24:40 GMT

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

Re: Example usage for textractjsonfields against Oracle database

manodwhb — Tue, 03 Apr 2018 14:20:07 GMT

@js_support,still you have this issue?