Oauth Permissions Error

oauth
forms

#1

@pmanca - I am probably not as technical as the rest of the people here. My company recently started using
HubSpot for marketing. I am trying to bring in the data into Tableau and since there is not any native integration I have used CData. Most tables are coming in great (contacts, companies, email campaigns) but for some reason I am getting a "This oauth-token (x) does not have proper permissions! (requires any of [forms-access, form-submissions]) " error when I try to use Forms data. I have all Marketing permissions except admin rights. Any help would be much appreciated.

SELECT “Forms”.“Name” AS "Name"
FROM “HubSpot”.“Forms” "Forms"
GROUP BY “Forms”.“Name”


#2

@GuillermoV Can you show me the OAuth call you are making? Are you asking for Forms data when you make that call?


#3

Again I am not as technical as the rest of the people on the board but here is the TXT file that I get from CData. Hope this is what you are looking for.


2017-06-12T10:24:00.031-04:00 2 Driver Manager: 2
2017-06-12T10:24:00.034-04:00 2 Unicode: -1
2017-06-12T10:24:00.080-04:00 3 [Connection: 1]
2017-06-12T10:24:00.244-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (161 ms).
2017-06-12T10:24:00.380-04:00 2 [Request] POST https://api.hubapi.com/oauth/v1/token
2017-06-12T10:24:02.194-04:00 2 [Response] HTTP/1.1 200 OK, 168 Bytes Transferred
2017-06-12T10:24:02.196-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
POST /oauth/v1/token HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close
Content-Type: application/x-www-form-urlencoded
Content-Length: 204

client_id=0bb9cfde-3476-11e5-9def-3ff296bb2e59&client_secret=ff1a9418-ef28-4d55-8d3f-0a1e3a82f57f&refresh_token=0c76e738-c98f-4f82-8a3c-d6ee28772d68&redirect_uri=https://localhost&grant_type=refresh_token

2017-06-12T10:24:02.196-04:00 3 [Response]
[HTTP Headers]
HTTP/1.1 200 OK
Access-Control-Allow-Credentials: false
Cache-Control: no-store, no-transform
Content-Encoding: gzip
Content-Type: application/json; charset=UTF-8
Pragma: no-cache
Vary: Accept-Encoding, User-Agent
Content-Length: 168
Date: Mon, 12 Jun 2017 14:23:44 GMT
Connection: close
{“refresh_token”:“0c76e738-c98f-4f82-8a3c-d6ee28772d68”,“access_token”:“CPTx5-_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khMBXV4TefdwiKChyecmjRNu7ttSmQ”,“expires_in”:21600}
2017-06-12T10:24:02.260-04:00 1 [Connection: 1] Opened HubSpot connection. Version: 16.0.6348.0. Edition: [WIN ODBC Driver 32-bit].
2017-06-12T10:24:02.262-04:00 1 [Connection: 1] Connection String: _persist_oauthaccesstoken=“";_persist_oauthexpiresin=“21600”;_persist_oauthrefreshtoken=“0c76e738-c98f-4f82-8a3c-d6ee28772d68”;_persist_token_timestamp=“1497277440253”;autocache=“False”;cacheconnection="";cachelocation=“C:\Users\Guillermo Vidaurre\Documents\CData\CData.ODBCm.HubSpot.db”;cachemetadata=“False”;cacheprovider="";callbackurl="";catalog=“CData”;columnsizes="";contactpropertiesfile="";dealpropertiesfile="";expiresin=“21600”;firewallpassword="";firewallport="";firewallserver="";firewalltype=“NONE”;firewalluser="";includedualtable=“False”;initiateoauth=“getandrefresh”;intconfigguiavailable=“false”;limitkeysize=“255”;location="";logfile=“C:\Users\Guillermo Vidaurre\Desktop\HubSpot.TXT”;maptoint=“False”;maptolongvarchar="-1";maptowvarchar=“True”;maximumcolumnsize=“16000”;maxlogfilesize=“10000000”;oauthaccesstoken="”;oauthclientid="";oauthclientsecret="";oauthrefreshtoken=“0c76e738-c98f-4f82-8a3c-d6ee28772d68”;offline=“False”;other=“IntConfigGUIAvailable=false”;proxyauthscheme=“BASIC”;proxyautodetect=“True”;proxypassword="";proxyport=“80”;proxyserver="";proxyssltype=“AUTO”;proxyuser="";pseudocolumns="";querycache="";readonly=“False”;rtk="";schema=“HubSpot”;sslservercert="";supportenhancedsql=“True”;tables="";timeout=“60”;uppercaseidentifiers=“False”;usedisplaynames=“True”;usesimplenames=“False”;verbosity="3"
2017-06-12T10:24:02.817-04:00 2 Driver Manager: 2
2017-06-12T10:24:02.818-04:00 2 Unicode: -1
2017-06-12T10:24:02.861-04:00 3 [Connection: 1]
2017-06-12T10:24:03.050-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (186 ms).
2017-06-12T10:24:03.186-04:00 2 [Request] POST https://api.hubapi.com/oauth/v1/token
2017-06-12T10:24:04.551-04:00 2 [Response] HTTP/1.1 200 OK, 168 Bytes Transferred
2017-06-12T10:24:04.553-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
POST /oauth/v1/token HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close
Content-Type: application/x-www-form-urlencoded
Content-Length: 204

