https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355477#M121219 <P>Hi, I need to read the below format of json file and replace values mentioned as @1,@2,@3... so on using values from context variables. I then need to generate an output json in the same structure.</P><P></P><P></P><P>{</P><P> "configSparkApp": {</P><P> "applicationName": "",</P><P> "master": "",</P><P> "deployMode": "",</P><P> "driverMemory": "",</P><P> "numExecutors": "",</P><P> "executorCores": "",</P><P> "executorMemory": "",</P><P> "yarnPool": "",</P><P> "logLevel": "",</P><P> "logHdfsRootPath": "",</P><P> "log4jConfigFileDriver": "",</P><P> "log4jConfigFileExecutor": ""</P><P> },</P><P> "source": {</P><P> "dataWarehouseType": "stringvalue",</P><P> "configKudu": {</P><P> "kuduMaster": "",</P><P> "kuduPort": "",</P><P> "configTableKudu": [{</P><P> "databaseName": "stringvalue",</P><P> "tableName": ""</P><P> }</P><P> ]</P><P> },</P><P> "configHive": [{</P><P> "databaseName": "@1",</P><P> "tableName": "@2",</P><P> "tableFormat": "stringvalue"</P><P> }</P><P> ]</P><P> },</P><P> "dataPreparation": {</P><P> "dataFramePrepared": [{</P><P> "dataframeName": "@3",</P><P> "query": "@4",</P><P> "parameterPosition": "stringvalue"</P><P> }</P><P> ]</P><P> },</P><P> "rule": {</P><P> "relation": "",</P><P> "validationColumnName": "stringvalue",</P><P> "validationRule": "@5",</P><P> "inScopeRule": "",</P><P> "exception": [{</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "stringvalue",</P><P> "columnPosition": ""</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "'stringvalue'",</P><P> "columnPosition": ""</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "@6",</P><P> "columnPosition": ""</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "@7",</P><P> "columnPosition": ""</P><P> }</P><P> ],</P><P> "summary": {</P><P> "configSummary": [</P><P> &nbsp;&nbsp;{</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "cast('@3' as string)"</P><P> }, </P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> }</P><P> ],</P><P> "aggColumnSummary": [</P><P> &nbsp;&nbsp;{</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> &nbsp;&nbsp;{</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> }</P><P> ]</P><P> }</P><P> }</P><P>}</P><P></P><P></P><P></P><P></P><P>Please let me know how it is possible to manipulate a json of this structure via Talend and what components I'll need to use.</P> Fri, 15 Nov 2024 21:31:49 GMT SMishra1690799251 2024-11-15T21:31:49Z https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355477#M121219 <P>Hi, I need to read the below format of json file and replace values mentioned as @1,@2,@3... so on using values from context variables. I then need to generate an output json in the same structure.</P><P></P><P></P><P>{</P><P> "configSparkApp": {</P><P> "applicationName": "",</P><P> "master": "",</P><P> "deployMode": "",</P><P> "driverMemory": "",</P><P> "numExecutors": "",</P><P> "executorCores": "",</P><P> "executorMemory": "",</P><P> "yarnPool": "",</P><P> "logLevel": "",</P><P> "logHdfsRootPath": "",</P><P> "log4jConfigFileDriver": "",</P><P> "log4jConfigFileExecutor": ""</P><P> },</P><P> "source": {</P><P> "dataWarehouseType": "stringvalue",</P><P> "configKudu": {</P><P> "kuduMaster": "",</P><P> "kuduPort": "",</P><P> "configTableKudu": [{</P><P> "databaseName": "stringvalue",</P><P> "tableName": ""</P><P> }</P><P> ]</P><P> },</P><P> "configHive": [{</P><P> "databaseName": "@1",</P><P> "tableName": "@2",</P><P> "tableFormat": "stringvalue"</P><P> }</P><P> ]</P><P> },</P><P> "dataPreparation": {</P><P> "dataFramePrepared": [{</P><P> "dataframeName": "@3",</P><P> "query": "@4",</P><P> "parameterPosition": "stringvalue"</P><P> }</P><P> ]</P><P> },</P><P> "rule": {</P><P> "relation": "",</P><P> "validationColumnName": "stringvalue",</P><P> "validationRule": "@5",</P><P> "inScopeRule": "",</P><P> "exception": [{</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "stringvalue",</P><P> "columnPosition": ""</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "'stringvalue'",</P><P> "columnPosition": ""</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "",</P><P> "columnPosition": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "@6",</P><P> "columnPosition": ""</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnCalculated": "stringvalue",</P><P> "columnLogic": "@7",</P><P> "columnPosition": ""</P><P> }</P><P> ],</P><P> "summary": {</P><P> "configSummary": [</P><P> &nbsp;&nbsp;{</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "cast('@3' as string)"</P><P> }, </P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> }</P><P> ],</P><P> "aggColumnSummary": [</P><P> &nbsp;&nbsp;{</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> &nbsp;&nbsp;{</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> },</P><P> {</P><P> "columnName": "stringvalue",</P><P> "columnLogic": "stringvalue"</P><P> }</P><P> ]</P><P> }</P><P> }</P><P>}</P><P></P><P></P><P></P><P></P><P>Please let me know how it is possible to manipulate a json of this structure via Talend and what components I'll need to use.</P> Fri, 15 Nov 2024 21:31:49 GMT https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355477#M121219 SMishra1690799251 2024-11-15T21:31:49Z https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355478#M121220 <P>To read , edit values , and generate a complex JSON file programmatically , you ca use a programming language with JSON support , such as Python.</P> Tue, 01 Aug 2023 05:47:59 GMT https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355478#M121220 victormarcel 2023-08-01T05:47:59Z https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355479#M121221 <P>Hi @John Kimber​&nbsp;, thanks for replying</P><P>&nbsp;</P><P>Using Talend is necessary for my requirement, is there any way we can incorporate a custom python code in Talend</P> Tue, 01 Aug 2023 15:46:03 GMT https://community.qlik.com/t5/Talend-Studio/Reading-Editing-values-and-Generating-a-complex-json-file/m-p/2355479#M121221 SMishra1690799251 2023-08-01T15:46:03Z