WebCOBRA.com Community Message Boards

dandrews
Posts: 20
Since: 01/07/2009

I'm using the web api (webservice) and I am trying to download just the payments for today. Those come through fine, but I use the QB_ID from the QB_Payments to verify that I have a record of the QB who made the payment.

However, in many cases if I try to download a missing QB by querying select .... from QB where ID = '[qb_id field from payment record]' I don't get a QB back! Why are these QBs not returning?

jwolgamott
Posts: 257
Since: 09/26/2005

@dandrews -- can you give an example of an ID that isn't coming over for you? It's non-personally identifier, so its safe to post here.

Also, you're in the 'BB' instance, right?

dandrews
Posts: 20
Since: 01/07/2009

Yes the admin code is bb.

Here is one example, copied from the sample program that allows you to run queries. I had to update the URL it was pointing to but it works.

=================================== ==============

select qb_id from qb_payment

.... results truncated ....
QB_ID='3xD0000089608', ID='5xD0000002279'

Complete. Enter Q to quit, else to restart
----------------------------------- --------------
WebCOBRA.com Sample WebAPI Query
-------------------------------------------------

Enter your Query or enter 'sample' for sample query
select firstname, lastname from qb where id = '3xD0000089608'
Request complete with 0 results

Complete. Enter Q to quit, else to restart

============================================

As you can see, I pulled the QB_ID result from the QB_Payment and tried to query for the name of the QB who made the payment, but I received 0 results from my QB query.

This query returns 0 results as well:

select firstname, lastname from qb where id like '%89608'

Please help! The result of the process I'm developing will be faster up-to-date payment reports for the company and less queries to webcobra.

jwolgamott
Posts: 257
Since: 09/26/2005

@dandrews -- this should work and you're doing everything correctly.

It's broken because we've been optimizing the WebAPI for the access data loader, and neglected to let you pull one QB. The QB in question is in page-5 of the downloaded results, but should be page 1 based on your query.

We'll get this worked out and post an update here within the next couple of days.

jwolgamott
Posts: 257
Since: 09/26/2005

@dandrews -- Please try this again, we posted an update this weekend that will allow you to use a Where clause effectively in the SQS and your programs.

dandrews
Posts: 20
Since: 01/07/2009

Thanks! I checked it earlier this morning actually now and I am able to query for a single QB.

However, after that update I ran into this issue as posted in another message.

http://devcenter.webcobra.com/conve rsations/118.aspx

I appreciate your help!