Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3/4TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

PHP ActiveX Web API Examples

Primary Categories

Facebook
GeoOp
Jira
PayPal
Peoplevox
QuickBooks

Shopify
Stripe
SugarCRM
Twitter
VoiceBase
Walmart
Xero
eBay
effectconnect

 

 

 

(PHP ActiveX) SugarCRM Filtering Records

Export records and filter.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

Note: The php_com_dotnet.dll may need to be enabled inside of php.ini.

<?php

$rest = new COM("Chilkat_9_5_0.Rest");

$success = $rest->Connect('your.site.domain',443,1,1);
if ($success != 1) {
    print $rest->LastErrorText . "\n";
    exit;
}

$rest->AddHeader('Cache-Control','no-cache');
$rest->AddHeader('OAuth-Token','<access_token>');

// The following code creates the JSON request body.
// The JSON created by this code is shown below.
$jsonReq = new COM("Chilkat_9_5_0.JsonObject");
$jsonReq->UpdateString('filter[0].$or[0].name.$starts','A');
$jsonReq->UpdateString('filter[0].$or[1].name.$starts','b');
$jsonReq->UpdateNumber('max_num','2');
$jsonReq->UpdateNumber('offset','0');
$jsonReq->UpdateString('fields','id');
$jsonReq->UpdateString('order_by','date_entered');
$jsonReq->UpdateBool('favorites',0);
$jsonReq->UpdateBool('my_items',0);

// The JSON request body created by the above code:

// {
//   "filter": [
//     {
//       "$or": [
//         {
//           "name": {
//             "$starts": "A"
//           }
//         },
//         {
//           "name": {
//             "$starts": "b"
//           }
//         }
//       ]
//     }
//   ],
//   "max_num": 2,
//   "offset": 0,
//   "fields": "id",
//   "order_by": "date_entered",
//   "favorites": false,
//   "my_items": false
// }

$sbReq = new COM("Chilkat_9_5_0.StringBuilder");
$jsonReq->EmitSb($sbReq);

$rest->AddHeader('Content-Type','application/json');

$sbJson = new COM("Chilkat_9_5_0.StringBuilder");
$success = $rest->FullRequestSb('POST','/rest/v10/Accounts/filter',$sbReq,$sbJson);
if ($success != 1) {
    print $rest->LastErrorText . "\n";
    exit;
}

if ($rest->ResponseStatusCode != 200) {
    print 'Received error response code: ' . $rest->ResponseStatusCode . "\n";
    print 'Response body:' . "\n";
    print $sbJson->getAsString() . "\n";
    exit;
}

$json = new COM("Chilkat_9_5_0.JsonObject");
$json->LoadSb($sbJson);

// The following code parses the JSON response.
// A sample JSON response is shown below the sample code.

$next_offset = $json->IntOf('next_offset');
$i = 0;
$count_i = $json->SizeOfArray('records');
while ($i < $count_i) {
    $json->I = $i;
    $id = $json->stringOf('records[i].id');
    $date_modified = $json->stringOf('records[i].date_modified');
    $v_module = $json->stringOf('records[i]._module');
    $i = $i + 1;
}

// A sample JSON response body that is parsed by the above code:

// {
//   "next_offset": 2,
//   "records": [
//     {
//       "id": "f16760a4-3a52-f77d-1522-5703ca28925f",
//       "date_modified": "2016-04-05T10:23:28-04:00",
//       "_acl": {
//         "fields": {}
//       },
//       "_module": "Accounts"
//     },
//     {
//       "id": "ec409fbb-2b22-4f32-7fa1-5703caf78dc3",
//       "date_modified": "2016-04-05T10:23:28-04:00",
//       "_acl": {
//         "fields": {}
//       },
//       "_module": "Accounts"
//     }
//   ]
// }

print 'Example Completed.' . "\n";

?>

 

© 2000-2019 Chilkat Software, Inc. All Rights Reserved.