Do you have a field or data value in the first table that has some kind of timestamp associated with the table load? If you just want to see that something ran/changed - you can add a date/time field to table (2) and when you make your edit record call, include the value of 'Now' into that date/time field to enforce that at least one data point is changing with each daily run.
Hi Chayce,
No I do not have a field in the first table (the one that works as expected) that has a date/timestamp in it. That's what is puzzling me.
Here are the results from this table: every record has exactly 5 fields and each has data.
<?xml version="1.0" ?>
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>77</rid>
<num_fields_changed>5</num_fields_changed>
<update_id>1699987690347</update_id>
</qdbapi>
Whereas, the second table has address fields, and not all fields have data and hence some may have 8 fields to update whereas another may have 4 fields to update. I am not pulling in blank fields.
Tried pulling in blank fields and that too did not work. :-(
