Extract value from Json Array

Help Studio
, , , , ,
1

Hello I wonder how i can extract
the values from field “type”, “description”, “price” within the array “lines”

So i want to loop that array extract value from each field, perform an action then do the same process until it has looped the array

how can i do that with an jobject ?

JObject(1) { JProperty(1) { JObject(16) { JProperty(1) { [80049692] }, JProperty(1) { [EL67875] }, JProperty(1) { [TESLA MOTORS Model S (2015)] }, JProperty(1) { [2022-12-29] }, JProperty(1) { [PROTECTOR FORSIKRING AS] }, JProperty(1) { [front] }, JProperty(1) { [+4724131888] }, JProperty(1) { [stone_chip] }, JProperty(1) { [2420 Trysil, Norge] }, JProperty(1) { [162267] }, JProperty(1) { [800496929] }, JProperty(1) { [W5404mb] }, JProperty(1) { [Morten20221,] }, JProperty(1) { [False] }, JProperty(1) { JArray(2) { JObject(3) { JProperty(1) { [glass] }, JProperty(1) { [FR TESLA S 5H MONO-CAM] }, JProperty(1) { [21636.25] } }, JObject(3) { JProperty(1) { [calibration] }, JProperty(1) { [TESLA TOOLBOX KALIB MONO] }, JProperty(1) { [1600.00] } } } }, JProperty(1) { JArray(6) { JObject(2) { JProperty(1) { [https://hcg-prd-tools-storage1.s3.eu-north-1.amazonaws.com/files/2d480434-acb5-40b3-bdf7-079001153434.jpeg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARS7JLPYFVGGROBVW%2F20230111%2Feu-north-1%2Fs3%2Faws4_request&X-Amz-Date=20230111T111551Z&X-Amz-SignedHeaders=host&X-Amz-Expires=4200&X-Amz-Signature=a029bcf7a750fa151c34d74db600a5072708d776dabf3008148cd09d7a726c88] }, JProperty(1) { [EL67875_80049692_DMGREPORT.jpeg] } }, JObject(2) { JProperty(1) { [https://hcg-prd-tools-storage1.s3.eu-north-1.amazonaws.com/files/685f43bf-3bb6-4e34-b031-8271fb69bd85.jpeg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARS7JLPYFVGGROBVW%2F20230111%2Feu-north-1%2Fs3%2Faws4_request&X-Amz-Date=20230111T111551Z&X-Amz-SignedHeaders=host&X-Amz-Expires=4200&X-Amz-Signature=d82fd60a6ccd3f86ca5614263cadc3a0233c4cee84e9f08dce164be4850063eb] }, JProperty(1) { [EL67875_80049692_REG.jpeg] } }, JObject(2) { JProperty(1) { [https://hcg-prd-tools-storage1.s3.eu-north-1.amazonaws.com/files/fa9ab8b8-53d5-457b-8b3e-4223fd2af6af.jpeg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARS7JLPYFVGGROBVW%2F20230111%2Feu-north-1%2Fs3%2Faws4_request&X-Amz-Date=20230111T111551Z&X-Amz-SignedHeaders=host&X-Amz-Expires=4200&X-Amz-Signature=56b91c95680e891d2e326278d7368b8aff2e189c4c923f1547d29dae96a676ba] }, JProperty(1) { [EL67875_80049692_DMGLOC.jpeg] } }, JObject(2) { JProperty(1) { [https://hcg-prd-tools-storage1.s3.eu-north-1.amazonaws.com/files/4a30cc5e-d2cb-43b8-9c26-ad91701eb2e7.jpeg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARS7JLPYFVGGROBVW%2F20230111%2Feu-north-1%2Fs3%2Faws4_request&X-Amz-Date=20230111T111551Z&X-Amz-SignedHeaders=host&X-Amz-Expires=4200&X-Amz-Signature=de3578191a07889a4ca1e7dfe80dec173f8ce074243a92942dee3e9a48c9543c] }, JProperty(1) { [EL67875_80049692_DAMAGE.jpeg] } }, JObject(2) { JProperty(1) { [https://hcg-prd-tools-storage1.s3.eu-north-1.amazonaws.com/files/cbc4190c-1b4f-4221-b024-44e2d802aef0.jpeg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARS7JLPYFVGGROBVW%2F20230111%2Feu-north-1%2Fs3%2Faws4_request&X-Amz-Date=20230111T111551Z&X-Amz-SignedHeaders=host&X-Amz-Expires=4200&X-Amz-Signature=a9d519dc3d2bc512302d60d88d727a74b1ff103557c68224c13c590ffc5a7530] }, JProperty(1) { [EL67875_80049692_ID.jpeg] } }, JObject(2) { JProperty(1) { [https://hcg-prd-tools-storage1.s3.eu-north-1.amazonaws.com/files/990edb19-d67b-463b-a5ac-8d748ba8c849.jpeg?X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARS7JLPYFVGGROBVW%2F20230111%2Feu-north-1%2Fs3%2Faws4_request&X-Amz-Date=20230111T111551Z&X-Amz-SignedHeaders=host&X-Amz-Expires=4200&X-Amz-Signature=05ef63d444ec04dd9dcb41ba0caad6c7530653f85c6bc6ed2eb262ecfd03d270] }, JProperty(1) { [EL67875_80049692_KM.jpeg] } } } } } } }
2

There are different options to extract it and is also depending on how the extracted info is to store / kept

In general we can loop over this

  • within a for each activity | item in myJObject(“data”)(lines) | TypeArgument: JOBject
  • then we can access the fields e.g. item(“description”).Value(of String)

A quick extract into a datatable would look like this:
grafik

1 Like
3

@langsem
Try this link

Hope this helps.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.