quickbase- php do_query api does not retrieve values greater than 50 field id.Is there any limitations for number of fid?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
quickbase- php do_query api does not retrieve values greater than 50 field id.Is there any limitations for number values from a record
Photo of Hashmi V J

Hashmi V J

  • 160 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
When i tried the Api_DoQuery in a table with more  than  50 fields i am getting the entire fields. 

https://[target_domain]/db/[tableId]?a=API_DoQuery&qid=[reportId]&appToken=[appToken]

target_domain : aaa.com
tableId : Go to the corresponding table  that you want to fetch , on The URI the value after db
reportId: Go to any reports that have all the fields in your case , you will see a qid=some value in URI copy that value
appToken: In Application  Go to home -> settings -> app properties -> under Advanced Settings -> Security options -> require application token check it -> go to manage application token and create a  new token

Please remove the square brackets 

After making the URI proper with values just paste that URI in a tab. You will get the response as XML and you can see all the fields 

I Tried it. It's working fine for me

I hope this helps for you.