@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”
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.
@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.
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!
@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.
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!
@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.