Create and Populate Your Note Map
The “API names” of the columns in your Analytics table are really just the column names surrounded by double quotes. Map the data we retrieved from the CRM Notes API call to the respective columns in your Analytics table. This columns data map will be relevant for both adding and updating rows.
We encase all this (and basically everything else in the function) in a ‘for each’ loop, cycling through all the notes we retrieved.