Discussions

Expand all | Collapse all

API_EditRecord with non-standard key

  • 1.  API_EditRecord with non-standard key

    Posted 08-08-2018 15:25
    I changed a Table's Record Key from Record ID# (fid_3) to Customer_ID (fid_206).   When I use API_DoQuery to look at the records, it looks like the the Record Key is still fid 3.  Am I interpreting this right?

    </chdbids>
        <record rid="510">          <-- Is this telling me the Record ID is still fid 3 ?
            <fid="3">510</f>
            <fid="2">1533741045089</f>
            <fid="6">Test Account Name</f>
            <fid="206">ADAM4914</f>
            <update_id>1533741045089</update_id>
        </record>
    </qdbapi>
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1745171/RackMultipart20180808-30243-mtdqfz-Screenshot_inline.jpg?1533741855">



  • 2.  RE: API_EditRecord with non-standard key

    Posted 08-08-2018 16:54
    Hi Jim. When you change the key, Quick Base does not delete or stop using the Record ID (RID). 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 primary key on the table. Does that make sense?


  • 3.  RE: API_EditRecord with non-standard key

    Posted 08-08-2018 17:00
    OK, thanks for the clarification.  So to edit a record using API_EditRecord when I've changed the primary key field, do I use key=  instead of rid=  

    Like this:  a=API_EditRecord&key=ADAM4914



  • 4.  RE: API_EditRecord with non-standard key

    Posted 08-08-2018 17:55
    That is exactly correct. You can find more details in the documentation for API_EditRecord https://help.quickbase.com/api-guide/edit_record.html.