Skip to main content

Steps to Fix Data Errors in a database table when new data is uploaded/inserted

Fixing data errors is essential for maintaining the accuracy, reliability, and usability of the information stored in a database table. This is particularly important for performing searches, as data errors can prevent the successful retrieval of new information that is added to the table.

Step 1: Run cURL​

Run the below curL on Postman- (Production/ Staging/ Sandbox)

curl --location 'https://app.yellow.ai/api/data/data/reIndex?bot=x1611920798285&collection=customer_details' \
--header 'x-auth-token: 8a4f1e914fceb6fe69df01f27da4a9a0594980694d79d52dcf50b60850c91d1a6V77z4YIES88iN-CbDE3j'

Download and add the cookie editor extension to Chrome for running the cookie and generating the x-auth-token (Production/ Staging/ Sandbox).

Step 3: Generate x-auth-token key​

x-api-key isn’t suitable for use here, generate the x-auth-token key.

  1. Open cookie-editor extension on the database table for the table you want to Fix data errors.

  1. Select the value under ym_xid.

  1. Paste the value under Headers in Postman with key as x-auth-token.

Step 4: Verify database​

Open the Database table, refresh the page, and verify whether the Fix data errors issue has been resolved in the table.

Sample response:

{
"success": true,
"message": "re-index",
"data": "done",
"subscriptionExceeded": false
}