Re: ConvertJSONToSQL - Ignores underscore in updat...

MPraveen · ‎04-05-2020

Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.

MPraveen · ‎04-05-2020

Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below replace with - underscore.

MPraveen · ‎04-05-2020

Great and Thanks for detailed answer. I will take a look and apply the logic.

MPraveen · ‎04-05-2020

Thanks for your answer Steven. Yes there are customizations to AttributesToJson and ConvertJsonToSql.

MPraveen · ‎03-30-2020

XML->JSON->oracle tables. My flow Get the JSON file and form a required JSON format(JoltTransform) for 1 table and route to operations - ADD/MODIFY/REMOVE based on JSON file content for db insert - from routeAttributes ->AttributeToJSON->convertJSONtoSQL ->putSQL ADD- Insert,MODIFY-Update and REMOVE-Delete from table. So here for one table - I have three AttributeToJSON and convertJSONtoSQL

MPraveen · ‎03-30-2020

XML->JSON->oracle tables. For example: I have 5 tables. For some reason 3rd table load fails then 1,2,3 tables should be rollback by not sitting in partial state. My flow Get the JSON file and form a required JSON format(JoltTransform) for 5 tables and route to all 5 tables(doing operations in each table - ADD/MODIFY/REMOVE based on JSON file content) for db insert - from routeAttributes ->convertJSONtoSQL ->putSQL ADD- Insert,MODIFY-Update and REMOVE-Delete from table.

MPraveen · ‎03-30-2020

Thanks Steven

MPraveen · ‎03-30-2020

I resolved the issue(${sql.args.1.value:toDate("yyyy-MM-dd"):toNumber()}).. But I dont understand why we need toNumber() here. Any body have answer to this ?

MPraveen · ‎03-29-2020

I am facing an issue - in PutSQL I am sending a date value from XML-JSON->oracle table. EvaluateJSOn ->RouteAttributes->AttributeJson->ConvertJsontoSQL -> UpdateAttrubites->PutSQL is my flow. But it is failing always with

MPraveen · ‎03-25-2020

Thanks @stevenmatison . worked perfectly..

MPraveen · ‎03-22-2020

Eg: Update table table_name emp_name=? where empid=? But My column name is emp_id

MPraveen · ‎03-22-2020

Have you resolved the issue ?

MPraveen · ‎03-22-2020

My file: "ws:Operation": "ADD", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thaler" In above example i need to send the content:Dr. Leah Thaler to insert My file: "ws:Operation": "MODIFY", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thal" In above example i need to send the content:Dr. Leah Thaler to update. Database is Oracle - the flow: Getfile-> EvaluateJSONPath -> send the data to two tables using AttributesToJSON for flatten JSON -> ConvertJSONSQL to Putsql. Note: I dont want to write AVRO schema. So we build this flow

MPraveen · ‎03-11-2020

Do you got answer for this?? My question is also same

Online	Offline
Last Visited	‎08-03-2020 11:47 PM

Date Registered	‎02-27-2020 02:14 PM
Last Visited	‎08-03-2020 11:47 PM
Total Messages Posted	16
Total Kudos Received	2

Re: ConvertJSONToSQL - Ignores underscore in updat...

Re: PUTSQL which cannot be converted to a timestam...

Re: JSON file with operation values ADD/MODIFY ba...

Re: ConvertJSONToSQL - Ignores underscore in updat...

Re: ConvertJSONToSQL - Ignores underscore in updat...

Re: How to Rollback all Tables -if load fails in p...

Re: How to avoid AttributesTOJSON and ConvertJSONT...

How to avoid AttributesTOJSON and ConvertJSONToSQL...

How to Rollback all Tables -if load fails in parti...

Re: PUTSQL which cannot be converted to a timestam...

Re: PUTSQL which cannot be converted to a timestam...

PUTSQL which cannot be converted to a timestamp

Re: JSON file with operation values ADD/MODIFY ba...

ConvertJSONToSQL - Ignores underscore in update ke...

Re: I want to insert and update data at the same t...

JSON file with operation values ADD/MODIFY based ...

Re: What is the proper AVRO schema for XML that us...