#premnath_jackhealth_82923
glossy mangoBOT
Hello! We'll be with you shortly. Below are links to other discussions we've had with you in the past week in case you want to review that information. If your question is related to one of these previous discussions, please provide a comprehensive summary of the current state and what you need help with now. We help many users simultaneously, so a summary allows us to resolve your issue as soon as possible.
- premnath_jackhealth_82923, 38 minutes ago, 2 messages
vital bronze
Hi 👋
THere is not much in that previous thread. Can you share what your current question is?
plain apex
Hello Team - I have identified two issues with Stripe API and was asked to reach this channel by Solina Powell.
Issue 1: The issue is metadata info for each invoice is available in stripe , however Fivetran was returning empty . I raised a ticket to Fivetran already and they mentioned that the API of Stripe is returning empty for the identified invoices. This problem persists only for the Invoice item , where as subscription items are working as expected.Example Invoice :in_1NWyhiAlpXsTWXdH4rGomOcp
in_1N8QYyAlpXsTWXdHOlG3Folw
in_1KfoFwAlpXsTWXdHVcZTUuUp
End point used :https://stripe.com/docs/api/invoices/invoice_lines (edited)
Issue 2 : for this invoice as per Stripe the metadata associated is : "bigcommerce_order_id 155964 resourceId orders/155964". queried the invoice_line_item object of Stripe API to check the metadata value received from the Stripe for invoice_id - in_1OTclMAlpXsTWXdH3x8csh8S.
query used : curl -X GET -H 'Accept: application/json' -H 'Authorization: Bearer <redacted>' -H 'Stripe-Version: 2019-02-19' -A 'Jersey/2.39' 'https://api.stripe.com/v1/invoices/in_1OTclMAlpXsTWXdH3x8csh8S/lines'
RESULT : the metadata field received from the Stripe source is "bigcommerce_order_id"":""147669"",""resourceId"":""orders/147669"
vital bronze
For Issue 1, I can only speak to the Stripe side of things. I have no insight into what Fivetran is doing
What exactly is it you are expecting to come through? What property on what object?
plain apex
can you hit the API for this in_1NWyhiAlpXsTWXdH4rGomOcp and the metadtafield will return empty
whereas in front end I am seeing this :
you can also try this : in_1KfoFwAlpXsTWXdHVcZTUuUp
vital bronze
The metadata for this Invoice object?
vital bronze
I see both a bigcommerce_order_id and a resourceId
plain apex
in API ?
which API endpoint are you using : End point used :https://stripe.com/docs/api/invoices/invoice_lines? this one ?
vital bronze
I can't query the API on your behalf. THat object belongs to you
But I can look at the object as it is returned and I can see the metadata
plain apex
thats the problem .. in front end we can see .. API is not returning that metadata
vital bronze
Can you share the request ID for the request where you are retrieving the Invoice?
Here's how you can find a request ID: https://support.stripe.com/questions/finding-the-id-for-an-api-request
plain apex
give me 5 mins
We are using Fivetran to get this info and we dont have request id provided to us
can you try using any pne of the API key you have and try to hit this endpoint : :https://stripe.com/docs/api/invoices/invoice_lines
vital bronze
I cannot make a request to an API on your behalf. That is not something I can do
plain apex
but you can try to replicate the data at your end and try extracting using an API right ?
vital bronze
Okay I created both an Invoice and an Invoice Item with metadata and the API returned both
glossy mangoBOT
plain apex
what this item classifed ? subscription or non -subscription item ?
the reason is the invoive that we does not return metadata happens only to non-subscription items
magic sinew
Hi, stepping in and catching up.