Power BI Connector for Zoho Inventory

Build 24.0.9062

ContactListComments

List recent activities of a contact

Table Specific Information

Select

The 本製品 will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.

  • ContactId supports the '=' comparison.
  • CommentId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ContactListComments WHERE ContactId = '3350895000000089001'

SELECT * FROM ContactListComments WHERE CommentId = '3350895000000089001'

Columns

Name Type References Description
CommentId [KEY] Long The unique id of each comment associated with a contact
CommentedBy String The name of the person who has commented
CommentedById Long The unique id generated for the person who has commented
ContactId Long

Contacts.Id

The unique id generated by the contact server
ContactName String The name of the contact
Date Date Date when the comment was made
DateDescription String Days passed from the day when comment was made
Description String Description
IsEntityDeleted Boolean A boolean value which will be true if the comment will be deleted.
OperationType String Type of Operation
Time Datetime Time when te comment was made
TransactionId Long Id for the transaction
TransactionType String Type of transaction

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062