xpath query for json file

[bhagyarekha]

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 

[avinashbasetty]

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

[Anonymous]

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