The API I am using doesn’t return the values in a very friendly format, and sadly can’t be modified directly. The plain JSON output of the specific section is below (anonymized):
"pick_up_locations": {
"3": "Location 3",
"custom": "Pick up Address"
}
Using {brf_api_title_data_pick_up_locations} returns “Location 3, Pick up Address” as a single result. And Bricksforge doesn’t recognize it as an array, for use with nested arrays. (Which I believe is expected behaviour)
I’m wanting to use these values as options for a select field in Pro Forms. So that the Value for each option is the the second name (3), and the label is the second (Location 3). But I haven’t been able to find a way to make this work, using either of Bricks or Bricksforges API Query.
The closest I can get is using the JSON populate option in Pro Forms - Select, but I must manually copy in the JSON output shown above.
Has anyone got any suggestions/ideas for how to handle this? Or alternatively is it possible for a new feature to be added that can selectively choose to interpret this format of data as an array?
Thank You in advance