Hi Zoho Foks,
Is there any way to tell the number of record updated when using the Python Report Client ?
In a perfect world I'd be able to do something like
result = rc.updateData(prodURI, updateInfo, updateCriteria, None);
have a dictionary return with something like {'RecordCount':0} or whatever the number of updated records actually is.
What I am trying to do, is figure out if my Update command, actually updated 0 records, in which case I actually need to insert the record.
However, since you cannot build a unique constraint in Zoho Reports, its possible to add duplicate records.
Similarly, since this is over HTTP, it is very slow to query first, then call either update or insert. (i.e. on average, you will will need 2.5 network calls if your work load 50% update and 50% adds)
vs 1.5 network calls, if I could tell when my Update command updated 0 records.
Please consider returning the number of updated records in the Report Client.
Thanks.
Tyler