Hi All,
Trying to run a piece of custom code that pushes ARR to the deal when a Line item is active. Way I do it is Billing Start Date add the term which then creates an End Date and then check todays date is in between those two.
However, I can’t seem to find any Billing start date internal names for line items. I even ran a ‘Run Discovery Query’ to log all available line item properties with their internal name and label, and it didn’t show up in there.
Does anybody know this or if its even possible to get the Billing Start Date’s internal name?
Context: Im not a coder or developer a lot of this is being done for me via ChatGPT, so I might not understand much terminology hahah
The easiest way is to pull the Line Item schema and see which field you want to use that has the data (if any). I pulled my Line Item schema and I see the following fields default fields with the word “start”:
hs_billing_period_start_date
hs_recurring_billing_start_date
If you can’t pull the Line Item schema, you might try using the GraphQL Explorer under CRM Development which is a friendly way to find fields, I feel. You can query directly against specific Line Items so you can see whether or not the data is populated which I find helpful.
Hi @DCrinnion1 totally get the confusion.
HubSpot actually uses the line item property hs_recurring_billing_start_date for “Billing start date,” and there is also hs_recurring_billing_end_date if an end is defined. You can confirm both on the Line Items object reference where HubSpot lists default properties with their internal names (Accounts Dashboard | HubSpot )
In the UI, you can also surface the exact internal name to be safe. Go to Settings, Properties, select the Line item object, open “Billing start date,” and click the little code icon to see the internal name. HubSpot notes that internal names are what you should use in integrations and they don’t change after creation
(Create and edit properties )
One quick check for your custom code logic: are these items truly set to Recurring and not One-time? If it is One-time or “At payment,” hs_recurring_billing_start_date will return null, so guard for that and for missing end dates.
Hope this helps. If consistency with your billing system is the blocker, Stacksync keeps both sides aligned in near real time so you don’t chase fixes later.