Search Your CRM Notes Table for Existing Notes

Run the check using the export API call. In our criteria variable we match the Note ID column to the “id” of our note to see if that note already exists in Analytics. If it doesn’t, there won’t be any data in our API call response. If it does, then it will return the JSON data of that note it found in the Analytics table.

Based on the response of that API call, we can determine whether to add or update the note in Analytics.

Thus, in order to test this API call and our conditional logic out, simply run it once while ensuring that the ID of the modified note you’re checking for is in fact in a row in the Analytics table. The exportResponse returns a result, showing that it found a match.

Then, compare that with when there is no row in the table with a matching ID. It returns no result.

Back to Lesson