Excel Add-In for Zoho Projects

Build 26.0.9770

Portals

Gets all the portals for the logged in user.

Select

The add-in will use the Zoho Projects API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.

  • Id supports '=' operator.
For example, the following query is processed server side:
SELECT * FROM Portals WHERE Id = '20081021809'

Columns

Name Type Description
Id [KEY] Long Unique identifier of the portal.
Name String Display name of the portal.
OrgName String Organization name associated with the portal.
Timezone String Portal timezone.
LogoUrl String URL representing the organization logo.
OwnerId Long ZUID of the portal owner.
OwnerZpuid Long ZPUID of the portal owner.
OwnerFirstName String First name of the portal owner.
OwnerLastName String Last name of the portal owner.
OwnerName String Display name of the portal owner.
OwnerFullName String Full name of the portal owner.
OwnerBusinessHoursId Long Business hours ID of the portal owner.
OwnerIsClientUser Boolean Indicates if the portal owner is a client user.
OwnerEmail String Email address of the portal owner.
IsDefaultPortal Boolean Indicates whether the portal is configured as the default portal for the user.
ProfileId Long Profile ID associated with the portal.
ProfileName String Profile name associated with the portal.
BugPlan String Bug tracker plan for the portal.
PortalType String Type of the portal.
ProjectPlan String Zoho Projects service plan for the portal.
PortalUrl String URL of the portal.
PortalOwner Long ZPUID of the portal owner.
Zsoid Long Service organization ID mapped to the portal.
StorageType String Storage type of the portal.
IsCustomDomainEnabled Boolean Indicates whether a custom domain is configured for the portal.
ProjectsServicePlan String Zoho Projects service plan.
BugtrackerServicePlan String Zoho BugTracker service plan.
BusinessStartTime String Start time of the business hours.
BusinessEndTime String Configured end time of working hours.
BusinessDateFormat String Date format for the portal.
BusinessTimeFormat String Time format for the portal.
BusinessWeekStartDay String Starting day of the week.
BusinessWeekStartYear String Starting year reference for weekly calculations.
BusinessWeekends String List of configured weekends.
BusinessWorkingDays String List of configured working days.

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