tExtractJsonFields component under loop json path ... - Qlik Community

SAP_Vijay · ‎2021-11-29

Hi Experts

I am using tREST component to extract the online book data and decode the json data and write the data on the console. When I excecated the job i don't get any error but when i check the console i get the error as

Missing property in path $['results']

I tested the below open link on the postman with necessary secrete keys its worked fine. But i dont know this error.

Please see the attachment. Kindly help in solving the issue.

Thanks and Regards

Vijay

Anonymous · ‎2021-12-01

Hello,

Could you please post your screenshots of the source schema and target schema on community? How many loops in it?

Best regards

Sabrina

SAP_Vijay · ‎2021-12-02

Hi Xdshi

Please find the my job details and JSON format.

and JSON details

"status":"OK",

"num_results":15,

"last_modified":"2021-12-01T23:08:57-05:00",

"results":{

"list_name":"Hardcover Fiction",

"list_name_encoded":"hardcover-fiction",

"bestsellers_date":"2021-11-27",

"published_date":"2021-12-12",

"published_date_description":"latest",

"next_published_date":"",

"previous_published_date":"2021-12-05",

"display_name":"Hardcover Fiction",

"normal_list_ends_at":15,

"updated":"WEEKLY",

"books":[

{

"rank":1,

"rank_last_week":0,

"weeks_on_list":1,

"asterisk":0,

"dagger":0,

"primary_isbn10":"1101885688",

"primary_isbn13":"9781101885680",

"publisher":"Delacorte",

"description":"The ninth book in the Outlander series. As the Revolutionary War moves closer to Fraser’s Ridge, Claire and Jamie reunite with their daughter and her family.",

"price":"0.00",

"title":"GO TELL THE BEES THAT I AM GONE",

"author":"Diana Gabaldon",

"contributor":"by Diana Gabaldon",

"contributor_note":"",

"book_image":"https://storage.googleapis.com/du-prd/books/images/9781101885680.jpg",

"book_image_width":329,

"book_image_height":500,

"amazon_product_url":"https://www.amazon.com/dp/1101885688?tag=NYTBSREV-20",

"age_group":"",

"book_review_link":"",

"first_chapter_link":"",

"sunday_review_link":"",

"article_chapter_link":"",

"isbns":[

{

"isbn10":"1101885688",

"isbn13":"9781101885680"

},

{

"isbn10":"1101885696",

"isbn13":"9781101885697"

}

],

"buy_links":[

{

"name":"Amazon",

"url":"https://www.amazon.com/dp/1101885688?tag=NYTBSREV-20"

},

{

"name":"Apple Books",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=GO+TELL+THE+BEES+THAT+I+AM+GONE&author=Diana+Gabaldon"

},

{

"name":"Barnes and Noble",

"url":"https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781101885680"

},

{

"name":"Books-A-Million",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FGO%252BTELL%252BTHE%252BBEES%252BTHAT%252BI%252BAM%252BGONE%252FDiana%252BGabaldon%252F9781101885680&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DGO%252BTELL%252BTHE%252BBEES%252BTHAT%252BI%252BAM%252BGONE%252BDiana%252BGabaldon"

},

{

"name":"Bookshop",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781101885680&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Fkeywords%3DGO%2BTELL%2BTHE%2BBEES%2BTHAT%2BI%2BAM%2BGONE"

},

{

"name":"IndieBound",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781101885680%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DGO%2BTELL%2BTHE%2BBEES%2BTHAT%2BI%2BAM%2BGONE%2BDiana%2BGabaldon%26aff%3DNYT"

}

],

"book_uri":"nyt://book/e400e1f2-adea-5edd-bc06-f5571a7921fa"

};

The API link is tested in postman also. It workded fine. When i call the API in talend i am getting that error.

The JSON is also validated it is correct. Something problem in talend.

Please let me know what issue i am making.

Thanks and Regards

Vijay

SAP_Vijay · ‎2021-12-02

Hi Xdshi

Please find the my job details and JSON format.

and JSON details

"status":"OK",

"num_results":15,

"last_modified":"2021-12-01T23:08:57-05:00",

"results":{

"list_name":"Hardcover Fiction",

"list_name_encoded":"hardcover-fiction",

"bestsellers_date":"2021-11-27",

"published_date":"2021-12-12",

"published_date_description":"latest",

"next_published_date":"",

"previous_published_date":"2021-12-05",

"display_name":"Hardcover Fiction",

"normal_list_ends_at":15,

"updated":"WEEKLY",

"books":[

{

"rank":1,

"rank_last_week":0,

"weeks_on_list":1,

"asterisk":0,

"dagger":0,

"primary_isbn10":"1101885688",

"primary_isbn13":"9781101885680",

"publisher":"Delacorte",

"description":"The ninth book in the Outlander series. As the Revolutionary War moves closer to Fraser’s Ridge, Claire and Jamie reunite with their daughter and her family.",

"price":"0.00",

"title":"GO TELL THE BEES THAT I AM GONE",

"author":"Diana Gabaldon",

"contributor":"by Diana Gabaldon",

"contributor_note":"",

"book_image":"https://storage.googleapis.com/du-prd/books/images/9781101885680.jpg",

"book_image_width":329,

"book_image_height":500,

"amazon_product_url":"https://www.amazon.com/dp/1101885688?tag=NYTBSREV-20",

"age_group":"",

"book_review_link":"",

"first_chapter_link":"",

"sunday_review_link":"",

"article_chapter_link":"",

"isbns":[

{

"isbn10":"1101885688",

"isbn13":"9781101885680"

},

{

"isbn10":"1101885696",

"isbn13":"9781101885697"

}

],

"buy_links":[

{

"name":"Amazon",

"url":"https://www.amazon.com/dp/1101885688?tag=NYTBSREV-20"

},

{

"name":"Apple Books",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=GO+TELL+THE+BEES+THAT+I+AM+GONE&author=Diana+Gabaldon"

},

{

"name":"Barnes and Noble",

"url":"https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781101885680"

},

{

"name":"Books-A-Million",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FGO%252BTELL%252BTHE%252BBEES%252BTHAT%252BI%252BAM%252BGONE%252FDiana%252BGabaldon%252F9781101885680&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DGO%252BTELL%252BTHE%252BBEES%252BTHAT%252BI%252BAM%252BGONE%252BDiana%252BGabaldon"

},

{

"name":"Bookshop",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781101885680&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Fkeywords%3DGO%2BTELL%2BTHE%2BBEES%2BTHAT%2BI%2BAM%2BGONE"

},

{

"name":"IndieBound",

"url":"https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781101885680%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DGO%2BTELL%2BTHE%2BBEES%2BTHAT%2BI%2BAM%2BGONE%2BDiana%2BGabaldon%26aff%3DNYT"

}

],

"book_uri":"nyt://book/e400e1f2-adea-5edd-bc06-f5571a7921fa"

};

The API link is tested in postman also. It workded fine. When i call the API in talend i am getting that error.

The JSON is also validated it is correct. Something problem in talend.

Please let me know what issue i am making.

Thanks and Regards

Vijay

himanshup · ‎2024-11-20

Did you figure out the solution?
If so, please post it here. I am getting same error:
Missing property in path $['users']

Thank you

Dave_Simo · ‎2024-11-20

Hello,

The site https://jsonpath.pages.dev/ allows you to see which jsonpath request was made to parse the location you want in your json.

I hope it will be useful to you.

Best Regards

tExtractJsonFields component under loop json path error

JSON

REST

Talend Data Integration

v7.x