albaro-reports | Stripe Developers | Page 1

grave finch Aug 26, 2022, 4:46 AM

#

Hi

worldly sparrow Aug 26, 2022, 4:46 AM

#

I am back again!

grave finch Aug 26, 2022, 4:47 AM

#

From last time I think we figured it out the URL, right? and you were able to pull the file

worldly sparrow Aug 26, 2022, 4:48 AM

#

I was able to get the object

#

but for some reason the only way to get the data is looking at it in text form

#

I want to query the data but it only comes in text form and the csv file I am not being able to find in the object

#

I looked through all the things that come back with the object and could not figure out

grave finch Aug 26, 2022, 4:51 AM

#

When you retrieve the CSV with a curl, did you actually have a file?

worldly sparrow Aug 26, 2022, 4:53 AM

#

I do not

#

I only get what looks like a bunch of strings

grave finch Aug 26, 2022, 4:57 AM

#

Can you share the latest attempt? code and response if it's Test data

worldly sparrow Aug 26, 2022, 4:57 AM

#

It is not test data

#

It stats with b" then everything following is a string

next eagle Aug 26, 2022, 5:02 AM

#

Hi @worldly sparrow I'm taking over this thread

worldly sparrow Aug 26, 2022, 5:02 AM

#

Hi!

next eagle Aug 26, 2022, 5:06 AM

#

Hi! Can you share the request ID (req_xxx)? Here's how you can find it: https://support.stripe.com/questions/finding-the-id-for-an-api-request

Finding the ID for an API Request : Stripe: Help & Support

Find help and support for Stripe. Our support center provides answers on all types of situations, including account information, charges and refunds, and subscriptions information. Get your questions answered and find international support for Stripe.

worldly sparrow Aug 26, 2022, 5:07 AM

#

is it fine if it is for a live report?

next eagle Aug 26, 2022, 5:08 AM

#

Yes, only Stripe engineer can have access to see the request and response data. If you are not comfortable, you can also DM me the request ID.

worldly sparrow Aug 26, 2022, 5:10 AM

#

I just dmed it to you!

#

actually I think the last one was the most relevant one

next eagle Aug 26, 2022, 5:20 AM

#

Thanks, let me take a look

worldly sparrow Aug 26, 2022, 5:21 AM

#

Thank you

#

If I can access the data as a csv or text file I can make things work. I am only being able to access it as a bunch of strings

next eagle Aug 26, 2022, 5:23 AM

#

This API will return you a file object. If you need to access the file content, you need to download file through url (https://stripe.com/docs/api/files/object?lang=curl#file_object-url) and open a file stream in your application and read the data.

Stripe API reference – The file object – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

worldly sparrow Aug 26, 2022, 5:26 AM

#

I am not following

#

I turned the curl call into a request call in Python

#

and was able to get the data back

#

but the object with the data only allows me to access it in as a bunch of strings. So not as a data block that I can query

next eagle Aug 26, 2022, 5:33 AM

#

Can you share me the data the you receive from the response?

#

And you should Stripe Python library instead of making a curl call in your Python code.

worldly sparrow Aug 26, 2022, 5:40 AM

#

How would you like for me to share the data?

#

I looked through the docs and could not fine a clear example so I ended up turning the curl call into a python call and using request

next eagle Aug 26, 2022, 5:42 AM

#

You can DM to me

#

https://stripe.com/docs/api/files/retrieve?lang=curl#retrieve_file here's the example code to retrieve a file through Stripe Python SDK,

Stripe API reference – Retrieve a file – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

#

I see you have successfully the the file object response, what do you mean by you cannot access anything?

worldly sparrow Aug 26, 2022, 5:47 AM

#

I just dmed you

next eagle Aug 26, 2022, 5:49 AM

#

Show me the code

worldly sparrow Aug 26, 2022, 5:52 AM

#

Just dmed you

next eagle Aug 26, 2022, 5:59 AM

#

You should post the code in this chat so my colleague can easily follow up when I'm not around

worldly sparrow Aug 26, 2022, 6:03 AM

#

I can share again if they need it, I just did not want to post here in case I accidentally have something that could be compromising

next eagle Aug 26, 2022, 6:08 AM

#

Anyway, you are able to access the file download url through results.url . So you should write some Python code to download this file and read its content.

#albaro-reports