Unique id of the reaction — the serialized WhatsApp id of the reaction event, in the form <fromMe><chat_id><wa_id>_<sender>
Org phone (WhatsApp account) the reaction was synced under, as country code + number suffixed with @c.us. Pass the x-phone header to scope results to one org phone.
Chat the reaction happened in — <group-id>@g.us for group chats, <countrycode><number>@c.us for 1-1 chats. Use it as the chat_id query filter.
message_id of the message that was reacted to, in the form <fromMe><chat_id><wa_id>_<sender>. Use it as the message_id query filter to fetch all reactions on one message.
WhatsApp id of who sent the reaction, as <countrycode><number>@c.us. This is the org phone itself when the reaction was sent from the connected phone.
The reaction emoji. Empty or null when the record carries no emoji (e.g. the sender removed their reaction).
When the reaction was sent, as an ISO 8601 timestamp. Reactions are ordered by this field (newest first) and filtered on it by start_time/end_time.
Delivery status of the reaction, tracked for reactions sent by the org phone: -1 failed, 0 pending, 1 sent to WhatsApp servers, 2 delivered to WhatsApp, 3 delivered to the recipient, 4 read, 5 played. null when not tracked.
The WhatsApp message id portion of the reacted-to message (msg_id.id). null when not available.
Internal flag set by the WhatsApp sync pipeline. 0 or null for reactions that synced normally.