client_id=0bb9cfde-3476-11e5-9def-3ff296bb2e59&client_secret=ff1a9418-ef28-4d55-8d3f-0a1e3a82f57f&refresh_token=0c76e738-c98f-4f82-8a3c-d6ee28772d68&redirect_uri=https://localhost&grant_type=refresh_token

2017-06-12T10:24:04.553-04:00 3 [Response]
[HTTP Headers]
HTTP/1.1 200 OK
Access-Control-Allow-Credentials: false
Cache-Control: no-store, no-transform
Content-Encoding: gzip
Content-Type: application/json; charset=UTF-8
Pragma: no-cache
Vary: Accept-Encoding, User-Agent
Content-Length: 168
Date: Mon, 12 Jun 2017 14:23:46 GMT
Connection: close
{“refresh_token”:“0c76e738-c98f-4f82-8a3c-d6ee28772d68”,“access_token”:“CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg”,“expires_in”:21600}
2017-06-12T10:24:04.599-04:00 1 [Connection: 1] Opened HubSpot connection. Version: 16.0.6348.0. Edition: [WIN ODBC Driver 32-bit].
2017-06-12T10:24:04.601-04:00 1 [Connection: 1] Connection String: _persist_oauthaccesstoken=“";_persist_oauthexpiresin=“21600”;_persist_oauthrefreshtoken=“0c76e738-c98f-4f82-8a3c-d6ee28772d68”;_persist_token_timestamp=“1497277443057”;autocache=“False”;cacheconnection="";cachelocation=“C:\Users\Guillermo Vidaurre\Documents\CData\CData.ODBCm.HubSpot.db”;cachemetadata=“False”;cacheprovider="";callbackurl="";catalog=“CData”;columnsizes="";contactpropertiesfile="";dealpropertiesfile="";expiresin=“21600”;firewallpassword="";firewallport="";firewallserver="";firewalltype=“NONE”;firewalluser="";includedualtable=“False”;initiateoauth=“getandrefresh”;intconfigguiavailable=“false”;limitkeysize=“255”;location="";logfile=“C:\Users\Guillermo Vidaurre\Desktop\HubSpot.TXT”;maptoint=“False”;maptolongvarchar="-1";maptowvarchar=“True”;maximumcolumnsize=“16000”;maxlogfilesize=“10000000”;oauthaccesstoken="”;oauthclientid="";oauthclientsecret="";oauthrefreshtoken=“0c76e738-c98f-4f82-8a3c-d6ee28772d68”;offline=“False”;other=“IntConfigGUIAvailable=false”;proxyauthscheme=“BASIC”;proxyautodetect=“True”;proxypassword="";proxyport=“80”;proxyserver="";proxyssltype=“AUTO”;proxyuser="";pseudocolumns="";querycache="";readonly=“False”;rtk="";schema=“HubSpot”;sslservercert="";supportenhancedsql=“True”;tables="";timeout=“60”;uppercaseidentifiers=“False”;usedisplaynames=“True”;usesimplenames=“False”;verbosity=“3"
2017-06-12T10:24:04.727-04:00 2 [Connection: 1] Executing query: [DROP TABLE “XTB_A_DAHCDFCC_EFFJ_EAIC_BCJB_DHHHEFBEBGA_Connect”].
2017-06-12T10:24:04.738-04:00 3 [Connection: 1]
2017-06-12T10:24:04.795-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (57 ms).
2017-06-12T10:24:04.801-04:00 0 [Connection: 1] Query Failed: [DROP TABLE “XTB_A_DAHCDFCC_EFFJ_EAIC_BCJB_DHHHEFBEBGA_Connect”]. Error: The query cannot be executed: [DROP TABLE] is not supported.
2017-06-12T10:24:04.848-04:00 2 [Connection: 1] Executing query: [SELECT “COL” FROM (SELECT 1 AS “COL”) AS “SUBQUERY”].
2017-06-12T10:24:04.906-04:00 2 [Connection: 1] Executing query: [SELECT “COL” FROM (SELECT 1 AS “COL”) AS “SUBQUERY”].
2017-06-12T10:24:04.988-04:00 0 [Connection: 1] Query Failed: [SELECT “COL” FROM (SELECT 1 AS “COL”) AS “SUBQUERY”]. Error: Object reference not set to an instance of an object.
2017-06-12T10:24:05.002-04:00 2 [Connection: 1] Executing query: [SELECT * INTO “XTC_A_DAHCDFCC_EFFJ_EAIC_BCJB_DHHHEFBEBGA_Connect” FROM (SELECT 1 AS “COL”) AS “CHECKTEMP” LIMIT 1 OFFSET 0].
2017-06-12T10:24:05.018-04:00 0 [Connection: 1] Query Failed: [SELECT * INTO “XTC_A_DAHCDFCC_EFFJ_EAIC_BCJB_DHHHEFBEBGA_Connect” FROM (SELECT 1 AS “COL”) AS “CHECKTEMP” LIMIT 1 OFFSET 0]. Error: Unrecognized column [COL] in query for table [NESTED_QUERY89].
2017-06-12T10:24:05.030-04:00 2 [Connection: 1] Executing query: [DROP TABLE “XTC_A_DAHCDFCC_EFFJ_EAIC_BCJB_DHHHEFBEBGA_Connect”].
2017-06-12T10:24:05.030-04:00 3 [Connection: 1]
2017-06-12T10:24:05.030-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:05.031-04:00 0 [Connection: 1] Query Failed: [DROP TABLE “XTC_A_DAHCDFCC_EFFJ_EAIC_BCJB_DHHHEFBEBGA_Connect”]. Error: The query cannot be executed: [DROP TABLE] is not supported.
2017-06-12T10:24:05.048-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:05.076-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:05.078-04:00 3 [Connection: 1]
2017-06-12T10:24:05.078-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:05.149-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (73 ms).
2017-06-12T10:24:05.151-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:05.154-04:00 3 [Connection: 1]
2017-06-12T10:24:05.154-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:05.202-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (49 ms).
2017-06-12T10:24:05.248-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:05.249-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:05.249-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:05.250-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:05.250-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:05.254-04:00 2 [Connection: 1] Executing query: [SELECT 1].
2017-06-12T10:24:05.255-04:00 2 [Connection: 1] Executing query: [SELECT 1].
2017-06-12T10:24:05.311-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:05.311-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:05.311-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:05.311-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:05.311-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:05.350-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:05.350-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:05.350-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:05.351-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:05.351-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:08.011-04:00 2 Driver Manager: 2
2017-06-12T10:24:08.012-04:00 2 Unicode: -1
2017-06-12T10:24:08.050-04:00 3 [Connection: 1]
2017-06-12T10:24:08.252-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (200 ms).
2017-06-12T10:24:08.262-04:00 1 [Connection: 1] Opened HubSpot connection. Version: 16.0.6348.0. Edition: [WIN ODBC Driver 32-bit].
2017-06-12T10:24:08.264-04:00 1 [Connection: 1] Connection String: _persist_oauthaccesstoken=“";_persist_oauthexpiresin=“21600”;_persist_oauthrefreshtoken=“0c76e738-c98f-4f82-8a3c-d6ee28772d68”;_persist_token_timestamp=“1497277443057”;autocache=“False”;cacheconnection="";cachelocation=“C:\Users\Guillermo Vidaurre\Documents\CData\CData.ODBCm.HubSpot.db”;cachemetadata=“False”;cacheprovider="";callbackurl="";catalog=“CData”;columnsizes="";contactpropertiesfile="";dealpropertiesfile="";expiresin=“21600”;firewallpassword="";firewallport="";firewallserver="";firewalltype=“NONE”;firewalluser="";includedualtable=“False”;initiateoauth=“getandrefresh”;intconfigguiavailable=“false”;limitkeysize=“255”;location="";logfile=“C:\Users\Guillermo Vidaurre\Desktop\HubSpot.TXT”;maptoint=“False”;maptolongvarchar="-1";maptowvarchar=“True”;maximumcolumnsize=“16000”;maxlogfilesize=“10000000”;oauthaccesstoken="”;oauthclientid=”";oauthclientsecret="";offline=“False”;other=“IntConfigGUIAvailable=false”;proxyauthscheme=“BASIC”;proxyautodetect=“True”;proxypassword="";proxyport=“80”;proxyserver="";proxyssltype=“AUTO”;proxyuser="";pseudocolumns="";querycache="";readonly=“False”;rtk="";schema=“HubSpot”;sslservercert="";supportenhancedsql=“True”;tables="";timeout=“60”;uppercaseidentifiers=“False”;usedisplaynames=“True”;usesimplenames=“False”;verbosity=“3"
2017-06-12T10:24:17.291-04:00 2 Driver Manager: 2
2017-06-12T10:24:17.295-04:00 2 Unicode: -1
2017-06-12T10:24:17.330-04:00 3 [Connection: 1]
2017-06-12T10:24:17.484-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (152 ms).
2017-06-12T10:24:17.494-04:00 1 [Connection: 1] Opened HubSpot connection. Version: 16.0.6348.0. Edition: [WIN ODBC Driver 32-bit].
2017-06-12T10:24:17.496-04:00 1 [Connection: 1] Connection String: _persist_oauthaccesstoken=“";_persist_oauthexpiresin=“21600”;_persist_oauthrefreshtoken=“0c76e738-c98f-4f82-8a3c-d6ee28772d68”;_persist_token_timestamp=“1497277443057”;autocache=“False”;cacheconnection="";cachelocation=“C:\Users\Guillermo Vidaurre\Documents\CData\CData.ODBCm.HubSpot.db”;cachemetadata=“False”;cacheprovider="";callbackurl="";catalog=“CData”;columnsizes="";contactpropertiesfile="";dealpropertiesfile="";expiresin=“21600”;firewallpassword="";firewallport="";firewallserver="";firewalltype=“NONE”;firewalluser="";includedualtable=“False”;initiateoauth=“getandrefresh”;intconfigguiavailable=“false”;limitkeysize=“255”;location="";logfile=“C:\Users\Guillermo Vidaurre\Desktop\HubSpot.TXT”;maptoint=“False”;maptolongvarchar="-1";maptowvarchar=“True”;maximumcolumnsize=“16000”;maxlogfilesize=“10000000”;oauthaccesstoken="”;oauthclientid=”";oauthclientsecret="";offline=“False”;other=“IntConfigGUIAvailable=false”;proxyauthscheme=“BASIC”;proxyautodetect=“True”;proxypassword="";proxyport=“80”;proxyserver="";proxyssltype=“AUTO”;proxyuser="";pseudocolumns="";querycache="";readonly=“False”;rtk="";schema=“HubSpot”;sslservercert="";supportenhancedsql=“True”;tables="";timeout=“60”;uppercaseidentifiers=“False”;usedisplaynames=“True”;usesimplenames=“False”;verbosity="3"
2017-06-12T10:24:17.606-04:00 2 [Connection: 1] Executing query: [DROP TABLE “XTB_A_BGCICADC_JIDD_EDCA_AEBH_FEHEGBCFDHE_Connect”].
2017-06-12T10:24:17.617-04:00 3 [Connection: 1]
2017-06-12T10:24:17.665-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (48 ms).
2017-06-12T10:24:17.670-04:00 0 [Connection: 1] Query Failed: [DROP TABLE “XTB_A_BGCICADC_JIDD_EDCA_AEBH_FEHEGBCFDHE_Connect”]. Error: The query cannot be executed: [DROP TABLE] is not supported.
2017-06-12T10:24:17.707-04:00 2 [Connection: 1] Executing query: [SELECT “COL” FROM (SELECT 1 AS “COL”) AS “SUBQUERY”].
2017-06-12T10:24:17.754-04:00 2 [Connection: 1] Executing query: [SELECT “COL” FROM (SELECT 1 AS “COL”) AS “SUBQUERY”].
2017-06-12T10:24:17.813-04:00 0 [Connection: 1] Query Failed: [SELECT “COL” FROM (SELECT 1 AS “COL”) AS “SUBQUERY”]. Error: Object reference not set to an instance of an object.
2017-06-12T10:24:17.826-04:00 2 [Connection: 1] Executing query: [SELECT * INTO “XTC_A_BGCICADC_JIDD_EDCA_AEBH_FEHEGBCFDHE_Connect” FROM (SELECT 1 AS “COL”) AS “CHECKTEMP” LIMIT 1 OFFSET 0].
2017-06-12T10:24:17.839-04:00 0 [Connection: 1] Query Failed: [SELECT * INTO “XTC_A_BGCICADC_JIDD_EDCA_AEBH_FEHEGBCFDHE_Connect” FROM (SELECT 1 AS “COL”) AS “CHECKTEMP” LIMIT 1 OFFSET 0]. Error: Unrecognized column [COL] in query for table [NESTED_QUERY89].
2017-06-12T10:24:17.844-04:00 2 [Connection: 1] Executing query: [DROP TABLE “XTC_A_BGCICADC_JIDD_EDCA_AEBH_FEHEGBCFDHE_Connect”].
2017-06-12T10:24:17.844-04:00 3 [Connection: 1]
2017-06-12T10:24:17.844-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:17.845-04:00 0 [Connection: 1] Query Failed: [DROP TABLE “XTC_A_BGCICADC_JIDD_EDCA_AEBH_FEHEGBCFDHE_Connect”]. Error: The query cannot be executed: [DROP TABLE] is not supported.
2017-06-12T10:24:17.864-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:17.881-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:17.882-04:00 3 [Connection: 1]
2017-06-12T10:24:17.882-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:17.969-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (88 ms).
2017-06-12T10:24:17.971-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:17.975-04:00 3 [Connection: 1]
2017-06-12T10:24:17.975-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:18.019-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (45 ms).
2017-06-12T10:24:18.077-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:18.077-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:18.078-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (1 ms).
2017-06-12T10:24:18.078-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:18.078-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:18.091-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:18.091-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:18.091-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:18.091-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:18.091-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:18.126-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:18.126-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:18.126-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:18.126-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:18.126-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:49.661-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:49.661-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:49.661-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:49.662-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:49.662-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:49.676-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_tables].
2017-06-12T10:24:49.676-04:00 2 [Connection: 1] Executing table schema query: [].
2017-06-12T10:24:49.676-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:49.678-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS FROM sys_views].
2017-06-12T10:24:49.679-04:00 1 [Connection: 1] Executed table schema query: Table: [], Success: 18 results (0 ms).
2017-06-12T10:24:52.451-04:00 2 [Connection: 1] Executing query: [SELECT * FROM “HubSpot”.“Forms”].
2017-06-12T10:24:52.496-04:00 2 [Connection: 1] Executing column schema query: [Forms].
2017-06-12T10:24:52.496-04:00 3 [Connection: 1]
2017-06-12T10:24:52.496-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:52.500-04:00 1 [Connection: 1] Executed column schema query: [Forms], Success: 20 results (5 ms).
2017-06-12T10:24:52.514-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, IS_KEY, IS_FOREIGNKEY, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NNAME FROM sys_keycolumns WHERE TABLE_NAME like @0].
2017-06-12T10:24:52.514-04:00 2 [Connection: 1] Parameter: 0 = Forms
2017-06-12T10:24:52.530-04:00 2 [Connection: 1] Executing query: [SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, IS_KEY, IS_FOREIGNKEY, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NNAME FROM sys_keycolumns WHERE TABLE_NAME like @0].
2017-06-12T10:24:52.530-04:00 2 [Connection: 1] Parameter: 0 = Forms
2017-06-12T10:24:52.550-04:00 2 [Connection: 1] Executing query: [SELECT 1].
2017-06-12T10:24:52.551-04:00 2 [Connection: 1] Executing query: [SELECT 1].
2017-06-12T10:24:52.572-04:00 2 [Connection: 1] Executing query: [SELECT * FROM “HubSpot”.“Forms” LIMIT 1 OFFSET 0].
2017-06-12T10:24:52.576-04:00 2 [Connection: 1] Executing query: [SELECT * FROM “HubSpot”.“Forms” LIMIT 1 OFFSET 0].
2017-06-12T10:24:52.583-04:00 3 [Connection: 1]
2017-06-12T10:24:52.583-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:52.683-04:00 2 [Request] GET https://api.hubapi.com/contacts/v1/forms
2017-06-12T10:24:54.006-04:00 2 [Response] HTTP/1.1 403 Forbidden, 307 Bytes Transferred
2017-06-12T10:24:54.008-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
GET /contacts/v1/forms HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close

