ODBC guide

Upload a file (generic request)

Uploads a file using the generic request table. Supply the local file path, folder path, and file name in the request body. For OAuth apps, the app may need file-manager access; otherwise the API returns a permissions error. See HubSpot Files API docs for options (e.g. access, overwrite).

SELECT *
FROM generic_request
WITH (
  Url='filemanager/api/v3/files/upload',
  RequestMethod='POST',
  Filter='$.objects[*]',
  Body='file=@C:\data\logo.png
folderPath=/
fileName=logo.png
options={"access": "PRIVATE", "overwrite": true}',
  IsMultiPart='True',
  Meta='id:long; name:string; title:string; url: string; type:string; size:long; friendly_url:string; meta.allows_anonymous_access:string; meta.indexable:bool'
)