Set the table view for a JSON node in the current API operation. The table view is used for mapping records from an external system to records in Business Central (and can be set in node details, too).
Text
- Specifies the path to JSON node in XPath syntax. E.g. write /
for a root node, /customer/phones
for a phones node in customer object.Text
- Specifies the table view for mapping external system records to Business Central records. See the example for basic syntax – and use {{Field*}}
variable for referencing table field in the formula (e.g. {{Field1}}
for referencing field no. 1 in a table, like No.
field in a Customer table).//Add a table view to the customer record in root node
APIScriptRWU.ADD_VIEW('/','SORTING(No.) WHERE(No.=CONST({{!Field1}}))');