# API deals and Internal value

**URL:** <https://community.hubspot.com/t/api-deals-and-internal-value/17967>\
**Category:** APIs & Integrations\
**Tags:** object\
**Created:** [January 8, 2020, 9:38am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967 "2020-01-08T09:38:41Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 8, 2020, 9:38am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/1 "2020-01-08T09:38:41Z")

</div>

Hi,

I try to get internal value from a API call to hubspot by using qlick sense. My code is :

[https://api.hubapi.com/deals/v1/deal/paged?hapikey=XXXXXXXXX&includeAssociations=true&limit=250&properties=dealname&properties=amount&properties=pipeline&properties=dealstage&properties=createdate&properties=commercialisateur](https://api.hubapi.com/deals/v1/deal/paged?hapikey=XXXXXXXXX&includeAssociations=true&limit=250&properties=dealname&properties=amount&properties=pipeline&properties=dealstage&properties=createdate&properties=commercialisateur)

I get all the default value but not the internal value from the deal.

Somebody could help me to solve the problem ?

Thanks

---

<div class="post-metadata">

**Author:** ![jackcoldrick](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jackcoldrick/32/5119_2.png) [@jackcoldrick](https://community.hubspot.com/u/jackcoldrick)\
**Post date:** [January 8, 2020, 9:46am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/2 "2020-01-08T09:46:09Z")

</div>

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:

```auto
{
 "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

---

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 8, 2020, 10:42am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/3 "2020-01-08T10:42:37Z")

</div>

Hi Jack,

Thanks for your answer, below the answer I get with qlick sense when I use the get API :

 ![Api Hubspot _Qlicksense .PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/8/e87f5f19fea0cdc12077e303ab8acfc997171a2a.png)

The internal value I try to get is commercialisateur and it does not appear under properties.

Thanks a lot for your help

Best regards

---

<div class="post-metadata">

**Author:** ![jackcoldrick](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jackcoldrick/32/5119_2.png) [@jackcoldrick](https://community.hubspot.com/u/jackcoldrick)\
**Post date:** [January 8, 2020, 10:58am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/4 "2020-01-08T10:58:22Z")

</div>

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`

 ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/4/04e8918414e688bc3a2d5043606fc067b472e0ab.png)

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

---

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 8, 2020, 11:40am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/5 "2020-01-08T11:40:45Z")

</div>

I use the same sentence in the rest connection but I did not get the same result  
 ![16x16_smiley-embarrassed.png.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/d/d6c1e8475fd08e0d7bf70a71dcbccd5874ab78ea.png)

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

---

<div class="post-metadata">

**Author:** ![jackcoldrick](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jackcoldrick/32/5119_2.png) [@jackcoldrick](https://community.hubspot.com/u/jackcoldrick)\
**Post date:** [January 8, 2020, 1:11pm UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/6 "2020-01-08T13:11:38Z")

</div>

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}](https://api.hubapi.com/deals/v1/deal/paged?hapikey=%7B%7Bapikey%7D)}&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?

---

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 8, 2020, 2:14pm UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/7 "2020-01-08T14:14:17Z")

</div>

Hi Jack,

I create a new REST connection with the same parameter of yours, but I do not get the same result. It is so strange.

 ![Api Hubspot _Qlicksense .PNG](https://d2qpr2jzcazej7.cloudfront.net/original/2X/4/4be6b776134b34e4091b2ab66b8c2f4926b0178a.png)

 ![Api Hubspot _Qlicksense 1 .PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/c/3cbf6caccc9161f2fabd6a45e334db5b81e4c271.png)

Which data connection, and authentication you use ?

I am stuck with that problem still this morning and cannot get trought !

Thanks you for your help

Christian

---

<div class="post-metadata">

**Author:** ![jackcoldrick](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jackcoldrick/32/5119_2.png) [@jackcoldrick](https://community.hubspot.com/u/jackcoldrick)\
**Post date:** [January 8, 2020, 2:36pm UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/8 "2020-01-08T14:36:53Z")

</div>

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`

 ![1.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/f/bf3439674ceb6d683b8b085403922cb845bbd3e9.png)

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.

 ![2.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/c/ac42a0be4230f2e7c8ccd6c23f32c14b3c9215fc.png)

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

---

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 9, 2020, 8:25am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/9 "2020-01-09T08:25:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 13, 2020, 6:23am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/10 "2020-01-13T06:23:17Z")

</div>

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 :

 ![Contact_internal.JPG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/7/e7dd213c7ef17c58c11fdaef8b246620664e860f.jpeg)

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

---

<div class="post-metadata">

**Author:** ![jackcoldrick](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jackcoldrick/32/5119_2.png) [@jackcoldrick](https://community.hubspot.com/u/jackcoldrick)\
**Post date:** [January 13, 2020, 8:34am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/11 "2020-01-13T08:34:17Z")

</div>

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:

- [https://share.vidyard.com/watch/EVdv2fDHY9gXXHjNZWYGvj](https://share.vidyard.com/watch/EVdv2fDHY9gXXHjNZWYGvj)?

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

---

<div class="post-metadata">

**Author:** ![ctecher](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ctecher/32/35493_2.png) [@ctecher](https://community.hubspot.com/u/ctecher)\
**Post date:** [January 13, 2020, 10:34am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/12 "2020-01-13T10:34:50Z")

</div>

Hi Jack,

Thanks a lot, I fixed the problem.

I did not see commercialisateur in the tree because they where no value.

Best regards

---

<div class="post-metadata">

**Author:** ![jackcoldrick](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jackcoldrick/32/5119_2.png) [@jackcoldrick](https://community.hubspot.com/u/jackcoldrick)\
**Post date:** [January 13, 2020, 10:45am UTC](https://community.hubspot.com/t/api-deals-and-internal-value/17967/13 "2020-01-13T10:45:38Z")

</div>

@ctecher glad we got that working 🙂