Issue with Accessing Nested Array(JSON handler) in Quickbase Pipeline
json_records_path: /systems { "id": 6816675, "url": "https://api.opensolar.com/api/orgs/146358/systems/6816675/", "name": "No value", "uuid": "F234D90E-E9E4-4F18-ADC9-89C0B9420385", "order": 0, "system_lifetime": 0, "inverter_range": "No value", "dc_optimizer_active": false, "dc_optimizer_efficiency": 1, "show_customer": true, "is_current": false, "auto_string": true, "discount": 0, "adders_per_system": 0, "adders_per_panel": 0, "adders_per_watt": 0, "kw_stc": 1.68, "battery_total_kwh": 19.6, "price_including_tax": 5862.5, "price_excluding_tax": 5862.5, "net_profit": 13797.04, "module_quantity": 5, "co2_tons_lifetime": 15.48, "project": "https://api.opensolar.com/api/orgs/146358/projects/5616041/", "org": "https://api.opensolar.com/api/orgs/146358/", "pricing_scheme": "https://api.opensolar.com/api/orgs/146358/pricing_schemes/278737/", "pricing_scheme_data": { "battery_scheme": "No value", "output_annual_kwh": 2332, "consumption_offset_percentage": 49 }, "modules": [ { "module_activation_id": 886178, "code": "SPR-P3-335-BLK", "manufacturer_name": "SunPower", "quantity": 5 } ] } The above is the details I get when i access it through /systems json record path. However, I am having trouble accessing the modules array inside the system data when iterating over the JSON records in Quickbase Pipeline. Specifically, I cannot retrieve the modules array, which is nested within the system object. Despite multiple attempts to use paths like /systems[0]/modules or /systems[*]/modules or /modules or /systems/modules or system.modules I am not able to iterate over or access the modules array directly in the pipeline. Could anyone provide guidance on why the modules array is not being accessible within the Quickbase Pipeline, and suggest the correct JSONPath or method to properly access it?