No internet connection
  1. Home
  2. General

Strategy to walk through a list returned from Read JSON Document

By Mark Carpenter @mark.carpenter2021-07-10 18:43:18.153Z2021-07-11 21:50:07.452Z

Our new REST API returns a list of matching results as a JSON array. I need to walk through the array and pull certain key values. The For Each doesn't seem to support walking through the JSON. I have tried looping on a extract and using a counter for the array[%counter%] value, but it always returns the first result. What is the best strategy to get the JSON into a format I can step through?

Here's a sample JSON output:
{
"meta_data": {
"keywords": [
"duro max",
"mx1500",
"1000",
"1500"
],
"prioritized_keywords": [
"duro max",
"mx1500",
"1000",
"1500"
],
"entity_id": 798,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 51.872916666666669,
"score_card_entries": [
{
"value": 18.384375000000002,
"note": "Total value for the candidate is "0.6128" based on the token scores "0.4000,0.0744,0.1088,0.0297". With the max score of "30" the final score is "18.3844"."
},
{
"value": 24.405208333333334,
"note": "Total value for the candidate is "0.6973" based on the token scores "0.4500,0.1067,0.1094,0.0313". With the max score of "35" the final score is "24.4052"."
},
{
"value": 9.0833333333333321,
"note": "Total value for the candidate is "0.2595" based on the token scores "0.1500,0.0167,0.0857,0.0071". With the max score of "35" the final score is "9.0833"."
}
]
},
"entity": {
"name": "MX1500",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [
],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOPFDCSTN",
"short_description": "GenTent for open frames",
"legacy_sku": "GT10KB00TB",
"additional_data": {
"Frame Type": "Round tubular"
},
"id": 1,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Direct Connect in Tan"
},
"running_wattage": 1000,
"peak_wattage": 1500,
"assembled_frame_length": 19,
"assembled_frame_width": 17.5,
"frame_only_length": 19,
"frame_only_width": 17.5,
"frame_clamp_setting": 0,
"frame_is_square": false,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": false,
"frame_has_fixed_handle": false,
"frame_has_other_challenges": false,
"id": 798,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-MX1500.jpg"
},
"search_key": "60e9dd6049d95"
}
{
"meta_data": {
"keywords": [
"duro max",
"xp13000eh",
"10500",
"13000"
],
"prioritized_keywords": [
"duro max",
"xp13000eh",
"10500",
"13000"
],
"entity_id": 808,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 51.468333333333334,
"score_card_entries": [
{
"value": 19.260000000000002,
"note": "Total value for the candidate is "0.6420" based on the token scores "0.4000,0.1145,0.0956,0.0319". With the max score of "30" the final score is "19.2600"."
},
{
"value": 25.208333333333332,
"note": "Total value for the candidate is "0.7202" based on the token scores "0.4500,0.1536,0.0875,0.0292". With the max score of "35" the final score is "25.2083"."
},
{
"value": 7,
"note": "Total value for the candidate is "0.2000" based on the token scores "0.1500,0.0000,0.0429,0.0071". With the max score of "35" the final score is "7.0000"."
}
]
},
"entity": {
"name": "XP13000EH",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOPFUASTN",
"short_description": "GenTent with universal mounting for open frames",
"legacy_sku": "GT10KB4UTB",
"additional_data": {
"Frame Type": "Round or square tubular"
},
"id": 10,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Universal Kit in Tan"
},
"running_wattage": 10500,
"peak_wattage": 13000,
"assembled_frame_length": 30,
"assembled_frame_width": 29.5,
"frame_only_length": 26.5,
"frame_only_width": 21.5,
"frame_clamp_setting": 0,
"frame_is_square": true,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": true,
"frame_has_fixed_handle": true,
"frame_has_other_challenges": true,
"id": 808,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP13000EH.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp1200is",
"1000",
"1200"
],
"prioritized_keywords": [
"duro max",
"xp1200is",
"1000",
"1200"
],
"entity_id": 806,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 51.009999999999991,
"score_card_entries": [
{
"value": 18.463124999999998,
"note": "Total value for the candidate is "0.6154" based on the token scores "0.4000,0.0770,0.1088,0.0297". With the max score of "30" the final score is "18.4631"."
},
{
"value": 24.046874999999996,
"note": "Total value for the candidate is "0.6871" based on the token scores "0.4500,0.0964,0.1094,0.0313". With the max score of "35" the final score is "24.0469"."
},
{
"value": 8.5,
"note": "Total value for the candidate is "0.2429" based on the token scores "0.1500,0.0000,0.0857,0.0071". With the max score of "35" the final score is "8.5000"."
}
]
},
"entity": {
"name": "XP1200iS",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOICSMSTN",
"short_description": "GenTent for fully encased inverters",
"legacy_sku": "GT10KXKITB",
"additional_data": {
"Frame Type": "Fully encased"
},
"id": 19,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Inverter Kit in Tan"
},
"running_wattage": 1000,
"peak_wattage": 1200,
"assembled_frame_length": 14,
"assembled_frame_width": 16,
"frame_only_length": 14,
"frame_only_width": 16,
"frame_clamp_setting": 0,
"frame_is_square": false,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": false,
"frame_has_fixed_handle": false,
"frame_has_other_challenges": false,
"id": 806,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP1200iS.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp15000eh",
"12000",
"15000"
],
"prioritized_keywords": [
"duro max",
"xp15000eh",
"12000",
"15000"
],
"entity_id": 811,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 50.718333333333334,
"score_card_entries": [
{
"value": 19.260000000000002,
"note": "Total value for the candidate is "0.6420" based on the token scores "0.4000,0.1145,0.0956,0.0319". With the max score of "30" the final score is "19.2600"."
},
{
"value": 25.208333333333332,
"note": "Total value for the candidate is "0.7202" based on the token scores "0.4500,0.1536,0.0875,0.0292". With the max score of "35" the final score is "25.2083"."
},
{
"value": 6.25,
"note": "Total value for the candidate is "0.1786" based on the token scores "0.1500,0.0000,0.0214,0.0071". With the max score of "35" the final score is "6.2500"."
}
]
},
"entity": {
"name": "XP15000EH",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTXPFUASTN",
"short_description": "GenTent XL with universal mounting for large open frames",
"legacy_sku": "",
"additional_data": {
"Frame Type": "Round or square tubular"
},
"id": 28,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent XL Universal Kit in Tan"
},
"running_wattage": 12000,
"peak_wattage": 15000,
"assembled_frame_length": 35,
"assembled_frame_width": 24.5,
"frame_only_length": 31.5,
"frame_only_width": 21,
"frame_clamp_setting": 4,
"frame_is_square": false,
"frame_has_heat_shield": true,
"frame_has_blocked_panel": false,
"frame_has_fixed_handle": false,
"frame_has_other_challenges": false,
"id": 811,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP15000EH.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp10000eh",
"8000",
"10000"
],
"prioritized_keywords": [
"duro max",
"xp10000eh",
"8000",
"10000"
],
"entity_id": 801,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 50.411458333333329,
"score_card_entries": [
{
"value": 19.15625,
"note": "Total value for the candidate is "0.6385" based on the token scores "0.4000,0.1250,0.0788,0.0348". With the max score of "30" the final score is "19.1562"."
},
{
"value": 24.755208333333329,
"note": "Total value for the candidate is "0.7073" based on the token scores "0.4500,0.1667,0.0531,0.0375". With the max score of "35" the final score is "24.7552"."
},
{
"value": 6.5,
"note": "Total value for the candidate is "0.1857" based on the token scores "0.1500,0.0000,0.0000,0.0357". With the max score of "35" the final score is "6.5000"."
}
]
},
"entity": {
"name": "XP10000EH",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOPFUASTN",
"short_description": "GenTent with universal mounting for open frames",
"legacy_sku": "GT10KB4UTB",
"additional_data": {
"Frame Type": "Round or square tubular"
},
"id": 10,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Universal Kit in Tan"
},
"running_wattage": 8000,
"peak_wattage": 10000,
"assembled_frame_length": 30,
"assembled_frame_width": 29,
"frame_only_length": 26.5,
"frame_only_width": 21.5,
"frame_clamp_setting": 0,
"frame_is_square": true,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": true,
"frame_has_fixed_handle": true,
"frame_has_other_challenges": true,
"id": 801,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP10000EH.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp2200eh",
"1800",
"2200"
],
"prioritized_keywords": [
"duro max",
"xp2200eh",
"1800",
"2200"
],
"entity_id": 814,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 49.395833333333343,
"score_card_entries": [
{
"value": 18.750000000000004,
"note": "Total value for the candidate is "0.6250" based on the token scores "0.4000,0.1163,0.0891,0.0197". With the max score of "30" the final score is "18.7500"."
},
{
"value": 24.645833333333336,
"note": "Total value for the candidate is "0.7042" based on the token scores "0.4500,0.1417,0.0938,0.0188". With the max score of "35" the final score is "24.6458"."
},
{
"value": 6,
"note": "Total value for the candidate is "0.1714" based on the token scores "0.1500,0.0000,0.0214,0.0000". With the max score of "35" the final score is "6.0000"."
}
]
},
"entity": {
"name": "XP2200EH",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOICSMSTN",
"short_description": "GenTent for fully encased inverters",
"legacy_sku": "GT10KXKITB",
"additional_data": {
"Frame Type": "Fully encased"
},
"id": 19,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Inverter Kit in Tan"
},
"running_wattage": 1800,
"peak_wattage": 2200,
"assembled_frame_length": 20,
"assembled_frame_width": 11,
"frame_only_length": 20,
"frame_only_width": 11,
"frame_clamp_setting": 0,
"frame_is_square": false,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": false,
"frame_has_fixed_handle": false,
"frame_has_other_challenges": false,
"id": 814,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP2200EH.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro star",
"ds10000eh",
"8000",
"10000"
],
"prioritized_keywords": [
"duro star",
"ds10000eh",
"8000",
"10000"
],
"entity_id": 830,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 49.355285493827161,
"score_card_entries": [
{
"value": 18.856249999999999,
"note": "Total value for the candidate is "0.6285" based on the token scores "0.3900,0.1250,0.0788,0.0348". With the max score of "30" the final score is "18.8562"."
},
{
"value": 24.755208333333329,
"note": "Total value for the candidate is "0.7073" based on the token scores "0.4500,0.1667,0.0531,0.0375". With the max score of "35" the final score is "24.7552"."
},
{
"value": 5.7438271604938267,
"note": "Total value for the candidate is "0.1641" based on the token scores "0.1185,0.0099,0.0000,0.0357". With the max score of "35" the final score is "5.7438"."
}
]
},
"entity": {
"name": "DS10000EH",
"generator_make": {
"id": 47,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Star",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOPFUASTN",
"short_description": "GenTent with universal mounting for open frames",
"legacy_sku": "GT10KB4UTB",
"additional_data": {
"Frame Type": "Round or square tubular"
},
"id": 10,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Universal Kit in Tan"
},
"running_wattage": 8000,
"peak_wattage": 10000,
"assembled_frame_length": 40,
"assembled_frame_width": 29,
"frame_only_length": 26.5,
"frame_only_width": 21.5,
"frame_clamp_setting": 0,
"frame_is_square": true,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": true,
"frame_has_fixed_handle": true,
"frame_has_other_challenges": true,
"id": 830,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Star/GenTent-Duro Star-DS10000EH.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp2000eh",
"1600",
"2000"
],
"prioritized_keywords": [
"duro max",
"xp2000eh",
"1600",
"2000"
],
"entity_id": 812,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 49.25,
"score_card_entries": [
{
"value": 19.078125,
"note": "Total value for the candidate is "0.6359" based on the token scores "0.4000,0.1206,0.0891,0.0263". With the max score of "30" the final score is "19.0781"."
},
{
"value": 24.171874999999996,
"note": "Total value for the candidate is "0.6906" based on the token scores "0.4500,0.1292,0.0938,0.0177". With the max score of "35" the final score is "24.1719"."
},
{
"value": 6,
"note": "Total value for the candidate is "0.1714" based on the token scores "0.1500,0.0000,0.0214,0.0000". With the max score of "35" the final score is "6.0000"."
}
]
},
"entity": {
"name": "XP2000EH",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOICSMSTN",
"short_description": "GenTent for fully encased inverters",
"legacy_sku": "GT10KXKITB",
"additional_data": {
"Frame Type": "Fully encased"
},
"id": 19,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Inverter Kit in Tan"
},
"running_wattage": 1600,
"peak_wattage": 2000,
"assembled_frame_length": 18,
"assembled_frame_width": 10.5,
"frame_only_length": 18,
"frame_only_width": 10.5,
"frame_clamp_setting": 0,
"frame_is_square": false,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": false,
"frame_has_fixed_handle": false,
"frame_has_other_challenges": false,
"id": 812,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP2000EH.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp13000e",
"10500",
"13000"
],
"prioritized_keywords": [
"duro max",
"xp13000e",
"10500",
"13000"
],
"entity_id": 807,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 48.972916666666663,
"score_card_entries": [
{
"value": 17.618749999999999,
"note": "Total value for the candidate is "0.5873" based on the token scores "0.4000,0.0598,0.0956,0.0319". With the max score of "30" the final score is "17.6187"."
},
{
"value": 24.354166666666664,
"note": "Total value for the candidate is "0.6958" based on the token scores "0.4500,0.1292,0.0875,0.0292". With the max score of "35" the final score is "24.3542"."
},
{
"value": 7,
"note": "Total value for the candidate is "0.2000" based on the token scores "0.1500,0.0000,0.0429,0.0071". With the max score of "35" the final score is "7.0000"."
}
]
},
"entity": {
"name": "XP13000E",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOPFUASTN",
"short_description": "GenTent with universal mounting for open frames",
"legacy_sku": "GT10KB4UTB",
"additional_data": {
"Frame Type": "Round or square tubular"
},
"id": 10,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Universal Kit in Tan"
},
"running_wattage": 10500,
"peak_wattage": 13000,
"assembled_frame_length": 30,
"assembled_frame_width": 29.5,
"frame_only_length": 26.5,
"frame_only_width": 21.5,
"frame_clamp_setting": 0,
"frame_is_square": true,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": true,
"frame_has_fixed_handle": true,
"frame_has_other_challenges": true,
"id": 807,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP13000E.jpg"
},
"search_key": "60e9dd6049d95"
},
{
"meta_data": {
"keywords": [
"duro max",
"xp13000hx",
"10500",
"13000"
],
"prioritized_keywords": [
"duro max",
"xp13000hx",
"10500",
"13000"
],
"entity_id": 809,
"entity_fqcn": "App\Entity\V01\GeneratorModel",
"likelihood": 48.894166666666663,
"score_card_entries": [
{
"value": 17.539999999999999,
"note": "Total value for the candidate is "0.5847" based on the token scores "0.4000,0.0572,0.0956,0.0319". With the max score of "30" the final score is "17.5400"."
},
{
"value": 24.354166666666664,
"note": "Total value for the candidate is "0.6958" based on the token scores "0.4500,0.1292,0.0875,0.0292". With the max score of "35" the final score is "24.3542"."
},
{
"value": 7,
"note": "Total value for the candidate is "0.2000" based on the token scores "0.1500,0.0000,0.0429,0.0071". With the max score of "35" the final score is "7.0000"."
}
]
},
"entity": {
"name": "XP13000HX",
"generator_make": {
"id": 46,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:05:23+00:00",
"name": "Duro Max",
"active": true,
"image_url": ""
},
"disqualified_reason": {
"label": "Not Disqualified",
"id": 1,
"active": true
},
"products": [],
"default_product": {
"product_family": {
"label": "GenTent",
"id": 1,
"active": true
},
"sku": "GTOPFUASTN",
"short_description": "GenTent with universal mounting for open frames",
"legacy_sku": "GT10KB4UTB",
"additional_data": {
"Frame Type": "Round or square tubular"
},
"id": 10,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:28+00:00",
"active": true,
"name": "GenTent Universal Kit in Tan"
},
"running_wattage": 10500,
"peak_wattage": 13000,
"assembled_frame_length": 30,
"assembled_frame_width": 29,
"frame_only_length": 26.5,
"frame_only_width": 21.5,
"frame_clamp_setting": 0,
"frame_is_square": true,
"frame_has_heat_shield": false,
"frame_has_blocked_panel": true,
"frame_has_fixed_handle": true,
"frame_has_other_challenges": true,
"id": 809,
"version": 1,
"version_user_id": 1,
"date_created": "2021-02-09T20:07:01+00:00",
"active": true,
"image_url": "http://stormbracer.com/gen/Duro Max/GenTent-Duro Max-XP13000HX.jpg"
},
"search_key": "60e9dd6049d95"
}
]

  • 5 replies
  1. M
    Mark Carpenter @mark.carpenter2021-07-12 13:42:34.674Z

    Update: Using 'Extract All Array Value to CSV', I can get the entity.generator_make.name and entity.name but the meta_data.likelihood does not populate and entity.peak_wattage comes back as a non-array with the first entry only.

    1. M
      In reply tomark.carpenter:
      Mark Carpenter @mark.carpenter2021-07-12 14:06:57.876Z

      I believe I found a bug? The Extract All Array Values to CSV only works if the helper message encases the target value in double quotes. Therefore strings work with no problem. Numbers with decimals do not work, and numbers as integers work for the first instance only.

      When I encase meta_data.likelihood value (in the Helper Message) in quotes, as "likelihood": "51.872916666666669", then TA picks up correctly into the array because it views it as a string.

      When it is not quotes, it does not work although in this case the Path: inside Extract from JSON identifies it as a number.

      Please advise!

      1. S
        In reply tomark.carpenter:
        Stephen Parker @stephenparker2021-07-14 06:25:00.180Z

        Hi Mark, Could you send the Json as a file? The Json pasted isnt valid, so I am unable to test.

        For example - the element: "note": "Total value for the candidate is "0.6420" based on the token scores "0.4000,0.1145,0.0956,0.0319". With the max score of "30" the final score is "19.2600"."

        will be treated as separate elements as the quote chars arent escaped.

        Thanks
        Stephen

        1. MMark Carpenter @mark.carpenter2021-07-14 15:28:22.123Z

          Hi Stephen, how about I send you the API ReadJSON with an access key then you can see the raw data?

        2. Progress
        3. M
          Mark Carpenter @mark.carpenter2021-07-17 12:11:56.100Z

          Hi Stephen, I sent the package and a text file with the JSON output. For my purposes, I've discovered the better method to process this array by ReadJSON by selecting the first JSON record and telling TA to assign all values to an array. Now I can For...Next through the array and pick the individual elements from each record. The question re: array of integers remains, however, I've gone around it by finding the right approach.