Retrieve keys in data store to bulk delete with Make API

[Youcef_Jamaleddine]

Hello I’m not having any luck with one of my script. I need to search records in data store. When I run the module it will return to me multiple bundle see screenshot:

The key is what I want to retrieve and parse into the make API to delete bulk records with keys in an json. Format should look like this at the end:

{“keys”:[“1abd2defk”,“568tyuj45”]}

So far I have this but I’m far off…

Thank you very much

[ThakurHemansh]

Use the ‘Array Aggregator’ to collect all the ‘Key’ values from the bundles into an array. Then you will map array ‘Key’ to the use the ‘JSON’ module to create the JSON structure. Here you will structure the collected array into the format {"keys": Array}.

[samliew]

Welcome to the Make community!

Firstly, Make has it’s own app, you can use the Make an API call module instead of HTTP:

Secondly, according to the API documentation for Delete data store records, the request body should be as follows:

{
  "keys": [
    "1abd2defk",
    "568tyuj45"
  ]
}

You’ll need a minimum of three modules:

1. Aggregate to Text

2. Make an API Call

Give it a go and let us know if you have any issues!

[Youcef_Jamaleddine]

Thank you very much. Very clear it works great. You are a genius!