JSON - Getting all Deals - Data Inconsistencies


#1

Hi,

I was trying to setup a http get request to import data to a google spreasheet

=ImportJSON("https://api.hubapi.com/deals/v1/deal/paged?hapikey=&includeAssociations=true&limit=250&properties=dealname&properties=closed_won_reason&properties=pipeline&properties=cursos&properties=dealstage&properties=closedate&properties=createdate&properties=amount&properties=n_participantes&properties=number_profiles_send&properties=closed_lost_reason&properties=deal_source&properties=dealtype&properties=previous_stage&properties=location&properties=date_course_finished")

The data is imported successfully but there are several inconsistencies. The data for different deal properties doesn't match the data imported on the spreadsheet. For example, I have deal 1 whose property A is an empty value. When I bring the endpoint data, I find in my google spreadsheet that deal 1 has a value for property A.


#2

Hi @Daniela_Sarzosa,

Can you give me a specific example of a deal that has inconsistent data? Ideally, it'd be helpful to have:

  • A link to the deal in HubSpot
  • The information returned by the endpoint
  • The specific property/properties that don't align