JSON - Getting all Deals - Data Inconsistencies

[Daniela_Sarzosa]

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.

[Derek_Gervais]

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