tyler-subscription-invoicelineitem

[frigid palm]

Hello! Do you have an example ID/request I can look at?

[spiral pawn]

Yes, here are 2 examples of subscription_item_ids corresponding to subscription_items that don't seem to exist (and the corresponding invoice_items I pulled them from):

invoice_item_id: il_1HGYuUBsYzIqHjobh0BbHKhl
subscription_item_id: si_HqFPZ1ie73iI2A

invoice_item_id: il_1JPARLBsYzIqHjobXLzQoirY
subscription_item_id: si_HqXZL0UJ5aQPEJ

Thanks!

[frigid palm]

Ah, are you trying to use the Invoice Items API to retrieve the "sli_xxx" IDs?

Or are you doing someting else? If you have the exact reqeuest that's giving "record does not exist" that would help a lot

[spiral pawn]

I'm doing something else. I dumped all of our historical data into our data warehouse, and noticed this discrepancy when manually querying the data.

My goal is to get to the subscrition_item from the invoice_item.

(also realized I pasted the wrong invoice_item_ids above -- just updated)

[frigid palm]

So this is a discrepency with your data, not with Stripe? Have you confirmed that you're even able to retrieve those Subscription Item IDs through the API? If you are, then it sounds like your historical data wasn't complete and that's why you're having issues

[tropic ore]

tyler-subscription-invoicelineitem

[spiral pawn]

Yes it is a discrepency with our data, but the data is pulled from stripe. I'm trying to understand why 95%+ of the subscription_item_ids associated with invoice_item_ids are valid, but a small percentage of the subscription_item_ids seem to point no where.

[tropic ore]

@spiral pawn It's likely that the Subscription got updated over time and created a new SubscriptionItem with a different si_123. And those aren't kept after "deletion"