# CRM Deals API returning empty date fields

**URL:** <https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574>\
**Category:** APIs & Integrations\
**Tags:** professional\
**Created:** [March 25, 2025, 8:13am UTC](https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574 "2025-03-25T08:13:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![LPeacock15](https://avatars.discourse-cdn.com/v4/letter/l/c6cbf5/32.png) [@LPeacock15](https://community.hubspot.com/u/LPeacock15)\
**Post date:** [March 25, 2025, 8:13am UTC](https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574/1 "2025-03-25T08:13:17Z")

</div>

Hi there,

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.

 ![Screenshot 2025-03-25 at 08.08.38.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/56235d2a00b1d525a2f768a898e0df02bad1161e.png)

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.

 ![LPeacock15_0-1742890239281.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/f/1f3eabd86973ca19db2519719b0dbe6cb2b6dcc2.png)

I am seeing the same issue across all Deals and Contacts.

I’ve checked the API release notes and can’t see anything relevant.

I’d be very grateful for any assistance on this.

---

<div class="post-metadata">

**Author:** ![KKosny](https://avatars.discourse-cdn.com/v4/letter/k/b2d939/32.png) [@KKosny](https://community.hubspot.com/u/KKosny)\
**Post date:** [March 25, 2025, 8:18am UTC](https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574/2 "2025-03-25T08:18:28Z")

</div>

Hi,

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.

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [March 26, 2025, 9:00pm UTC](https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574/3 "2025-03-26T21:00:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![LPeacock15](https://avatars.discourse-cdn.com/v4/letter/l/c6cbf5/32.png) [@LPeacock15](https://community.hubspot.com/u/LPeacock15)\
**Post date:** [March 27, 2025, 9:26am UTC](https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574/4 "2025-03-27T09:26:13Z")

</div>

Many thanks, [@Jaycee\_Lewis](https://community.hubspot.com/t5/user/viewprofilepage/user-id/127074) !  
I can provide more information and code if reqiured.

---

<div class="post-metadata">

**Author:** ![LPeacock15](https://avatars.discourse-cdn.com/v4/letter/l/c6cbf5/32.png) [@LPeacock15](https://community.hubspot.com/u/LPeacock15)\
**Post date:** [April 4, 2025, 9:35am UTC](https://community.hubspot.com/t/crm-deals-api-returning-empty-date-fields/128574/5 "2025-04-04T09:35:28Z")

</div>

Hi @KKosny [@Jaycee\_Lewis](https://community.hubspot.com/t5/user/viewprofilepage/user-id/127074) - 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

Details here: [https://community.hubspot.com/t5/Developer-Announcements/Upcoming-Sunset-of-Legacy-Stage-Calculated-Properties-for/m-p/1026312](https://community.hubspot.com/t5/Developer-Announcements/Upcoming-Sunset-of-Legacy-Stage-Calculated-Properties-for/m-p/1026312)
