AnsweredAssumed Answered

REST API - Insert including foreign table relationship

Question asked by edwinevans on Apr 19, 2018
Latest reply on Oct 25, 2018 by edwinevans

I'm using REST Data API in FileMaker 16 and  trying to insert a new row into a table which has a related table. There is an Order and the Order has Line Items which is stored in another table/database. (I'm new to FileMaker and working with a third party project.)

 

This is my attempt to do this though I'm not sure if this is the right way:

{

    "data": {

        "OrderID": "001",

        "LineItems(0)": {

          "Product":"123"     

        }

    }

}

 

The call succeeds if I don't include the LineItems(0) section which is stored in a related table. This is the error I'm getting:

 

{

    "errorMessage": "Value in field failed calculation test of validation entry option",

    "errorCode": "507"

}

 

Am I taking the right general approach to be able to create the order and line item in a single POST call? Any suggestion for how to debug?

 

Thanks!

Outcomes