Update a client schema table with one or more rows of data.

The difference between the POST and PUT methods is that POST inserts new rows into the client schema table, while the PUT method updates existing rows in the client schema table. You must specify a query parameter that will specify to update one or more rows that match the column name.

You can use the GET method with the $filter query parameter set as the intersection of the metadata before and after updating the table, to check if the update is successful.

PUT

/odata/{clienttablename}?{queryparameter}

ParameterTypeDescriptionRequired
{clienttablename}StringThe name of the client schema table in your Anaplan Fluence environment.Yes
{queryparameter}StringThe name of the column that contains the values to update.Yes

This example shows how to update Consolidation client schema table, for account 1110, with an Amount of 25000.00.

curl --location --request PUT 'https://fluenceapi-prod.fluence.app/api/v2305.1/odata/Consolidation?Account_Name=1110' \

--header 'TENANT: CustomerTenant' \

--header 'Content-Type: application/json' \

--header 'X-API-TOKEN: ••••••' \

--data '{

     "Account_Name": "1110",

    "Movement_Name": "Closing",

    "Scenario_Name": "Forecast",

    "Date_Name": "2024 Dec",

    "Entity_Name": "160",

    "Intercompany_Name": "No Entity",

    "Audit_Name": "Source GL",

    "Currency_Name": "USD",

    "DataView_Name": "Value",

    "CostCenter_Name": "No CostCenter",

    "Product_Name": "No product",

    "Amount": 25000.00,

    "Text": null,

    "Periodic_Amount": 0.0

}'