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

3 Replies

Related Content

Inconsistent results using this API_EditRecord

API_EditRecord Issue

API_EditRecord to Duration field

Conditional API_EditRecord Statement

API_EditRecord is not working

Recent Discussions

'Is Set' in Pipelines

Share your feedback on the new Qrew Discussions

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Forms help

Empower Next Week!