Chilkat2-Python

SugarCRM Filtering Records

See more SugarCRM Examples

Export records and filter. Chilkat2-Python

import sys
import chilkat2

success = False

rest = chilkat2.Rest()

success = rest.Connect("your.site.domain",443,True,True)
if (success != True):
    print(rest.LastErrorText)
    sys.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 = chilkat2.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",False)
jsonReq.UpdateBool("my_items",False)

# 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 = chilkat2.StringBuilder()
jsonReq.EmitSb(sbReq)

rest.AddHeader("Content-Type","application/json")

sbJson = chilkat2.StringBuilder()
success = rest.FullRequestSb("POST","/rest/v10/Accounts/filter",sbReq,sbJson)
if (success != True):
    print(rest.LastErrorText)
    sys.exit()

if (rest.ResponseStatusCode != 200):
    print("Received error response code: " + str(rest.ResponseStatusCode))
    print("Response body:")
    print(sbJson.GetAsString())
    sys.exit()

json = chilkat2.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.")