# GET Json from API
**URL:** https://community.thunkable.com/t/get-json-from-api/1111320
**Category:** Questions about Thunkable X
**Tags:** solved, json
**Created:** [February 20, 2021, 8:57am UTC](https://community.thunkable.com/t/get-json-from-api/1111320 "2021-02-20T08:57:08Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 8:57am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/1 "2021-02-20T08:57:09Z")
Hi Out there
I cant seem to get the nr from this Json.
What blocks are wrong please…
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [February 20, 2021, 9:03am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/2 "2021-02-20T09:03:54Z")
Hey @funhall ,
There are 3 `navn` properties in the JSON you’ve shared…wait…are you trying to get navn or nr here?
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 9:06am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/3 "2021-02-20T09:06:51Z")
Wow you are quick I like that Thanks.
It is this Viborg i need?
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [February 20, 2021, 9:18am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/4 "2021-02-20T09:18:54Z")
Because of the initial square brackets you’ll need a “get item #1 from list block”
This will return the rest of the object that you can parse in the usual way.
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 9:24am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/5 "2021-02-20T09:24:23Z")
Like this.
This is undefined ??
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [February 20, 2021, 9:33am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/6 "2021-02-20T09:33:55Z")
No… like this where the picture of Image1 is set:
> [@How to retrieve images with a Spreadsheet component](https://community.thunkable.com/t/how-to-retrieve-images-with-a-spreadsheet-component/28670):
>
> I recently answered a question about retrieving and displaying images (or, more generally, attachments) stored in Spreadsheets and thought it might be useful to a larger audience. As far as Airtable images (and other attachments) are concerned, the returned value for an ‘Attachment’ type column in Airtable returns an array (i.e. a Thunkable List) of objects. You can obtain the download url for the object using the url property. Here is a very simple example Thunkable program that retrieves an…
(But with your API response rather then the Spreadsheet value!)
* * *
@drted perhaps this is another item for your [tutorial series?](https://community.thunkable.com/t/json-object-tutorial/1085666)
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [February 20, 2021, 9:39am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/7 "2021-02-20T09:39:28Z")
A post was split to a new topic: [Centering row contents](https://community.thunkable.com/t/centering-row-contents/1111398)
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 10:05am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/8 "2021-02-20T10:05:06Z")
then it must be like this?
Dont work
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 20, 2021, 10:09am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/9 "2021-02-20T10:09:54Z")
The green `response` block has a text string formatted as JSON and to read it as list you need to use `get object from JSON` first.
However, when you do this you will stumble with another issue that the `in list....` block will not accept it and therefore you need to assign it first to a variable then you insert the variable in the `in list ....` block.
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 10:41am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/10 "2021-02-20T10:41:48Z")
thanks. Is it me or is there not a turturial for those Get property from object etc. from Json block for beginners somewhere.???
---
### Author:  [@luv.ak.tech](https://community.thunkable.com/u/luv.ak.tech)
#### Post date: [February 20, 2021, 11:16am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/11 "2021-02-20T11:16:09Z")
that is a block in objects section
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 20, 2021, 11:38am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/12 "2021-02-20T11:38:04Z")
I took your JSON and did this block
This is the result I got showing `href` and `navn`
Hope this helps
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 11:39am UTC](https://community.thunkable.com/t/get-json-from-api/1111320/13 "2021-02-20T11:39:54Z")
Thanks. Is it that easy.???
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 12:06pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/14 "2021-02-20T12:06:37Z")
I still strougle with this Json.
I have followed the tuturial that @drted surgested. But that is only the Basis Json as I see it. And they dont explaine how to handle this brackets
I have this Json below. And I like to make a list with all the product names. Then I like to click a name in the list and get the details. But I just cant get the right blocks together.
Pleeeeaaase HEEEELP me…
{“collection”:[{“productNumber”:“1101”,“name”:“Model 1 over 100mm”,“costPrice”:5.00,“recommendedPrice”:38.40,“salesPrice”:38.40,“barred”:false,“lastUpdated”:“2021-01-30T12:10:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1101/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1101/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1101/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1101/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1101”},{“productNumber”:“1102”,“name”:"Model](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1101/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1101/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1101/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1101/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1101%22%7D,%7B%22productNumber%22:%221102%22,%22name%22:%22Model?fbclid=IwAR22qDGLulT2XL9K8QM5fuJ7eIKgmCSa17-Fg3IqaVLqzD3e6IIOucLKXXk) 1 under 100mm”,“costPrice”:5.00,“recommendedPrice”:32.00,“salesPrice”:32.00,“barred”:false,“lastUpdated”:“2021-01-30T12:10:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1102/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1102/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1102/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1102/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1102”},{“productNumber”:“1201”,“name”:"Model](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1102/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1102/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1102/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1102/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1102%22%7D,%7B%22productNumber%22:%221201%22,%22name%22:%22Model?fbclid=IwAR0qPJYeVDwjHYCfVS5Vg1O7LrPO0Ct685t3BJ1HhflYQYlBIeGHtjZQO9o) 2 over 100mm”,“costPrice”:5.00,“recommendedPrice”:38.40,“salesPrice”:38.40,“barred”:false,“lastUpdated”:“2021-02-19T19:46:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1201/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1201/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1201/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1201/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1201”},{“productNumber”:“1202”,“name”:"Model](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1201/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1201/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1201/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1201/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1201%22%7D,%7B%22productNumber%22:%221202%22,%22name%22:%22Model?fbclid=IwAR22qDGLulT2XL9K8QM5fuJ7eIKgmCSa17-Fg3IqaVLqzD3e6IIOucLKXXk) 2 under 100mm”,“costPrice”:5.00,“recommendedPrice”:32.00,“salesPrice”:32.00,“barred”:false,“lastUpdated”:“2021-01-30T12:10:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1202/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1202/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1202/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1202/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1202”},{“productNumber”:“1290”,“name”:"Merpris](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1202/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1202/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1202/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1202/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1202%22%7D,%7B%22productNumber%22:%221290%22,%22name%22:%22Merpris?fbclid=IwAR1bxZIwvLrEk2HhQXCMj-slzUrpqp0y5HjKHn9of-TFQcvJrMkogHKupNc) for min. 10 stk.”,“recommendedPrice”:160.00,“salesPrice”:160.00,“barred”:false,“lastUpdated”:“2021-01-30T12:09:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1290/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1290/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1290/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1290/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1290”},{“productNumber”:“1291”,“name”:"Merpris](https://l.facebook.com/l.php?u=https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fsales-accounts%22%2C%22products%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fproducts%22%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%22%7D%2C%22unit%22%3A%7B%22unitNumber%22%3A1%2C%22name%22%3A%22stk.%22%2C%22products%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Funits%2F1%2Fproducts%22%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Funits%2F1%22%7D%2C%22invoices%22%3A%7B%22drafts%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Finvoices%2Fdrafts%22%2C%22booked%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Finvoices%2Fbooked%22%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Finvoices%22%7D%2C%22pricing%22%3A%7B%22currencySpecificSalesPrices%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Fpricing%2Fcurrency-specific-sales-prices%22%7D%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%22%7D%2C%7B%22productNumber%22%3A%221291%22%2C%22name%22%3A%22Merpris%3Ffbclid%3DIwAR16PWulwniVqkhe0TjzfjRFzNm_LKOYPtGKUe99U3kVf8yi6i_qu-ucYvw&h=AT0xjQ84atQ0sGS25yxdr_QvkBJCxBbZ9TZMVi8Hc9ZjS01xnF9PRO6twTeDLl73--uV5hS4jVUjuyaQr7d2vFCjKxU-1yEylN_fZVTXPKfpb3aySdp9qkcI_qRIFpKjpZQ) for under 20 stk.”,“recommendedPrice”:80.00,“salesPrice”:80.00,“barred”:false,“lastUpdated”:“2021-02-19T19:46:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:"[[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1291/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1291/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1291/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1291”}],“pagination”:{“maxPageSizeAllowed”:1000,“skipPages”:0,“pageSize”:20,“results”:6,“resultsWithoutFilter”:6,“firstPage”:“https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20”,“lastPage”:“https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20”},“metaData”:{“create”:{“description”:"Create](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1291/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1291/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1291/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1291%22%7D%5D,%22pagination%22:%7B%22maxPageSizeAllowed%22:1000,%22skipPages%22:0,%22pageSize%22:20,%22results%22:6,%22resultsWithoutFilter%22:6,%22firstPage%22:%22https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20%22,%22lastPage%22:%22https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20%22%7D,%22metaData%22:%7B%22create%22:%7B%22description%22:%22Create)]([https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1291/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1291/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1291/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1291”}](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1291/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1291/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1291/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1291%22%7D)],%22pagination%22:%7B%22maxPageSizeAllowed%22:1000,%22skipPages%22:0,%22pageSize%22:20,%22results%22:6,%22resultsWithoutFilter%22:6,%22firstPage%22:%22https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20%22%7D%2C%22metaData%22%3A%7B%22create%22%3A%7B%22description%22%3A%22Create&fbclid=IwAR2dN4Db9JfW-uL8314FLlg5O3bGS2j22utbXGyCH\_O9zU6l7QkC0RXuB2E) a new product",“href”:“[https://restapi.e-conomic.com/product-groups/2/products",“httpMethod”:“post”}},“self”:"https://restapi.e-conomic.com/product-groups/2/products](https://l.facebook.com/l.php?u=https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fproducts%22%2C%22httpMethod%22%3A%22post%22%7D%7D%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fproducts%3Ffbclid%3DIwAR02YkeJOWlasFeAU-VrmTVMuYeMFR6lR7Hx4YX-XVyhe2eixG0uc-44uFs&h=AT0xjQ84atQ0sGS25yxdr_QvkBJCxBbZ9TZMVi8Hc9ZjS01xnF9PRO6twTeDLl73--uV5hS4jVUjuyaQr7d2vFCjKxU-1yEylN_fZVTXPKfpb3aySdp9qkcI_qRIFpKjpZQ)”}
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 1:00pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/15 "2021-02-20T13:00:11Z")
With these blocks
I get all this results:
“productNumber”:“1101”
“name”:“Model 1 over 100mm”
“costPrice”:5.00
“recommendedPrice”:38.40 etc.
But why cant I only get the 1’101’ or ‘Model 1 over 100mm’ or ‘5.00’ or ‘38.40’ with out the “”.
Is it not the
get property of object block I use for that???
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 1:14pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/17 "2021-02-20T13:14:03Z")
Is it really that dificult to make that Json text to some list I can use to work with???
I just think I miss some stupid little thing somewhere…
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [February 20, 2021, 1:23pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/18 "2021-02-20T13:23:29Z")
I was testing the JSoN you sent and there was lots of error in the last part.
I need sometime to correct it but would be faster if you can attach the JSON as text file so I can process it immediately.
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 1:25pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/19 "2021-02-20T13:25:50Z")
Thanks a lot, You cant use this it is the raw Json I get??
{“collection”:[{“productNumber”:“1101”,“name”:“Model 1 over 100mm”,“costPrice”:5.00,“recommendedPrice”:38.40,“salesPrice”:38.40,“barred”:false,“lastUpdated”:“2021-01-30T12:10:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1101/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1101/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1101/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1101/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1101”},{“productNumber”:“1102”,“name”:"Model](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1101/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1101/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1101/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1101/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1101%22%7D,%7B%22productNumber%22:%221102%22,%22name%22:%22Model?fbclid=IwAR22qDGLulT2XL9K8QM5fuJ7eIKgmCSa17-Fg3IqaVLqzD3e6IIOucLKXXk) 1 under 100mm”,“costPrice”:5.00,“recommendedPrice”:32.00,“salesPrice”:32.00,“barred”:false,“lastUpdated”:“2021-01-30T12:10:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1102/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1102/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1102/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1102/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1102”},{“productNumber”:“1201”,“name”:"Model](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1102/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1102/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1102/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1102/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1102%22%7D,%7B%22productNumber%22:%221201%22,%22name%22:%22Model?fbclid=IwAR0qPJYeVDwjHYCfVS5Vg1O7LrPO0Ct685t3BJ1HhflYQYlBIeGHtjZQO9o) 2 over 100mm”,“costPrice”:5.00,“recommendedPrice”:38.40,“salesPrice”:38.40,“barred”:false,“lastUpdated”:“2021-02-19T19:46:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1201/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1201/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1201/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1201/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1201”},{“productNumber”:“1202”,“name”:"Model](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1201/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1201/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1201/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1201/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1201%22%7D,%7B%22productNumber%22:%221202%22,%22name%22:%22Model?fbclid=IwAR22qDGLulT2XL9K8QM5fuJ7eIKgmCSa17-Fg3IqaVLqzD3e6IIOucLKXXk) 2 under 100mm”,“costPrice”:5.00,“recommendedPrice”:32.00,“salesPrice”:32.00,“barred”:false,“lastUpdated”:“2021-01-30T12:10:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1202/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1202/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1202/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1202/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1202”},{“productNumber”:“1290”,“name”:"Merpris](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1202/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1202/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1202/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1202/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1202%22%7D,%7B%22productNumber%22:%221290%22,%22name%22:%22Merpris?fbclid=IwAR1bxZIwvLrEk2HhQXCMj-slzUrpqp0y5HjKHn9of-TFQcvJrMkogHKupNc) for min. 10 stk.”,“recommendedPrice”:160.00,“salesPrice”:160.00,“barred”:false,“lastUpdated”:“2021-01-30T12:09:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:“[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1290/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1290/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1290/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1290/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1290”},{“productNumber”:“1291”,“name”:"Merpris](https://l.facebook.com/l.php?u=https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fsales-accounts%22%2C%22products%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fproducts%22%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%22%7D%2C%22unit%22%3A%7B%22unitNumber%22%3A1%2C%22name%22%3A%22stk.%22%2C%22products%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Funits%2F1%2Fproducts%22%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Funits%2F1%22%7D%2C%22invoices%22%3A%7B%22drafts%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Finvoices%2Fdrafts%22%2C%22booked%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Finvoices%2Fbooked%22%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Finvoices%22%7D%2C%22pricing%22%3A%7B%22currencySpecificSalesPrices%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%2Fpricing%2Fcurrency-specific-sales-prices%22%7D%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproducts%2F1290%22%7D%2C%7B%22productNumber%22%3A%221291%22%2C%22name%22%3A%22Merpris%3Ffbclid%3DIwAR16PWulwniVqkhe0TjzfjRFzNm_LKOYPtGKUe99U3kVf8yi6i_qu-ucYvw&h=AT0xjQ84atQ0sGS25yxdr_QvkBJCxBbZ9TZMVi8Hc9ZjS01xnF9PRO6twTeDLl73--uV5hS4jVUjuyaQr7d2vFCjKxU-1yEylN_fZVTXPKfpb3aySdp9qkcI_qRIFpKjpZQ) for under 20 stk.”,“recommendedPrice”:80.00,“salesPrice”:80.00,“barred”:false,“lastUpdated”:“2021-02-19T19:46:00Z”,“productGroup”:{“productGroupNumber”:2,“name”:“Pyntecover”,“salesAccounts”:"[[https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1291/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1291/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1291/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1291”}],“pagination”:{“maxPageSizeAllowed”:1000,“skipPages”:0,“pageSize”:20,“results”:6,“resultsWithoutFilter”:6,“firstPage”:“https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20”,“lastPage”:“https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20”},“metaData”:{“create”:{“description”:"Create](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1291/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1291/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1291/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1291%22%7D%5D,%22pagination%22:%7B%22maxPageSizeAllowed%22:1000,%22skipPages%22:0,%22pageSize%22:20,%22results%22:6,%22resultsWithoutFilter%22:6,%22firstPage%22:%22https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20%22,%22lastPage%22:%22https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20%22%7D,%22metaData%22:%7B%22create%22:%7B%22description%22:%22Create)]([https://restapi.e-conomic.com/product-groups/2/sales-accounts",“products”:“https://restapi.e-conomic.com/product-groups/2/products”,“self”:“https://restapi.e-conomic.com/product-groups/2”},“unit”:{“unitNumber”:1,“name”:“stk.”,“products”:“https://restapi.e-conomic.com/units/1/products”,“self”:“https://restapi.e-conomic.com/units/1”},“invoices”:{“drafts”:“https://restapi.e-conomic.com/products/1291/invoices/drafts”,“booked”:“https://restapi.e-conomic.com/products/1291/invoices/booked”,“self”:“https://restapi.e-conomic.com/products/1291/invoices”},“pricing”:{“currencySpecificSalesPrices”:“https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices”},“self”:“https://restapi.e-conomic.com/products/1291”}](https://restapi.e-conomic.com/product-groups/2/sales-accounts%22,%22products%22:%22https://restapi.e-conomic.com/product-groups/2/products%22,%22self%22:%22https://restapi.e-conomic.com/product-groups/2%22%7D,%22unit%22:%7B%22unitNumber%22:1,%22name%22:%22stk.%22,%22products%22:%22https://restapi.e-conomic.com/units/1/products%22,%22self%22:%22https://restapi.e-conomic.com/units/1%22%7D,%22invoices%22:%7B%22drafts%22:%22https://restapi.e-conomic.com/products/1291/invoices/drafts%22,%22booked%22:%22https://restapi.e-conomic.com/products/1291/invoices/booked%22,%22self%22:%22https://restapi.e-conomic.com/products/1291/invoices%22%7D,%22pricing%22:%7B%22currencySpecificSalesPrices%22:%22https://restapi.e-conomic.com/products/1291/pricing/currency-specific-sales-prices%22%7D,%22self%22:%22https://restapi.e-conomic.com/products/1291%22%7D)],%22pagination%22:%7B%22maxPageSizeAllowed%22:1000,%22skipPages%22:0,%22pageSize%22:20,%22results%22:6,%22resultsWithoutFilter%22:6,%22firstPage%22:%22https://restapi.e-conomic.com/product-groups/2/products?skippages=0&pagesize=20%22%7D%2C%22metaData%22%3A%7B%22create%22%3A%7B%22description%22%3A%22Create&fbclid=IwAR2dN4Db9JfW-uL8314FLlg5O3bGS2j22utbXGyCH\_O9zU6l7QkC0RXuB2E) a new product",“href”:“[https://restapi.e-conomic.com/product-groups/2/products",“httpMethod”:“post”}},“self”:"https://restapi.e-conomic.com/product-groups/2/products](https://l.facebook.com/l.php?u=https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fproducts%22%2C%22httpMethod%22%3A%22post%22%7D%7D%2C%22self%22%3A%22https%3A%2F%2Frestapi.e-conomic.com%2Fproduct-groups%2F2%2Fproducts%3Ffbclid%3DIwAR02YkeJOWlasFeAU-VrmTVMuYeMFR6lR7Hx4YX-XVyhe2eixG0uc-44uFs&h=AT0xjQ84atQ0sGS25yxdr_QvkBJCxBbZ9TZMVi8Hc9ZjS01xnF9PRO6twTeDLl73--uV5hS4jVUjuyaQr7d2vFCjKxU-1yEylN_fZVTXPKfpb3aySdp9qkcI_qRIFpKjpZQ)”}
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [February 20, 2021, 1:26pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/20 "2021-02-20T13:26:31Z")
@funhall The Json you shared above isn’t a valid Json I think This could be the issue. Google “Json formatted and pathfinder” Copy and paste the whole response into one of those sites. See if it works there. This could be why the object blocks aren’t interacting as expected.
---
### Author:  [@funhall](https://community.thunkable.com/u/funhall)
#### Post date: [February 20, 2021, 1:31pm UTC](https://community.thunkable.com/t/get-json-from-api/1111320/22 "2021-02-20T13:31:08Z")
I SEEEE yes there is a huge difference. Is this more like it then.
> **[Untitled - Pastebin.com](https://pastebin.com/fjUHgSiV)**
>
> Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
[Next page](https://community.thunkable.com/t/get-json-from-api/1111320.md?page=2)