How to delete the crosswalks of relation by source name/source table?

Question

The user wants to delete the crosswalks of relation by source name/source table.

How can it be achieved?

Answer

If a Relation has 3 crosswalks with different source names/source tables, we need to delete one by source name/source table keeping other crosswalks of that relation untouched.

You can use the below API to delete the crosswalks of relation by source name/source table (passing that in the body)

POST {tenantURL}/relations/crosswalks/_delete

Body

[
{
	"type": "configuration/sources/{{crosswalk_type}}",
	"sourceTable": "{{source_table}}",       -- This is optional parameter
	"value": "{{crosswalk_value}}"
},
...
]

For bulk deletion of relational crosswalks in the tenant, Please follow the below steps.

1. Extract all the relational crosswalks you want to delete.

2. Put them in the request body.

3. Run the above API.

Note

In the request body, try not to use more than 50 crosswalks in a single batch.