Skip to main content
Solved

Number of Columns via API


Lucas Democh
Forum|alt.badge.img+15

 

Is there any limitation on returning columns via the API?

I didn't find anything about it in the API documentation, but when querying a table with many columns (+100), some columns are not appearing in the query.

https://api-docs.pipefy.com/reference/queries/table_records/#table_records

Best answer by Jean Silva

Hello @Lucas Democh,

As far as I've been able to confirm, there is no such limitation on our API's responses, I also tried, but I couldn't replicate a scenario where the API response limited the response, without it being a pagination matter.

Could you please contact our support and take your scenario and the API response to one of our analysts so that we can conduct a more detailed investigation into your problem?

Thank you in advance!

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

5 replies

graziela.sabatini
Pipefy Staff

Hey Lucas!

Because of the pagination, the command will only show the first 50. 
{
  table_records(table_id: "shhs" first: 50, after:"end-cursor"){
    pageInfo{
      endCursor
      hasNextPage
    }
  }
}

This is why the command with more than 100 is not returning all the values for you


Lucas Democh
Forum|alt.badge.img+15
  • Author
  • Pipefy Legend
  • 396 replies
  • December 7, 2023

Hey @graziela.sabatini

The problem is with columns, not rows.

My code already has pagination.


Leandro Almeida
Pipefy Staff
Forum|alt.badge.img+7

Hello @Lucas Democh, how are you? 

 

We've forwarded your question to the technical team who will gather more information to help you, ok? 

Thanks for waiting 

Sincerely


Jean Silva
Pipefy Staff
  • Pipefy Staff
  • 6 replies
  • Answer
  • March 8, 2024

Hello @Lucas Democh,

As far as I've been able to confirm, there is no such limitation on our API's responses, I also tried, but I couldn't replicate a scenario where the API response limited the response, without it being a pagination matter.

Could you please contact our support and take your scenario and the API response to one of our analysts so that we can conduct a more detailed investigation into your problem?

Thank you in advance!


Lucas Democh
Forum|alt.badge.img+15
  • Author
  • Pipefy Legend
  • 396 replies
  • March 8, 2024

Ok @Jean Silva , I'm going to open the case in support to assess what is happening.

Thanks for help!

 


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