I have a daily script running to collect data on Deal objects. This has been working fine for months. Recently (since, I think, the 20th March) the API is returning empty date fields for the Deal Stages.
For example, here is a test Deal created yesterday.
And here is the returned Json. It shows the correct created date and last updated date. But there is no value for the ‘hs_date_entered_appointmentscheduled’ property, which corresponds to the New In deal stage.
I created a script that extracts deals data through private apps and I loaded into PowerBi. In the deals schema I found fields caled “hs_date_entered_StageID” which date stamped each deal that entered said stage.
It fetched the data correctly until Saturday/Sunday when I refreshed the report and the columns disappeared then when I tried to go back, all values returned blank.
I’m using the V3 HubSpot API and I want to see when each deal entered a stage so then I can aggregate it and filter by the said date in my PowerBI report.
Any advice or solution is welcome. Thank you.
Hey, @LPeacock15 I am going to take this and the other related post and do a test on my end. I’ll follow up here after reporting this to my internal resources — Jaycee
Hi @KKosny@Jaycee_Lewis - turns out these properties have been deprecated (announced last summer, taking effect only recently), so you will need to replace hs_date_entered_stage with hs_v2_date_entered_stage
I am going to take this and the other related post and do a test on my end. I’ll follow up here after reporting this to my internal resources — Jaycee