Social Logs (Full Update)
Description
If the UUID of the Customer Social Log exists in the system, or no UUID is provided and an External ID exists, then an update is performed. Otherwise a new social log is created.
See the Aerial Spec for more details.
File Naming Convention
TGEN_socialLogs_fullupdate_2025-08_<optionalSuffix>.csv
importType:fullupdateapiVersion:2025-08
Columns
| Column Header | Description | Key Information | Type | Required |
|---|---|---|---|---|
uuid | Unique Tulip identifier of the social log / customer note | Max Length: 36 | string | No |
externalId | Integrator provided unique identifier for the customer notes. Typically used to map a primary key from a third party system to the Tulip resource. | Max Length: 255 | string | No |
customer | UUID of the customer associated with the note/log | Max Length: 255 | string | No |
employee | UUID of the employee who created the note/log | Max Length: 255 | string | No |
store | UUID of the store associated with the note/log | Max Length: 255 | string | No |
type | Type of social log. | Allowed: WHATSAPP, WECHAT, LINE, KAKAOTALK, IMESSAGE, INSTAGRAM, TIKTOK, MAIL, SNAPCHAT, YOUTUBE | string | No |
comments | Comments associated with the note | string | No | |
isPrivate | Boolean dictating if customer note is private or not | boolean | No | |
isDeleted | Boolean dictating if customer note is deleted or not | boolean | No | |
isGenerated | Boolean dictating if customer note is generated (autologged) or not | boolean | No | |
aiRequestUuid | UUID of the AI request that was used to generate the content of the message | Max Length: 36 | string | No |
sharedLink | Link associated with note with you share it. | string | No | |
template | UUID of the template associated with the note/log | Max Length: 255 | string | No |
wishlist | ID of the wishlist associated with the note/log | Max Length: 255 | string | No |
outreachSourceExternalId | Used with outreach tracking, the external ID representing the source of the outreach | Max Length: 255 | string | No |
outreachGroupUuid | Used with outreach tracking, the UUID to be used when grouping outreaches together | Max Length: 255 | string | No |
outreachSourceContextUuid | Used with outreach tracking, a UUID associated with the source of the outreach, ex. the UUID of a customer list | Max Length: 255 | string | No |
Sample CSV
See the following socialLogs CSV sample file.