2017-06-12T10:24:54.008-04:00 3 [Response]
[HTTP Headers]
HTTP/1.1 403 Forbidden
Access-Control-Allow-Credentials: false
Access-Control-Expose-Headers: x-last-modified-timestamp, X-HubSpot-NotFound, X-HS-User-Request, Link, X-Total-Count
Content-Type: application/json; charset=UTF-8
Content-Length: 307
Date: Mon, 12 Jun 2017 14:24:35 GMT
Connection: close
{“status”:“error”,“message”:“This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])”,“correlationId”:“722a2e66-1f76-47a1-8992-36330d1c48b3”,“requestId”:“9cb00d1e9fccc549cd8e84cf12dc5cae”}
2017-06-12T10:24:54.044-04:00 0 [Connection: 1] Query Failed: [SELECT * FROM “HubSpot”.“Forms” LIMIT 1 OFFSET 0]. Error: This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])
2017-06-12T10:24:54.049-04:00 2 [Connection: 1] Executing query: [SELECT * FROM “HubSpot”.“Forms” LIMIT 1 OFFSET 0].
2017-06-12T10:24:54.055-04:00 2 [Connection: 1] Executing query: [SELECT * FROM “HubSpot”.“Forms” LIMIT 1 OFFSET 0].
2017-06-12T10:24:54.058-04:00 3 [Connection: 1]
2017-06-12T10:24:54.058-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:54.061-04:00 2 [Request] GET https://api.hubapi.com/contacts/v1/forms
2017-06-12T10:24:55.531-04:00 2 [Response] HTTP/1.1 403 Forbidden, 307 Bytes Transferred
2017-06-12T10:24:55.531-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
GET /contacts/v1/forms HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close

