Use the DELETE method in the OData endpoint to remove rows from a client schema table when they are no longer needed or relevant.

The API request must include a query parameter that'll translate to delete one or more rows that match the query parameter.

Method and endpoint

DELETE

/odata/{clienttablename}?{queryparameter}

Parameters

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

Curl example

To delete any rows where the Account_Name = 1110:

curl --location --request DELETE '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: 73ca5973-ce3e-4cc6-b2d4-b09a99770ccf' \

--data '{

    "Account_Name": "6001",

    "Audit_Name": "Reclassification",

    "CostCenter_Name": "000",

    "Currency_Name": "USD",

    "DataView_Name": "Value",

    "Date_Name": "2024 Dec",

    "Entity_Name": "120",

    "Intercompany_Name": "No Intercompany",

    "Movement_Name": "Closing",

    "Product_Name": "No product",

    "Scenario_Name": "Budget",

    "Amount": 25000.00,

    "Text": null,

    "Periodic_Amount": null

}'

To delete all the records from a client schema table while retaining the schema, you just need to specify the table name:

curl --location --request DELETE 'https://fluenceapi-prod.fluence.app/api/v2305.1/odata/Consolidation

Response