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.
Method and endpoint
/odata/{clienttablename}?{queryparameter}
Parameters
Parameter | Type | Description | Required |
{clienttablename} | String | The name of the client schema table in your Anaplan Fluence environment. | Yes |
{queryparameter} | String | The name of the column that contains the values to update. | Yes |
Curl example
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
}'