Solved

Querying Cards from the Last Year Sorted by Update Date via API

  • 14 September 2023
  • 4 replies
  • 92 views

Userlevel 2
Badge

Hey there!, I am reaching out to inquire about fetching data using the Pipefy API. Specifically, I'd like to retrieve all cards from the last year and have them sorted by their update date.

Is there a specific GraphQL query that would allow me to accomplish this? I'm looking for a way to obtain this dataset for analysis and reporting purposes.

Any guidance or example queries you could provide would be greatly appreciated!

icon

Best answer by Lais Laudari 15 September 2023, 14:45

View original

4 replies

Userlevel 5
Badge

Hi @yeiser-mirabal, how are you? 

 

Would you like to get a report off all cards in your pipe? We can get this for you if you open a new chat, but for now, i suggest you to take a look at https://developers.pipefy.com/! There you can find more information and querys to use in our API. 

Userlevel 7

Hi @yeiser-mirabal!
I believe this topic can help you: 


These are the fields that can be used to filter the allCards query:
 

 

Userlevel 7
Badge +18

Contributing the following suggestion


New GraphQL feature: Query/filter cards by updated_at

https://developers.pipefy.com/changelog/new-graphql-feature-query-cards-by-updated_at

Userlevel 7
Badge +12

Apart from @Lais Laudari absolutely correct answer, an alternative approach would be to create a report in the pipes you want the export of, and use the `exportPipeReport` mutation and the `pipeReportExport` query to download the reports.

Reply