Hi,
I try to get internal value from a API call to hubspot by using qlick sense. My code is :
I get all the default value but not the internal value from the deal.
Somebody could help me to solve the problem ?
Thanks
Hi @ctecher,
Your request looks fine to me. Would you mind sharing the response that you are getting back? The response should contain a json object containing a deals array. Inside of this array there is another object called “properties” which caontains the requested properties along with their current value. See below:
{
"deals": [
{
"portalId": 2990812,
"dealId": 277912418,
"isDeleted": false,
"associations": {
"associatedVids": [],
"associatedCompanyIds": [],
"associatedDealIds": [],
"associatedTicketIds": []
},
"properties": {
"pipeline": {
"value": "default", <--- VALUE STORED HERE
"timestamp": 1523272662730,
"source": "WORKFLOWS",
"sourceId": "2804150",
"versions": [
{
"name": "pipeline",
"value": "default",
"timestamp": 1523272662730,
"sourceId": "2804150",
"source": "WORKFLOWS",
"sourceVid": []
}
]
}
Regards,
Jack
Hi @ctecher,
I am not familiar with qclick sense but I setup a free trial to test this for you and I’m not having any problem. See below using the following request:
https://api.hubapi.com/deals/v1/deal/paged?hapikey={{apikey}}&includeAssociations=true&limit=250&properties=dealname&properties=amount&properties=pipeline&properties=dealstage&properties=createdate&properties=commercialisateur
Is there any way you can get some additional support from qlick sense on this as it might be a configuration on their side?
Regards,
Jack
I use the same sentence in the rest connection but I did not get the same result
Could give me the parameter you use in the rest connector in Qlick sense ?
I try to get some help from Qlick sense community but there is not a lot of people who use Hubspot.
Thanks a lot
Hi @ctecher,
No problem at all here are the steps I’ve followed in Qlick Sense:
1) Create an application and provide it a name.
2) Click to “Add data from files and other sources”
3) Choose the “REST” option from the list of data sources
4) In the dialog box that appears I’ve entered the following:
- URL: https://api.hubapi.com/deals/v1/deal/paged?hapikey={{apikey}}&includeAssociations=true&limit=250&properties=dealname&properties=amount&properties=pipeline&properties=dealstage&properties=createdate&properties=commercialisateur
- Method: GET
- Name: Get recently created deals
In my case {{apikey}} was replaced with my portals api key. Once done I click “Create” and it generates all of the data I need in the screenshot I showed originally.
Does that help at all?
Hi @ctecher,
I wonder if there is an issue with your API key and how you are including it in the request. I’ve run another test and it’s working fine. Can you please try this…
Copy and paste the URL below into the “URL” field.
https://api.hubapi.com/deals/v1/deal/paged?includeAssociations=true&limit=250&properties=dealname&properties=amount&properties=pipeline&properties=dealstage&properties=createdate&properties=commercialisateur
Also make sure to go to the “Additional request parameters” section and ensure it looks like the below. Of course replace “xxxx” with your HubSpot API key. Instructions on where to find that can be found here.
Once you’ve done all of this it should pull in the data correctly. It’s difficult to fully support you on this as QlickSense isn’t a HubSpot tool and the issue isn’t residing with the HubSpot API. However if you try the above I’m hopeful it will help.
Regards,
Jack
Hi Jack,
Thanks for your answer.
My version of qlick sense is June 2018, I will upgrade it to november 2019 and try again.
I will let you know if the problem is solved.
Regards
Hi Jack,
I have installed the new version of Qlick Sense and I still have the same problem.
I have made with the paramters you gived me but the problem is still there.
Something is strange, because when I try to get the internal value with the contact and the qlick Rest Connectors, I get it. See below :
avancement_du_dossier is an internal value.
So I wonder why it is working with Contact and not with deals, with the same connector.
Do I have another way to get those internal deals parameters from Hubspot ?
Thanks a lot for your reply
Best Regards
Hi @ctecher,
I’ve recorded a video of me using QlikSense and extracting deal information from HubSpot using the HTTP REST CONNECTOR option. You can view it below:
Again, it’s really difficult for me to troubleshoot this any further as this is a third party tool. Hopefully the video helps clear up any confusion.
Regards,
Jack
Hi Jack,
Thanks a lot, I fixed the problem.
I did not see commercialisateur in the tree because they where no value.
Best regards
@ctecher glad we got that working 