How to load json api into database using talend

Question

I am new in Talend. this is my api => http://api.dss.adapt-odisha.com/aagro?url=https://mausam.imd.gov.in/api/warnings_district_api.php

this is created design =>

in tXMLMap

But when i am running this i am not getting data

How can i solve this issue?

Ibrahim Mezouar · Answer 1 · 2020-08-14T10:17:34.027

1

Your api returns a json, but tRESTClient converts it to xml by default, because of "Convert response to DOM Document" setting.
I unchecked that setting, and used tExtractJSONFields to parse the json, it's working as expected.

Here's the schema of tExtractJSONFields

edited Aug 14 '20 at 10:17

answered Aug 14 '20 at 09:19

Ibrahim Mezouar

3,981
1
18
22

Do i have to write all column names in Mapping field? or automatically it can come? – aashu1807 Aug 14 '20 at 09:47
How to do mapping here? – aashu1807 Aug 14 '20 at 09:50
can you please show me the how you did mapping in edit schema? – aashu1807 Aug 14 '20 at 10:00
You need to add all the columns to tExtractJSONFields schema in order to see them in the mapping. I've updated my answer – Ibrahim Mezouar Aug 14 '20 at 10:17
I did the exact the way you did. But still not getting data on tLogRow. Can you please share me this job? – aashu1807 Aug 14 '20 at 10:34
Please make sure you select the column "string" and not "body" in tExtractJSONFields "Json field" setting – Ibrahim Mezouar Aug 14 '20 at 10:36
for above link its working fine. but the same thing i tried on my another link http://api.dss.adapt-odisha.com/aagro?url=https://mausam.imd.gov.in/api/nowcast_district_api.php then wrong data is showing on tLogRow. Why? – aashu1807 Aug 14 '20 at 11:20
Well you need to change the mapping according to your data, the json is not the same ! – Ibrahim Mezouar Aug 14 '20 at 11:34
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/219809/discussion-between-aashu1807-and-ibrahim-mezouar). – aashu1807 Aug 14 '20 at 11:58
I created new job and you can see my updated question's last image. Here i mentioned all keys. But getting wrong data in my database or tLogRow. Why – aashu1807 Aug 14 '20 at 11:59

How to load json api into database using talend

1 Answers1