SSIS Components for Zoho Projects

Build 24.0.9062

ForumComments

Gets all the forum comments.

Select

  • ForumId is required to retrieve Forum Comments.
You can use the below query to get all Forum Comments:
SELECT * FROM ForumComments WHERE ForumId = '123456000000045018'

Insert

To create a new Forum Comment you can use the below query:

INSERT INTO ForumComments (ForumId, Content, ParentId) 
VALUES ('123456000000045028', 'Forum Comment Reply', '123456000000043083')

Delete

Forum Comments can be deleted by providing the Id, ForumId and issuing a DELETE statement.

DELETE FROM ForumComments WHERE Id = '123456000000043083' AND ForumId = '123456000000045028'

Columns

Name Type ReadOnly Description
ForumId [KEY] Long False

Forum Id.

Id [KEY] String False

Forum Comment Id.

Content String False

Forum Comment Content.

Type String False

Forum Comment Type.

Attachments String False

Forum Comment Attachments.

IsBestAnswer Boolean False

Forum Comment Is Best Answer.

Level String False

Forum Comment Level.

ParentId String False

Forum Comment Parent Id.

ParentPostedBy String False

Forum Comment Parent Posted By.

ParentPostedByZpuid String False

Forum Comment Parent Posted By ZPUID.

PostDate Date False

Forum Comment Post Date.

PostDateTime Datetime False

Forum Comment Post Date Time.

PostedBy String False

Forum Comment Posted By.

PostedByZpuid String False

Forum Comment Posted By Zpuid.

PostedPerson String False

Forum Comment Posted Person.

RootId String False

Forum Comment Root Id.

ThirdPartyAttachments String False

Forum Comment Third Party Attachments.

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