2017-06-12T10:24:55.531-04:00 3 [Response]
[HTTP Headers]
HTTP/1.1 403 Forbidden
Access-Control-Allow-Credentials: false
Access-Control-Expose-Headers: x-last-modified-timestamp, X-HubSpot-NotFound, X-HS-User-Request, Link, X-Total-Count
Content-Type: application/json; charset=UTF-8
Content-Length: 307
Date: Mon, 12 Jun 2017 14:24:37 GMT
Connection: close
{“status”:“error”,“message”:“This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])”,“correlationId”:“f40e5553-2f78-4610-919d-467df32a958e”,“requestId”:“2023fa5638efb65e36747e2996942291”}
2017-06-12T10:24:55.532-04:00 0 [Connection: 1] Query Failed: [SELECT * FROM “HubSpot”.“Forms” LIMIT 1 OFFSET 0]. Error: This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])
2017-06-12T10:24:55.536-04:00 2 [Connection: 1] Executing query: [SELECT * FROM (SELECT * FROM “HubSpot”.“Forms”) WHERE “ROWNUM” <= 1].
2017-06-12T10:24:55.544-04:00 2 [Connection: 1] Executing query: [SELECT * FROM (SELECT * FROM “HubSpot”.“Forms”) WHERE “ROWNUM” <= 1].
2017-06-12T10:24:55.575-04:00 3 [Connection: 1]
2017-06-12T10:24:55.576-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:55.579-04:00 2 [Request] GET https://api.hubapi.com/contacts/v1/forms
2017-06-12T10:24:56.898-04:00 2 [Response] HTTP/1.1 403 Forbidden, 307 Bytes Transferred
2017-06-12T10:24:56.898-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
GET /contacts/v1/forms HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close

