Posting Tables

Sometimes it may be required to post multiple lines of table data in a single request. Special notation is required to support this scenario.

When a request body includes an array, universal iPaaS will check for special notation features referencing table data points. When referencing repeat items for table population, use the notation {t_TableName[FieldName]}

{
    "Line": [
        {
            "Amount": "{t_Expense Lines[Amount]}",
            "AccountBasedExpenseLineDetail": {
                "AccountRef": {
                    "value": "{t_Expense Lines[Category]}"
                }
            }
        }
    ]
}

In this example, “Line” is an array of objects. Using “t_” notation, Universal iPaaS knows to repeat the array element for each row of the referenced table.

DO NOT reference multiple tables in a single root element. This will not work and will cause error processes. You may have multiple root elements in an array that reference individual tables.

Square 9 Support Knowledge Base

Posting Tables

Analytics

Related content