Skip to main content
Solved

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

  • September 14, 2023
  • 4 replies
  • 221 views

yeiser-mirabal
Forum|alt.badge.img

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!

Best answer by Lais Laudari

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


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

 

View original
Did this topic help you find an answer to your question?

4 replies

lucas-lacerda-pipefy
Pipefy Staff
Forum|alt.badge.img

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. 


Lais Laudari

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


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

 


marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • September 15, 2023

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


genietim
Forum|alt.badge.img+12
  • Pipefy Legend
  • 412 replies
  • September 16, 2023

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings