Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Could you please post your screenshots of the source schema and target schema on community? How many loops in it?
Best regards
Sabrina
Hi Xdshi
Please find the my job details and JSON format.
and JSON details
"status":"OK",
"copyright":"Copyright (c) 2021 The New York Times Company. All Rights Reserved.",
"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
Hi Xdshi
Please find the my job details and JSON format.
and JSON details
"status":"OK",
"copyright":"Copyright (c) 2021 The New York Times Company. All Rights Reserved.",
"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