2017-06-12T10:24:56.898-04:00 3 [Response]
[HTTP Headers]
HTTP/1.1 403 Forbidden
Access-Control-Allow-Credentials: false
Access-Control-Expose-Headers: x-last-modified-timestamp, X-HubSpot-NotFound, X-HS-User-Request, Link, X-Total-Count
Content-Type: application/json; charset=UTF-8
Content-Length: 307
Date: Mon, 12 Jun 2017 14:24:38 GMT
Connection: close
{“status”:“error”,“message”:“This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])”,“correlationId”:“1a871495-eafa-4cfc-be59-6d68c76a7325”,“requestId”:“9c2f046a92d89dac0d80e38b17743a62”}
2017-06-12T10:24:56.899-04:00 0 [Connection: 1] Query Failed: [SELECT * FROM (SELECT * FROM “HubSpot”.“Forms”) WHERE “ROWNUM” <= 1]. Error: This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])
2017-06-12T10:24:56.922-04:00 2 [Connection: 1] Executing query: [SELECT SUM(1) AS “COL” FROM “HubSpot”.“Forms” HAVING COUNT(1) > 0].
2017-06-12T10:24:56.937-04:00 2 [Connection: 1] Executing query: [SELECT SUM(1) AS “COL” FROM “HubSpot”.“Forms” HAVING COUNT(1) > 0].
2017-06-12T10:24:56.945-04:00 3 [Connection: 1]
2017-06-12T10:24:56.945-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:56.948-04:00 2 [Request] GET https://api.hubapi.com/contacts/v1/forms
2017-06-12T10:24:58.330-04:00 2 [Response] HTTP/1.1 403 Forbidden, 307 Bytes Transferred
2017-06-12T10:24:58.330-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
GET /contacts/v1/forms HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close

