topic Re: xpath query for json file in Talend Studio

xpath query for json file

bhagyarekha — Sat, 16 Nov 2024 10:16:53 GMT

Hi Talend Team,
I have json file and need to be inserted into mysql database.
so here am unable to fetch the data from one of the array.please help me out
Am using xpath query.
example
xyz:
here i need to get "abc" in one column and "def" in another column.am unable to write the Xpath for that one.
Appreciate for your response.
Regards,
rekha

Re: xpath query for json file

avinashbasetty — Thu, 03 Nov 2016 13:26:03 GMT

Hi,
The json format you provided is incorrect. you can check this validator https://jsonformatter.curiousconcept.com/
Once you checked it you can browse it from the JSON format available in the metadata where you can fetch the columns.
Valid JSON
{
"xyz":
{
"col1":,
"col2":
}
}

Regards,
Avinash.B
8885453419

Re: xpath query for json file

Anonymous — Thu, 03 Nov 2016 19:15:54 GMT

Hi avinashbasetty,
have you an idea how I can get the position of a data on a json file.
Example:
Input file
{
    "product":
    }]
}
resul wished:
Product        productPrice_position    name
12-0000027935      0      First Component MR Price
12-0000027935            1    First Component's OT price
thanks