Six Stars

Could not able to process json file

Hi,

I have this below json file which I am trying to load; but for some reason it is not loading, can someone help me on what I am doing wrong and how to fix this problem?

 

Here is the input file json content.

[{"_id":"58aa280da9d3b3ea55d12255","_acl":{"creator":"58a516f6a9d3b3ea55ba6015"},"_kmd":"{\"lmt\":\"2017-02-19T23:23:56.228Z\",\"ect\":\"2017-02-19T23:19:41.721Z\"}","title":"\"SAMHSA IOP for People With Stimulant Disorders - Lessons 16-18\"","lessons":"[{\"title\":\"Taking Care of Yourself\",\"files\":[{\"mimetype\":\"application/pdf\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"1_Taking Care of Yourself_RP17.pdf\",\"size\":372530,\"mimeType\":\"application/pdf\",\"_id\":\"8efef185-81ce-4e03-b93b-ece3100a6af3\",\"_kmd\":{\"lmt\":\"2017-02-19T22:55:59.532Z\",\"ect\":\"2017-02-19T22:55:59.532Z\"},\"_data\":{}},{\"mimetype\":\"audio/mp3\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"Taking Care of Yourself v1.mp3\",\"size\":2464280,\"mimeType\":\"audio/mp3\",\"_id\":\"451a7b09-9914-4ab8-a5c7-e558a2be9dfb\",\"_kmd\":{\"lmt\":\"2017-02-19T22:55:59.576Z\",\"ect\":\"2017-02-19T22:55:59.576Z\"},\"_data\":{}},{\"mimetype\":\"video/mp4\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"Taking Care of Yourself v1.mp4\",\"size\":18109630,\"mimeType\":\"video/mp4\",\"_id\":\"d85d3d74-65dc-44cb-b3ff-b632b538051c\",\"_kmd\":{\"lmt\":\"2017-02-19T22:55:59.596Z\",\"ect\":\"2017-02-19T22:55:59.596Z\"},\"_data\":{}}],\"textAvailable\":true,\"audioAvailable\":true,\"videoAvailable\":true,\"id\":1487546380,\"completion\":0,\"time\":\"\",\"revisits\":0,\"comprehension\":0},{\"title\":\"Emotional Triggers\",\"files\":[{\"mimetype\":\"application/pdf\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"1_Emotional Triggers_RP18.pdf\",\"size\":773714,\"mimeType\":\"application/pdf\",\"_id\":\"ea433f52-33ca-4633-ac04-3c0673c25bcb\",\"_kmd\":{\"lmt\":\"2017-02-19T23:20:03.995Z\",\"ect\":\"2017-02-19T23:20:03.995Z\"},\"_data\":{}},{\"mimetype\":\"audio/mp3\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"Emotional Triggers v1.mp3\",\"size\":3889265,\"mimeType\":\"audio/mp3\",\"_id\":\"a2567abf-7a77-465e-9e19-9f016599332d\",\"_kmd\":{\"lmt\":\"2017-02-19T23:20:04.052Z\",\"ect\":\"2017-02-19T23:20:04.052Z\"},\"_data\":{}},{\"mimetype\":\"video/mp4\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"Emotional Triggers v1.mp4\",\"size\":40687636,\"mimeType\":\"video/mp4\",\"_id\":\"46c182ae-f368-43a9-9328-e9a288f28bc2\",\"_kmd\":{\"lmt\":\"2017-02-19T23:20:30.194Z\",\"ect\":\"2017-02-19T23:20:30.194Z\"},\"_data\":{}}],\"textAvailable\":true,\"audioAvailable\":true,\"videoAvailable\":true,\"id\":1487546516,\"completion\":0,\"time\":\"\",\"revisits\":0,\"comprehension\":0},{\"title\":\"Relapse Justification 2\",\"surveyUrl\":\"https://surveys.itetherllc.com/s3/Crossroads-IOP-Lessons-16-18\",\"files\":[{\"mimetype\":\"application/pdf\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"1_Relapse Justification 1_RP16.pdf\",\"size\":396820,\"mimeType\":\"application/pdf\",\"_id\":\"8e8d109f-ba21-487b-85f9-47d348eb5bd0\",\"_kmd\":{\"lmt\":\"2017-02-19T23:22:31.484Z\",\"ect\":\"2017-02-19T23:22:31.484Z\"},\"_data\":{}},{\"mimetype\":\"audio/mp3\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"Relapse Justification 1 v1.mp3\",\"size\":3808645,\"mimeType\":\"audio/mp3\",\"_id\":\"d3e2e572-1867-4eae-808e-2478abe35995\",\"_kmd\":{\"lmt\":\"2017-02-19T23:22:31.491Z\",\"ect\":\"2017-02-19T23:22:31.491Z\"},\"_data\":{}},{\"mimetype\":\"video/mp4\",\"_acl\":{\"gr\":true,\"creator\":\"58a516f6a9d3b3ea55ba6015\"},\"_filename\":\"Relapse Justification 1 v1.mp4\",\"size\":24939476,\"mimeType\":\"video/mp4\",\"_id\":\"a9b3a3d8-5dfe-4d29-ab44-322e259a3df2\",\"_kmd\":{\"lmt\":\"2017-02-19T23:22:31.521Z\",\"ect\":\"2017-02-19T23:22:31.521Z\"},\"_data\":{}}],\"textAvailable\":true,\"audioAvailable\":true,\"videoAvailable\":true,\"id\":1487546635,\"completion\":0,\"time\":\"\",\"revisits\":0,\"comprehension\":0}]","programType":"\"IOP\"","count":10421}]

It is not showing any errors/warnings either.

You can get the job which i am using from the attachment, can someone brief me where I am doing wrong.

1 REPLY
Moderator

Re: Could not able to process json file

Hi,

Could you please also indicate which talend build version you are using? In this way, we can import your job(.zip file) into studio for a testing.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.