menu
Channels
Team

Quickbooks

July 28, 2020 at 7:44pm
I working on an integration with Quickbooks and I don't seem to get all my data. I am trying a simple query with for a customer with their id and trying to get their invoices.
query customerWithInvoices {
quickbooks {
customerById(id: "400") {
id
displayName
active
invoices {
nodes {
id
}
}
}
}
}
I do receive the customer back but not their invoices. ( They do have invoices. )
{
"data": {
"quickbooks": {
"customerById": {
"id": "400",
"displayName": "Ryder Truck Rental",
"active": true,
"invoices": {
"nodes": []
}
}
}
}
}
If I just query for invoices I only receive 2 results.
query invoices {
quickbooks {
invoices {
nodes {
id
}
}
}
}
{
"data": {
"quickbooks": {
"invoices": {
"nodes": [
{
"id": "52411"
},
{
"id": "50326"
}
]
}
}
}
}
Thanks in advance for your help and insight!

July 28, 2020 at 9:01pm
The Quickbooks integration will try to download all data for the Quickbooks realm in order to provide a fully-featured GraphQL API. It can sometimes take a while for the initial sync, but it looks like we're hitting a bunch of rate limits that are causing the sync process to be extra slow for you.
It looks like we're making more API requests to Quickbooks then necessary--I'll sort that out and get back to you.
  • reply
  • like

July 29, 2020 at 6:59pm
I am able to query the data today! Going to try now to do a remote join now via Hasura with our CRM. Let me know if you need me test anything for you. Thanks!
  • reply
  • like