ODBC Driver for HubSpot

Build 23.0.8839


Retrieves information about the available folders in HubSpot.

Table Specific Information

Folders represent any folders you can upload files to in your content optimization system within HubSpot.


When selecting folders, they can only be filtered by the Id, DeletedAt, Name, and ParentFolderId. Name can be used with the LIKE comparison. DeletedAt can be used with the > and < comparisons but cannot form a range. For example:

SELECT * FROM Folders WHERE DeletedAt >= '1/1/2014' AND DeletedAt <= '10/1/2014'
SELECT * FROM Folders WHERE Name LIKE 'foldername'
SELECT * FROM Folders WHERE Id = '123456798'


Name Type References Description
Id [KEY] Long The id of the folder.
Category Integer The category of the folder.
CreatedAt Datetime When the folder was created.
DeletedAt Datetime When the folder was deleted.
FullPath String The full path to the folder.
Name String The name of the folder.
ParentFolderId Long


The id of the parent folder for this folder if available.
UpdatedAt Datetime When the folder was last updated.
ExtraUrlParameters String An input only property for specifying additional parameters when selecting data from HubSpot. Specify the parameters as name=value pairs in a comma separated list. For instance, 'param1=value1,param2=value2,param3=value3'.

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