Quickbase delete_record

Question

I am unable to get delete_record function to work. Here is the delete_record code that I am currently using:

$qb->db_id = $myQbTables["table1"]; //using table 1 now

$queries = array( //this is the where clause now for the delete query
  array(
    'fid'  => '12',
    'ev'   => 'EX',
    'cri'  => '1175'
  ),
  array(
    'fid'  => '8',
    'ev'   => 'EX',
    'cri'  => $Child_ID
  )
);

$results = $qb->do_query($queries, '', '', 'a', '1', 'structured', 'sortorder-A'); //get all results
if($results->errCode !== 0) {
  echo $results->errTxt;
}

print_r($results);

foreach($results->table->records->record as $record){ //getting results of delete query
$Deletevar = $record->f[11];    

$deleted = $qb->delete_record($Deletevar); //deleting results

print_r($deleted);  
}

I know that the 'cri' matches things in my quickbase but I can't seem to use f[3] (the record id) to delete it!

NOTE

I have found the main issue I was having! If you are making API calls using the QB API, delete records and purge records does not include the app token!! Please use the following code to update the delete_records function!!!!

public function delete_record($rid) {
if($this->xml) {
                        $xml_packet = new SimpleXMLElement('<qdbapi></qdbapi>');
                        $xml_packet->addChild('rid',$rid);
                        $xml_packet->addChild('ticket',$this->ticket);
                        $xml_packet->addChild('apptoken',$this->app_token);
                        $xml_packet = $xml_packet->asXML();                        

                        $response = $this->transmit($xml_packet, 'API_DeleteRecord');
                }
                else {
                      $url_string = $this->qb_ssl . $this->db_id. "?act=API_DeleteRecord&ticket=". $this->ticket
                                        ."&apptoken=".$this->app_token."&rid=".$rid;

                        $response = $this->transmit($url_string);
                }

return $response;          
}

score 1 · Accepted Answer · answered Sep 15 '15 at 00:23

I think you may be missing something in your query. If you're trying to get a list of records where the field 12 is 1157 and field 8 is equal to $Child_ID you'll need to add AND into your query. When using the API in a URL the query would be &query={12.EX.1175}AND{8.EX.77} if, for example, the child ID were 77. To do that in the PHP SDK for Quickbase you add 'ao' => 'AND' to all arrays following the first query array. Try updating your $queries array to this:

$queries = array( //this is the where clause now for the delete query
                array(
                    'fid'  => '12',
                    'ev'   => 'EX',
                    'cri'  => '1175'
                ),
                array(
                    'ao'   => 'AND',  // Saying that 12.EX.1175 AND 8.EX.$Child_ID
                    'fid'  => '8',
                    'ev'   => 'EX',
                    'cri'  => $Child_ID
                )
);

My PHP skills aren't particularly good, but you'll need to do a bit more to get the record ID#. In the original code, I think that $record->f[3] will just return to SimpleXMLObject for the third field in the array. That won't necessarily be field ID 3 (the record ID). You can either choose to not use the structured format (and change all of your code to match) or add a loop that goes through all the fields and deletes when it reaches the field with id 3:

foreach($results->table->records->record as $record){ //getting results of delete query
    //Loop through all fields to find id 3
    foreach($record->f as $field){
        if($field['id'] == "3"){
            $Deletevar = $field['id'];
            $deleted = $qb->delete_record($Deletevar); //deleting result
            print_r($deleted);
            break;  //Stops this loop since FID 3 was found
        }
    }
}

Some performance notes: If you aren't using any other fields, you can set your query to only return record IDs by passing a clist that is just '3'. Also, each delete_record() is a separate API call. There is another method purge_records that allows you pass a query and Quickbase deletes all of the records that match your query. You may want to look into using purge_records() because you can you use it in place of your do_query() and avoid all the loops. It uses fewer of your resources and Quickbase's to process as well.

Hello Nathan. Thank you very much for your thorough answer. +1. I also included the records->record part of what I am getting back now that I have the AND in my query statement. For some reason, I still can't seem to get field f[11] which it appears is the record ID that I'm looking for. Even if I straight up put 217 as the $deletevar it still doesn't work. Is there anything that I could be missing that delete_record needs? — FoxMcCloud, Sep 15 '15 at 14:05
I believe I need an app token or an auth ticket. I am unsure how to add this to my current situation. — FoxMcCloud, Sep 15 '15 at 14:11
I found the issue, I will post it in my question as well as accept your answer. Please include my edit in your answer to help others. Thank you! — FoxMcCloud, Sep 15 '15 at 14:32

Quickbase delete_record

1 Answers1