
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DynamoDB to JSON parsing issue
Hi,
We are performing a SCAN operation on dynamodb using tDynamoDBInput connector, the output we get is comma seperated Key=value pairs, we are getting parsing error as some of our field values have comma characters in them, is there a way that we can enable quote characters around Key=Value pairs or any other way to get around this issue?
Here is a sample record that we get from tDynamoDBInput connector, notice that there is a comma in the notes field which is causing us grief during parsing.
{actionTime=2019-01-28T09:46:55.726Z, clientId=20, notes=98120327900431,1, accountName=xxxxxx, clientName=yyyyyy, currentStatus=Cancelled, actionBy=3f234f35-e972-4b8d-b4c9-bbaae73468e6, reclaimCode=968320, description=98120190327900431, customerOrderNumber=981201903270431, accountId=9, deliveryId=2109, action=Cancel, pickupCode=9796, deliveryCode=7023, previousStatus=Created}
Note: we are converting this to a JSON string.
Thanks & Regards,
SaiSridhar N

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Could you please clarify what's talend build version are you using?
Best regards
Sabrina
