Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to convert the txmlmap columns to json in this format.
Expected output:
{
"addresses": [
{
"request_id": "00Qa000001UIjN7",
"street": "565 de la montagne street",
"city": "Valcourt",
"state_code": "CA-QC",
"country_code": "CA",
"postal_code": "J0E 2L0",
"geo_location": {
"type": "Point",
"coordinates": [
-72.303871,
45.488386
]
}
},
{
"request_id": "00Qa000005545",
"street": "2050 andré",
"city": "sherbrooke",
"state_code": "CA-QC",
"country_code": "CA",
"postal_code": "J1H 6C4",
"geo_location": {
"type": "Point",
"coordinates": [
-72.303871,
45.488386
]
}
}
]
}
but it is always supplied in 2 different objects I do not why;, her what I get:
{"addresses":[{"request_id":"00Qa000001UIjN7","street":"565 RUE DE LA MONTAGNE","city":"VALCOURT","state_code":"QC","country_code":"CAN","postal_code":"J0E 2L0","geo_location":{"type":"Point","coordinates":["45.49133","-72.312679"]}}]}
{"addresses":[{"request_id":"00Qa000005545","street":"2050 RUE ANDRÉ","city":"SHERBROOKE","state_code":"QC","country_code":"CAN","postal_code":"J1H 6C4","geo_location":{"type":"Point","coordinates":["45.373436","-71.9029483"]}}]}
here, my job:
txmlmap content, I added a coloumn loop and made it as output in twritejsonfield. people said it resolve the problem. But, not in my case
My content twritejsonfield:
did you add group by (in standard properties of tWriteJSONFields)?
as I understand your structure - group by column loop
Yes I did that. I still have the same problem