Forum
authorization problems
I am using your website to query the api (https://docs.codat.io/reference/using-codats-api-1). The fact is that I use the apiKey that I have been using for 11 months and now it tells me that I am not authorized. However, from the app that I am developing I make queries with the same apiKey and I don't have any problem. I have created another apiKey and the same thing happens to me. Any idea of the possible cause?
Posted by Juan Araña Hormiga 2 days ago
authorization error
Estoy utilizando vuestra web para hacer consultas a la api (https://docs.codat.io/reference/using-codats-api-1). El hecho es que hago uso de la apiKey que llevo utilizando hace 11 meses y ahora me dice que no estoy autorizado. Sin embargo desde la app que estoy desarrollando hago consultas con la misma apiKey y no tengo ningún problema. He creado otra apiKey y me sucede lo mismo. ¿ Alguna idea de la posible causa ?
Posted by Juan Araña Hormiga 2 days ago
Direct costs endpoint in relation to each service provider
Hi
We are looking at Codat for pushing credit card and bank transactions from our business spending card to each provider's money spent transaction (can be an expense or direct purchases etc.)
I see you have a direct costs endpoint. What does that map to for each provider as we need it to evaluate the UX for our SMBs.
Posted by Kevin 16 days ago
How to check/set Expiration of Accounting Connections?
Hello, I am searching and wondering how long is the connection of accounting before it will expire? Can It be set? Or is there a standard like 100 days? Thank you.
Posted by Jam Payumo 24 days ago
When hitting a push endpoint how long should the associated push operation be in a "pending" state?
I was testing out the `/companies/{companyId}/connections/{connectionId}/push/billPayments` endpoint yesterday and noticed that the push operation associated with the request is still in a pending state today.
What is the schedule like for executing the push operations or how long should a push operation typically be in a "pending" state?
Posted by Mitchell Newell 28 days ago
what is the difference between Bills and BillPayments
Bills are available from the /companies/{companyId}/data/bills endpoint
BillPayments are available from /companies/{companyId}/data/billPayments
I understand the differenced in the data, but what are the conceptual differenced between a bill and a billPayment?
TIA
Posted by John Howard about 1 month ago
How to create an Invoice with shipping amount line item?
When requesting an Invoice with a shipping cost line item from codat a line item with an `itemRef.id = "SHIPPING_ITEM_ID"` is returned from QBO, which is correct.
However, when attempting to create an invoice via API with an itemRef.id = "SHIPPING_ITEM_ID", Codat seems to not handle this scenario as I get an error back: "Failed to push to Invoice as ItemRef SHIPPING_ITEM_ID is not found."
How does one create an Invoice with a shipping cost line item via Codat's API?
Posted by Collin about 1 month ago
Accounting Transactions 409
I'm calling:
`/companies/{companyId}/connections/{connectionId}/data/accountTransactions`
and getting a response of:
{
"statusCode": 409,
"service": "PublicApi",
"error": "Datatype 'accountTransactions' has not yet been requested or is not yet complete",
"correlationId": "5bbca8aa7fd86d7da72e48de825a8270",
"canBeRetried": "Unknown",
"detailedErrorCode": 0
}
I thought this meant the `datatype` status was not complete, but when I call `/companies/{companyId}/dataStatus` all `currentStatus` values in the response array are `Complete`.
I did note that there was no response for `accountTransactions` so I'm probably not understanding something!!
Thanks again for your help today ;0)
Posted by John about 1 month ago
Value of ConnectionId
Hi,
I am using the Demo Company and have set up an Accounting Connection using the sandbox data (rather than quickbooks etc).
Next, I want to call https://api.codat.io/data/companies/{companyId}/connections/{connectionId}/assess/accounts/categories
I can find the value of `{companyId}` in https://app.codat.io/companies but am struggling to find the value of `{connectionId}`. Where can I get this id please?
Posted by John Howard about 1 month ago
List of transactionCategoryRef values
Hi,
I'm looking to map transactions based on category at the lowest level possible.
I know we can call https://api.codat.io/data/assess/accounts/categories and this delivers and this delivers a list of 5 Types, 6 Subtypes, and 131 Detail Type values.
What I don't know is:
- In which endpoints are these values available
- what the data coverage might be.
I thought the transactionCategoryRef value might help but the sample data returns a value of
"transactionCategoryRef": {
"id": "health-and-fitness-sports"
},
which does not cross reference to any of the values in the accounts/categories endpoint.
I'm not sure at this point if we will be using the Accounting API, the Banking API or a combination of the two (if available) so don't worry too much about cross API issues.
TIA
Posted by John Howard about 2 months ago