# I want to download a summary report but don't know what to do

**URL:** <https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018>\
**Category:** Questions\
**Created:** [July 16, 2023, 8:34pm UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018 "2023-07-16T20:34:37Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jwatson](https://avatars.discourse-cdn.com/v4/letter/j/e47c2d/32.png) [@jwatson](https://developer.squareup.com/forums/u/jwatson)\
**Post date:** [July 16, 2023, 8:34pm UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/1 "2023-07-16T20:34:37Z")

</div>

I’m trying to download a file on square up called sales report. You have to click a button to download the file. I want to be able to do this from terminal so I can include it into a python script.

It uses a form to then download the data. I have looked into their api and its not helpful in this aspect.

I believe it is sending a request to a server but how do i replicate this?

Thanks in Advance

Here is the html:

Export

---

<div class="post-metadata">

**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\
**Post date:** [July 17, 2023, 7:42am UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/2 "2023-07-17T07:42:15Z")

</div>

At this time a Reporting API for generating the reports you see on the Square Dashboard aren’t currently available. The only way to generate the reports with our API at this time is to pull in all the data with our APIs and do your own calculations. We’re constantly working to improve our features based on feedback like this, so I’ll be sure to share your request to the API product team. 🙂

---

<div class="post-metadata">

**Author:** ![jwatson](https://avatars.discourse-cdn.com/v4/letter/j/e47c2d/32.png) [@jwatson](https://developer.squareup.com/forums/u/jwatson)\
**Post date:** [July 17, 2023, 2:13pm UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/3 "2023-07-17T14:13:17Z")

</div>

I haven’t been able to figure out how to extract exact item data out of the API… Is this possible?

---

<div class="post-metadata">

**Author:** ![Bryan-Square](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/bryan-square/32/38_2.png) [@Bryan-Square](https://developer.squareup.com/forums/u/Bryan-Square)\
**Post date:** [July 17, 2023, 2:22pm UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/4 "2023-07-17T14:22:57Z")

</div>

Yes, with the [Orders API](https://developer.squareup.com/reference/square/orders-api) you’ll get the itemized order. You’ll then take the `catalog_object_id` from the order and call the [Catalog API](https://developer.squareup.com/reference/square/catalog-api) to get the item data that you’ll use to create itemized reports. 🙂

---

<div class="post-metadata">

**Author:** ![jwatson](https://avatars.discourse-cdn.com/v4/letter/j/e47c2d/32.png) [@jwatson](https://developer.squareup.com/forums/u/jwatson)\
**Post date:** [July 17, 2023, 4:24pm UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/5 "2023-07-17T16:24:52Z")

</div>

Does this work for till orders as well?

---

<div class="post-metadata">

**Author:** ![josh-square](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@josh-square](https://developer.squareup.com/forums/u/josh-square)\
**Post date:** [July 17, 2023, 10:49pm UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/6 "2023-07-17T22:49:27Z")

</div>

Yes, orders placed through Square Point of Sale will also be itemized and accessible via the Orders API in the same way.

---

<div class="post-metadata">

**Author:** ![jwatson](https://avatars.discourse-cdn.com/v4/letter/j/e47c2d/32.png) [@jwatson](https://developer.squareup.com/forums/u/jwatson)\
**Post date:** [July 18, 2023, 6:24am UTC](https://developer.squareup.com/forums/t/i-want-to-download-a-summary-report-but-dont-know-what-to-do/10018/7 "2023-07-18T06:24:17Z")

</div>

Okay thank you very much for your help
