How to "DELETE" a Member through the API using Zapier
This article shows an example of how a Google Spreadsheet can be used to delete member data using the site's API.
Checklist Before Moving Forward With This Example
1) Make sure to generate a unique API Key using the documentation down below as a guideline. Please make sure to save the API Key in a safe place as it is not accessible after it has been created:
2) Make sure to have a Google Spreadsheet ready. This spreadsheet should have at least one row of the member data information shown below:
Please note the following required fields in order to delete member data:
- user_id
- company or first_name / last_name to recognize who is being deleted
Connecting Google Sheets with Zapier
Log in to the Zapier account and click on + Create and click on Zaps:
or Click on Zaps
Click on + Create then click on New Zap:
Click on Trigger and search for Google Sheet:
The Trigger event should be set to "New or Updated Spreadsheet Row." After logging into the Google account, clicking on "Continue" will proceed.
Select the Spreadsheet that has the member information with the respective Worksheet. If necessary, select a Trigger Column or leave as "any column" and click on Continue:
Click on Continue with Selected Record. The Spreadsheet information will display as a preview:
Connecting the API with Zapier
A new set of options will appear, select the option for Brilliant Directories:
The Action Event should be set to "Delete User." A Brilliant Directories account can be chosen if one has been used before, or a new account can be connected.
If this is the first time, click on Connect a new account and a popup will show up. Add the website URL and the API Key, and click Yes, Continue to Brilliant Directories:
Once finished, click Continue.
Configuring the User Information
Click on Continue.
Click on the vertical dots and select Custom.
Select user_id. Hit Continue.
Zapier will display the question, 'Do you also want to delete the member's images?' Click 'Yes' if the images need to be deleted. We recommend selecting 'Yes' to avoid leaving unused images on the site.
Click on Test Step:
The User is now deleted, click on Publish to have the Zap active.
Add a name to the Zap to find it easily:
If done correctly, the member will be removed from the website.
Click on Transfer existing data if there is a need to delete the members right away. For automatic deletion, simply waiting a few minutes for the trigger "New or Updated Spreadsheet Row" to take action is all that's needed.
