Create Json File From Excel

[heshkaru]

{ "index" : { } }

{ "ENV":"DEV", "BATCH_ID": "2023-12-16 08:27:16", "EXPECTED_VALUE":"ADDQYU5B", "ACTUAL_VALUE":"dbdf24" }

{ "index" : { } }

{ "ENV":"DEV", "BATCH_ID": "2023-12-16 08:27:16", "EXPECTED_VALUE":"25325", "ACTUAL_VALUE":"vbdb3" }

{ "index" : { } }

{ "ENV":"DEV", "BATCH_ID": "2023-12-16 08:27:16", "EXPECTED_VALUE":"bdbd42", "ACTUAL_VALUE":"gdg42" }

/////////////////////////////////////////////////////////////////////////////////////

I need to create a json file which have the following json objects extracted from an excel. This output is used for ElasticSearch Indexing. This specific format should be maintained.

Thank you

[Anonymous]

Hi

Does this command run fine in Linux terminal? If yes, you use tSystem in Talend job to run this command.

Regards

Shong

[heshkaru]

Hi @Shicong Hong​ 

Does tSystem refers to command prompt in windows, for me it doesn't work from command prompt (Im using a windows machine), but I have installed another shell script where I can run linux commands, it works there. Does this component have an impact base on the OS its working

[Anonymous]

I thought you are using Linux OS, as CURL is a built-in command on Linux. If you are using Windows OS, you should learn how to get CURL working on Windows. tSystem run a system command as you run it in a command prompt on your OS.