How to delete element in an array by id in nested object using custom data api

Question

Hi, I'm having data with the following format:{"dataset_id": "4ac54805-18a2-46a6-afb7-8829eb0e1a27",&nbsp; &nbsp; &nbsp; &nbsp; "configurationDetails": {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "measurementType": "Generic Dataset",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "fields": [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "id": "0",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "name": "Id",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "type": "Property",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "dataType": "Integer",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "count": 150,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "visibility": true&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }}&nbsp;I want to delete fields with id=0, how to write the query for the delete custom data endpoint here:&nbsp;https://sisense.dev/guides/restApi/custom-data.html#:~:text=DELETE,v1/custom_data/query

antonv · Accepted Answer

I am not asking you why you're doing this, but the technical answer to your question is:

db.collection.updateOne({"dataset_id": "4ac54805-18a2-46a6-afb7-8829eb0e1a27"},{"$pull":{"configurationDetails.fields":{"id": "0"}}})

It will remove the entire element of the 'fields' array with "id": "0"

Forum Discussion

How to delete element in an array by id in nested object using custom data api

2 Replies

Recent Discussions

JavaScript does not work for Tabber

Disappearing widgets

Two calculations displaying separately in a single field

Webhooks on MS Teams

Build To Destination Failure

Sisense

Support

Resources