JSONArray_ListValuesByKey ( array ; key )

A While() loop that returns a pilcrow delimited list of values for a specific key within each element of an array.

Be the first to rate this function Log in to vote

David A Sullivan - Show more from this author
Mandelbrot LLC
http://mandelbrotllc.com

Sample input:

"[{\"foo\":\"bar\"}, {\"herp\":\"derp\", \"foo\":\"barrio\"}, {\"foo\":\"bat\"} ]" , "foo"

Sample output:

bar¶barrio¶bat

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
A While() loop that returns a pilcrow delimited list of values for a specific key within each element of an array. 

2024-09-22 by sully@mandelbrotllc.com
*/

While (

  [
    array = array ;
    key = key ;
    value = "" ;
    objCount = ValueCount ( JSONListKeys ( array ; "" ) ) ;
    i = 0 ; 
    returnList = "" 
  ] ; 

  i < objCount ;

  [
    value = JSONGetElement ( array ; "[" & i & "]." & key ) ;
    returnList = If ( value <> "" ; 
          If ( returnList <> "" ; returnList & "¶" & value ; value ) ;
          returnList ) ;
    i = i + 1 
  ] ; 

  returnList

)

Sometimes APIs give us back a large array of objects. Inside of each of those objects is a single value that we actually need. One good example of this is a device id. You query and API for a list of devices and it sends back an array. The array doesn't have everything you're looking for in it, but it does have each device's id. You can then use that id to query the API again for more details on the individual devices. So, you use a While() statement to peel out just the ids, then you loop through the list of ids.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

JSONArray_ListValuesByKey ( array ; key )

Comments

Support this website.

Support this website.