Hi Out there
I cant seem to get the nr from this Json.
What blocks are wrong please…
Hey @funhall ,
There are 3 navn
properties in the JSON you’ve shared…wait…are you trying to get navn or nr here?
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.
No… like this where the picture of Image1 is set:
(But with your API response rather then the Spreadsheet value!)
@drted perhaps this is another item for your tutorial series?
A post was split to a new topic: Centering row contents
then it must be like this?
Dont work
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.
thanks. Is it me or is there not a turturial for those Get property from object etc. from Json block for beginners somewhere.???
that is a block in objects section
Thanks. Is it that easy.???
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”}
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???
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…
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.
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”}
@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.
I SEEEE yes there is a huge difference. Is this more like it then.