topic Re: I can't see one of Email Opt-out field in the Get Contact API in APIs & Integrations

I can't see one of Email Opt-out field in the Get Contact API

Benchmark_achen — Fri, 29 May 2020 18:39:14 GMT

Hi,

I'm trying to retrieve some of the Email Opted-Out fields from Hubspot into our database using the following API:

When run this API, I can see all the fields in the list return with the exception hs_email_optout_8324033.

Can someone let us know what should I do to make this field return as well?

Thanks,

Allan

Re: I can't see one of Email Opt-out field in the Get Contact API

WendyGoh — Mon, 01 Jun 2020 05:59:56 GMT

Hey @Benchmark_achen,

Taking a look at request URL, I noticed that there's a double `&&` in the request url parameter:

&property=hs_email_optout_6236646&&count=100

if we remove one of the &, like this:

https://api.hubapi.com/contacts/v1/lists/all/contacts/all?property=bnid_&property=email&property=hs_content_membership_status&property=hs_email_optout_8324033&property=hs_email_optout&property=hs_email_optout_6236625&property=hs_email_optout_7778519&property=hs_email_optout_6236646&count=100&vidOffset=0 --> this should return property hs_email_optout_8324033.

Could you try and see if this works?

Re: I can't see one of Email Opt-out field in the Get Contact API

Benchmark_achen — Mon, 01 Jun 2020 13:13:07 GMT

Nope, that field still doesn't show up. Here is the updated URL:

https://api.hubapi.com/contacts/v1/lists/all/contacts/all?property=bnid_&property=email&property=hs_content_membership_status&property=hs_email_optout&property=hs_email_optout_6236624&property=hs_email_optout_6236625&property=hs_email_optout_6236646&property=hs_email_optout_6821195&property=hs_email_optout_6974071&property=hs_email_optout_7116314&property=hs_email_optout_7778519&property=hs_email_optout_8324033&count=100&vidOffset=0

Here is the output (I'm using the ZappySys JSON Source SSIS components to run this URL):

Re: I can't see one of Email Opt-out field in the Get Contact API

WendyGoh — Wed, 03 Jun 2020 01:14:20 GMT

Hey @Benchmark_achen,

This is interesting. I'm also seeing the same behavior.

In this case, I'll have to work together with our internal team on this and I'll keep you posted here!

Re: I can't see one of Email Opt-out field in the Get Contact API

WendyGoh — Wed, 03 Jun 2020 09:06:08 GMT

Hey @Benchmark_achen,

Upon digging further into this, I believe I would be able to shed some lights here.

The reason why you're not seeing property hs_email_optout_8324033 is likely because on the first page of the return result (first 100 contacts that you retrieved), there's no contact with this property set (not even set with a "" value).

As such, the property isn't showing up.

If you'd like to return property even if it's null, you may want to explore the option of using CRM API | Contacts:

GET crm/v3/objects/contacts?limit=10&properties=hs_email_optout_8324033%2Cbnid_%2Cemail%2Chs_content_membership_status%2Chs_email_optout%2Chs_email_optout_6236625%2Chs_email_optout_7778519%2Chs_email_optout_6236646&archived=false&hapikey=yourHapikey

This should return all properties stated on the query parameter for each contact records even if the property is null.

Let me know if this works for you 🙂

Re: I can't see one of Email Opt-out field in the Get Contact API

Benchmark_achen — Wed, 03 Jun 2020 14:00:38 GMT

Thank you @WendyGoh !

Yes, you were right. The count was too low to get any data out of field hs_email_optout_8324033. I expanded the count to 10000 and this field finally shows up.

Thanks again!

--Allan