2017-06-12T10:24:58.330-04:00 3 [Response]
[HTTP Headers]
HTTP/1.1 403 Forbidden
Access-Control-Allow-Credentials: false
Access-Control-Expose-Headers: x-last-modified-timestamp, X-HubSpot-NotFound, X-HS-User-Request, Link, X-Total-Count
Content-Type: application/json; charset=UTF-8
Content-Length: 307
Date: Mon, 12 Jun 2017 14:24:40 GMT
Connection: close
{“status”:“error”,“message”:“This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])”,“correlationId”:“df7fe5b6-8aab-40c9-88e2-d70962339a57”,“requestId”:“c766bdd387b9fb23f02af8f9b1d06848”}
2017-06-12T10:24:58.331-04:00 0 [Connection: 1] Query Failed: [SELECT SUM(1) AS “COL” FROM “HubSpot”.“Forms” HAVING COUNT(1) > 0]. Error: This oauth-token (CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg) does not have proper permissions! (requires any of [forms-access, form-submissions])
2017-06-12T10:24:58.339-04:00 2 [Connection: 1] Executing query: [SELECT SUM(1) AS “COL”, 2 AS “COL2” FROM “HubSpot”.“Forms” GROUP BY 2 HAVING COUNT(1) > 0].
2017-06-12T10:24:58.350-04:00 2 [Connection: 1] Executing query: [SELECT SUM(1) AS “COL”, 2 AS “COL2” FROM “HubSpot”.“Forms” GROUP BY 2 HAVING COUNT(1) > 0].
2017-06-12T10:24:58.359-04:00 3 [Connection: 1]
2017-06-12T10:24:58.359-04:00 1 [Connection: 1] Executed table schema query: Table: [GetOAuthAccessToken], Success: 5 results (0 ms).
2017-06-12T10:24:58.363-04:00 2 [Request] GET https://api.hubapi.com/contacts/v1/forms
2017-06-12T10:24:59.189-04:00 2 [Response] HTTP/1.1 403 Forbidden, 307 Bytes Transferred
2017-06-12T10:24:59.189-04:00 3 [Request]
[HTTP Headers]
HTTP Auth Scheme: 2
User:
Password:
GET /contacts/v1/forms HTTP/1.1
Host: api.hubapi.com
Authorization: Bearer CJGF6O_JKxICWwEYzMiZASDM2-YBKKThATIZAEL7khO2nC7NpcFi4lWEGWY_WPX2lappzg
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Connection: close


