Bring AI to your FileMaker scripts without handing over your file.

Give it JSON and get the JSONSetElement expression that rebuilds it, every leaf a paste-ready [ path ; value ; type ] row, nested objects and arrays included.

You give it

{"orderId":1001,"customer":{"name":"Acme Corp","email":"[email protected]"},"total":249.5,"lines":[{"sku":"A1","qty":2}]}

It returns, paste-ready

JSONSetElement ( "{}" ;
  [ "orderId" ; 1001 ; JSONNumber ] ;
  [ "customer.name" ; "Acme Corp" ; JSONString ] ;
  [ "customer.email" ; "[email protected]" ; JSONString ] ;
  [ "total" ; 249.5 ; JSONNumber ] ;
  [ "lines[0].sku" ; "A1" ; JSONString ] ;
  [ "lines[0].qty" ; 2 ; JSONNumber ]
)

Give it the same JSON and get a complete, readable script that loops your records and composes it back. A nested array ("lines" here) makes the script call itself once per child record to walk into a related table.

You give it

{"orderId":1001,"customer":{"name":"Acme Corp","email":"[email protected]"},"total":249.5,"lines":[{"sku":"A1","qty":2}]}

It returns: wire in your fields and run it

# ===== START HERE - this is a template, not a finished script =====
# 1) dotted keys (a.b) read the CURRENT record; arrays walk a child layout, found by the parent key
# 2) this script is RECURSIVE - give it a unique name
# 3) Fill in every SET THIS block.
# 4) Set the gate below to True when ready.
# 5) Run from the initial parent record without parameter - result returns via Get ( ScriptResult )
# ===== sample structure =====
# { orderId: number, customer: { name: text, email: text }, total: number, lines: [ 1 x { sku: text, qty: number } ] }
If [ False ]
    Set Error Capture [ On ]
    Freeze Window
    Set Variable [ $fmsb.home ; Value: Get ( LayoutName ) ]
    Set Variable [ $fmsb.collection ; Value: JSONGetElement ( Get ( ScriptParameter ) ; "collection" ) ]
    Set Variable [ $fmsb.parentKey ; Value: JSONGetElement ( Get ( ScriptParameter ) ; "parentKey" ) ]
    If [ IsEmpty ( Get ( ScriptParameter ) ) ]
        # ===== TOP LEVEL - this part runs when there is no script parameter =====
        # RUN THIS FROM THE PARENT RECORD YOU WANT TO EXPORT - wrong record = blank JSON, no error
        # ############################################
        # ##### SET THIS - one field per key #####
        # ############################################
        # $orderId_value - your field for "orderId". Sample: 1001
        Set Variable [ $orderId_value ; Value: "SET VALUE" ]
        # $customer_name_value - your field for "customer.name". Sample: "Acme Corp"
        Set Variable [ $customer_name_value ; Value: "SET VALUE" ]
        # $customer_email_value - your field for "customer.email". Sample: "[email protected]"
        Set Variable [ $customer_email_value ; Value: "SET VALUE" ]
        # $total_value - your field for "total". Sample: 249.5
        Set Variable [ $total_value ; Value: "SET VALUE" ]
        # $lines_parent_key - the key field on THIS record that "lines" rows point back to
        #   unquoted field - the VALUE, not the field's name
        Set Variable [ $lines_parent_key ; Value: "SET VALUE" ]
        # ############################################
        # ##### END SET THIS #####
        # ############################################
        Set Variable [ $fmsb.json ; Value:
        ```
        JSONSetElement ( "{}" ;
          [ "orderId" ; $orderId_value ; JSONNumber ] ;
          [ "customer.name" ; $customer_name_value ; JSONString ] ;
          [ "customer.email" ; $customer_email_value ; JSONString ] ;
          [ "total" ; $total_value ; JSONNumber ] ;
          [ "lines" ; "[]" ; JSONArray ]
        )
        ``` ]
        # "lines" - this same script fills it in, one call per record.
        Set Variable [ $fmsb.thisKey ; Value: $lines_parent_key ]
        Perform Script [ by name: Get ( ScriptName ) ; Parameter: JSONSetElement ( "{}" ; [ "collection" ; "lines" ; JSONString ] ; [ "parentKey" ; $fmsb.thisKey ; JSONString ] ) ]
        If [ Left ( Get ( ScriptResult ) ; 6 ) = "!FMSB:" ]
            # Error handling block. Passing message instead of "?"
            Exit Script [ Result: Get ( ScriptResult ) ]
        End If
        Set Variable [ $fmsb.json ; Value: JSONSetElement ( $fmsb.json ; "lines" ; Get ( ScriptResult ) ; JSONArray ) ]
        Exit Script [ Result: $fmsb.json ]
    Else If [ $fmsb.collection = "lines" ]
        # ===== "lines" - one record becomes one element of this list =====
        # Your sample had 1 element. Keys: sku, qty
        # needs its OWN table occurrence + layout
        # ############################################
        # ##### SET THIS - find the "lines" records #####
        # ############################################
        # $lines_layout - layout of these records, quoted. Example: "Lines_list"
        Set Variable [ $lines_layout ; Value: "SET VALUE" ]
        # $lines_find_field - FK field on the child table, quoted. Example: "Lines::parent_id"
        Set Variable [ $lines_find_field ; Value: "SET VALUE" ]
        # ############################################
        # ##### END SET THIS #####
        # ############################################
        # $lines_find_value - pre-wired: exact match on the parent key - drop the "==" for begins-with
        Set Variable [ $lines_find_value ; Value: "==" & $fmsb.parentKey ]
        If [ IsEmpty ( $fmsb.parentKey ) ]
            Exit Script [ Result: "!FMSB: the parent key was empty - there is nothing to find the child records with" ]
        End If
        Go to Layout [ by name: $lines_layout ]
        If [ Get ( LayoutName ) <> $lines_layout or PatternCount ( List ( $lines_find_field ; $lines_find_value ) ; "SET VALUE" ) ]
            Go to Layout [ by name: $fmsb.home ]
            Exit Script [ Result: "!FMSB: check the SET THIS block above - the layout name is wrong, or a line still says SET VALUE" ]
        End If
        Enter Find Mode [ Pause: Off ]
        # find operators ( @ * # ? ! = < > " ~ .. ) inside key data need \ escaping
        Set Field By Name [
          Target name: $lines_find_field ;
          Value: $lines_find_value
        ]
        Perform Find
        If [ Get ( LastError ) = 400 ]
            # The find ran with no criteria (FileMaker error 400) - the field name above is blank or not a field on this layout's table
            Go to Layout [ by name: $fmsb.home ]
            Exit Script [ Result: "!FMSB: the find had no criteria - check the field name and the value in the SET THIS block above" ]
        End If
        Set Variable [ $fmsb.n ; Value: Get ( FoundCount ) ]
        Set Variable [ $fmsb.rows ; Value: "" ]
        Set Variable [ $fmsb.i ; Value: 1 ]
        Loop [ Flush: Always ]
            Exit Loop If [ $fmsb.i > $fmsb.n ]
            Go to Record/Request/Page [ With dialog: Off ; $fmsb.i ]
            # ############################################
            # ##### SET THIS - one field per key #####
            # ############################################
            # read once per record - keep inside the loop
            # $sku_value - your field for "sku". Sample: "A1"
            Set Variable [ $sku_value ; Value: "SET VALUE" ]
            # $qty_value - your field for "qty". Sample: 2
            Set Variable [ $qty_value ; Value: "SET VALUE" ]
            # ############################################
            # ##### END SET THIS #####
            # ############################################
            Set Variable [ $fmsb.row ; Value:
            ```
            JSONSetElement ( "{}" ;
              [ "sku" ; $sku_value ; JSONString ] ;
              [ "qty" ; $qty_value ; JSONNumber ]
            )
            ``` ]
            Set Variable [ $fmsb.rows ; Value: List ( $fmsb.rows ; $fmsb.row ) ]
            Set Variable [ $fmsb.i ; Value: $fmsb.i + 1 ]
        End Loop
        Go to Layout [ by name: $fmsb.home ]
        Exit Script [ Result: If ( IsEmpty ( $fmsb.rows ) ; "[]" ; JSONMakeArray ( $fmsb.rows ; "¶" ; JSONRaw ) ) ]
    Else
        # unknown collection
        Exit Script [ Result: "!FMSB: no branch for this collection" ]
    End If
End If