DynamoDB to JSON parsing issue

[talendsai]

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

[Anonymous]

Hello,

Could you please clarify what's talend build version are you using?

Best regards

Sabrina