intuit / QuickBooks-V3-DotNET-SDK

.Net SDK for QuickBooks REST API v3 services
Apache License 2.0
108 stars 140 forks source link

CDC returns entity with a wrong deleted status #189

Closed clement911 closed 3 years ago

clement911 commented 3 years ago

Calling CDC I get some entities back with a status of DELETED even though the entities were just updated!

Also, how do we get the maxResults and startPostion property, in case we need to know we have to paginate because the results contain more than 1,000 entities?

Also, how do we get the time property?

image

nimisha84 commented 3 years ago

Default maxreuslts for any query is 100 QueryService in1 = new QueryService(context); var inn2 = in1.ExecuteIdsQuery("Select * From Invoice").ToList(); You can do a .Count to get the maxresults for your original query as the SDK does not exposes this in response.

Queries like below have startposition and maxresults passed in the query and your code is already aware of the values. Invoice inn1 = in1.ExecuteIdsQuery("Select * From Invoice where Id='27' StartPosition 1 MaxResults 1").First();

For the time, you can use the current time for query run as a workaround.

For the CDC issue, please log the request and response and report this to support via developer.intuit.com->?(help)

clement911 commented 3 years ago

In light of the issues and limitations we've reported, we've decided to create a new open source .NET SDK for QBO.

Megaventory commented 3 years ago

@clement911 cool! Can you share here the repo url?

clement911 commented 3 years ago

@Megaventory sure I will let you know when we publish it on GitHub

nimisha84 commented 3 years ago

Thanks for the upcoming contribution to community @clement911

clement911 commented 3 years ago

@Megaventory we published our first nuget version of our QBO .Net SDK.

https://github.com/better-reports/QuickBooksSharp

Megaventory commented 3 years ago

@clement911 great!

nimisha84 commented 3 years ago

That is an awesome turnaround @clement911 . Thanks for your contribution.

clement911 commented 3 years ago

Thanks 😀 Feel free to list it in the docs as an unofficial .net sdk

nimisha84 commented 3 years ago

Fixed in 14.6.1 release