API Data Provider - Online Help

Articles

Retrieve Articles data from Zoho Desk.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the knowledge base article

AuthorName String True

Author name

CategoryName String True

Category name

LatestVersionModifiedByName String True

Latestversionmodifiedby name

OwnerName String True

Owner name

QuickEditModifiedByName String True

Modifiedby name

ReviewedByName String True

Reviewedby name

SeoTitle String False

Seo title

Title String False

Title of the knowledge base article

AuthorStatus String True

Author status

AvailableLocaleTranslationsLatestVersionStatus String True

Availablelocaletranslations latestversionstatus

AvailableLocaleTranslationsStatus String True

Availablelocaletranslations status

LatestVersionModifiedByStatus String True

Latestversionmodifiedby status

LatestVersionStatus String True

Latestversionstatus

OwnerStatus String True

Owner status

QuickEditModifiedByStatus String True

Modifiedby status

ReviewedByStatus String True

Reviewedby status

Status String False

Current status of the article

CreatedTime Datetime True

Timestamp when the article was created

ModifiedTime Datetime True

Timestamp when the article was last modified

CategoryId String False

Category id

CategoryLocale String True

Category locale

RootCategoryId String True

Rootcategoryid

SeoDescription String False

Seo description

Answer String False

Answer

AttachmentCount Long True

Attachmentcount

Attachments String True

Attachments

AuthorId String True

Author id

AuthorPhotoUrl String True

Author photourl

AuthorZuId String True

Author zuid

AvailableLocaleTranslationId String True

Availablelocaletranslations translationid

AvailableLocaleTranslationsAuthorId String True

Availablelocaletranslations authorid

AvailableLocaleTranslationsHref String True

Availablelocaletranslations href

IsAvailableLocaleTranslationsLocked Boolean True

Availablelocaletranslations islocked

IsAvailableLocaleTranslationsTrashed Boolean True

Availablelocaletranslations istrashed

AvailableLocaleTranslationsLatestPublishedVersion Double True

Availablelocaletranslations latestpublishedversion

AvailableLocaleTranslationsLatestVersion Double True

Availablelocaletranslations latestversion

AvailableLocaleTranslationsLocale String True

Availablelocaletranslations locale

AvailableLocaleTranslationState String True

Availablelocaletranslations translationstate

CommentCount Long True

Commentcount

CreatedBy String True

Createdby

CreatorId String True

Creatorid

CurrentVersion Double True

Currentversion

DepartmentId String False

Departmentid

DislikeCount Long True

Dislikecount

ExpiryDate Datetime True

Expirydate

FeedbackCount Long True

Feedbackcount

IsFollowing Boolean True

Isfollowing

IsTemplate Boolean True

Istemplate

IsTrashed Boolean True

Istrashed

LatestPublishedVersion Double True

Latestpublishedversion

LatestVersion Double True

Latestversion

LatestVersionModifiedById String True

Latestversionmodifiedby id

LatestVersionModifiedByPhotoUrl String True

Latestversionmodifiedby photourl

LatestVersionModifiedByZuId String True

Latestversionmodifiedby zuid

LikeCount Long True

Likecount

Locale String True

Locale

MetricsDislikeCount Long True

Metrics dislikecount

MetricsFeedbackCount Long True

Metrics feedbackcount

MetricsLastActivityTime Datetime True

Metrics lastactivitytime

MetricsLastUsageTime Datetime True

Metrics lastusagetime

MetricsLikeCount Long True

Metrics likecount

MetricsTemplateUsageCount Long True

Metrics templateusagecount

MetricsUnlikeCount Long True

Metrics unlikecount

MetricsUsageCount Long True

Metrics usagecount

MetricsViewCount Long True

Metrics viewcount

ModifiedBy String True

Modifiedby

ModifierId String True

Modifierid

MyVote String True

Myvote

OwnerId String True

Owner id

OwnerPhotoUrl String True

Owner photourl

OwnerZuId String True

Owner zuid

Permalink String True

Permalink

Permission String False

Permission

PortalUrl String True

Portalurl

Position String True

Position

QuickEditModifiedById String True

Modifiedby id

QuickEditModifiedByPhotoUrl String True

Modifiedby photourl

QuickEditModifiedByZuId String True

Modifiedby zuid

QuickEditModifierId String True

Quickedit modifierid

ReviewedById String True

Reviewedby id

ReviewedByPhotoUrl String True

Reviewedby photourl

ReviewedByZuId String True

Reviewedby zuid

ReviewedTime Datetime True

Reviewedtime

IsSeoEnabled Boolean True

Seo isenabled

SeoKeywords String False

Seo keywords

SourceLocale String True

Sourcelocale

Summary String True

Summary

Tags String False

Tags

TemplateLastUpdatedTime Datetime True

Templatelastupdatedtime

TemplateUsageCount Long True

Templateusagecount

TemplateUsedUsersCount Long True

Templateuseduserscount

TranslationId String True

Translationid

TranslationSource String True

Translationsource

TranslationState String True

Translationstate

UsageCount Long True

Usagecount

ViewCount Long True

Viewcount

WebUrl String True

Weburl

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
ExpiryTimeRange String

Date range for filtering articles by expiry date

ModifiedTimeRange String

Date range for filtering articles by last modified time

Version Double

Specific version number of the article to retrieve

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0