API_EditRecord with non-standard key

Question

I changed a Table's Record Key from Record ID# (fid_3) to Customer_ID (fid_206).&nbsp; &nbsp;When I use API_DoQuery to look at the records, it looks like the the Record Key is still fid 3.&nbsp; Am I interpreting this right?&lt;/chdbids&gt;&nbsp; &nbsp; &lt;record rid="510"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;-- Is this telling me the Record ID is still fid 3 ?&nbsp; &nbsp; &nbsp; &nbsp; &lt;fid="3"&gt;510&lt;/f&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;fid="2"&gt;1533741045089&lt;/f&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;fid="6"&gt;Test Account Name&lt;/f&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;fid="206"&gt;ADAM4914&lt;/f&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;update_id&gt;1533741045089&lt;/update_id&gt;&nbsp; &nbsp; &lt;/record&gt;&lt;/qdbapi&gt;

hhersch · Answer

Hi Jim. When you change the key, Quick Base does not delete or stop using the&nbsp;Record ID (RID).&nbsp;That field remains FID 3 and still increments with each record added. The only thing that changes is that Record ID is no longer the&nbsp;primary key on the table. Does that make sense?

jimlieder2 · Answer

OK, thanks for the clarification.&nbsp; So to edit a record using API_EditRecord when I've changed the primary key field, do I use key=&nbsp; instead of rid=&nbsp;&nbsp;Like this:&nbsp; a=API_EditRecord&amp;key=ADAM4914

hhersch · Answer

That is exactly correct. You can find more details in the documentation for API_EditRecord&nbsp;https://help.quickbase.com/api-guide/edit_record.html.

Forum Discussion

API_EditRecord with non-standard key

Related Content

Inconsistent results using this API_EditRecord

API_EditRecord Issue

Using API_DoQuery in API_EditRecord

Conditional API_EditRecord Statement

API_EditRecord to Duration field