GET Json from API

[funhall]

Hi Out there
I cant seem to get the nr from this Json.
What blocks are wrong please…

[domhnallohanlon]

Hey @funhall ,

There are 3 navn properties in the JSON you’ve shared…wait…are you trying to get navn or nr here?

[funhall]

Wow you are quick I like that Thanks.
It is this Viborg i need?

[domhnallohanlon]

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.

[funhall]

Like this.
This is undefined ??

[domhnallohanlon]

No… like this where the picture of Image1 is set:

How to retrieve images with a Spreadsheet component

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?

[funhall]

then it must be like this?
Dont work

[muneer]

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.

[funhall]

thanks. Is it me or is there not a turturial for those Get property from object etc. from Json block for beginners somewhere.???

[luv.ak.tech]

that is a block in objects section

[muneer]

I took your JSON and did this block

This is the result I got showing href and navn

Hope this helps

[funhall]

Thanks. Is it that easy.???

[funhall]

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 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 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 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 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 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",“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”}],%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”}

[funhall]

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???

[funhall]

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…

[muneer]

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.

[funhall]

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 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 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 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 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 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",“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”}],%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”}

[jared]

@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.

[funhall]

I SEEEE yes there is a huge difference. Is this more like it then.

Untitled - Pastebin.com