#4

@GuillermoV
Yes that is what I was asking for. Your call looks good from there. Can you do me a favor and take your current access token and then use this endpoint to get information from it?

What I want to find out is if the accessToken has permissions to grab forms data or not.

As you can see here in an Example response in the scopes is where all the parts of HubSpot are listed out. If you don’t see forms here then you just need to re-install the app and add the forms as a scope.


#5

Hi,

Here is the response. Is it supposed to call out forms specifically? or does it fall under something else?
Also does it really just need to be an updating of an app or is more authorization required. Thanks!

{
“token”: “COPGzMDKKxICWwEYzMiZASDM2-YBKKThATIZAEL7khPObZHmUa_i-XeA5wMD0WHgy6M5gw”,
“user”: "gvidaurre@uscommunities.org",
“hub_domain”: “uscommunities.org”,
“scopes”: [
“contacts”,
“content”,
“social”,
“automation”,
“timeline”,
“oauth”
],
“hub_id”: 2516044,
“app_id”: 28836,
“expires_in”: 16260,
“user_id”: 3780044,
“token_type”: “access”
}


#6

@GuillermoV Yes you will need a token that has the forms scope. You will have to go through the initial process again and get one and save the refresh token of the new access token with the added scope.


#7

Hi, I guess I am confused. I have been given admin rights. So I am not sure how I can get any more permissions? Another person at my company is facing the same issue. Thanks!


#8

@GuillermoV You can do some research into OAuth 2 and how scopes on a token work. You need to make sure you are requesting the right scopes or else that access token will never be able to get that level of information. Since a token can be shared across many people your own admin rights wouldn’t apply here.