interact with API using python

sophie sun over 1 year ago

Hi Everyone there,

Could anybody help with below: I want to get, post and put from sugarCRM cloud API using python.

I can make get Contacts work, but the filter just doesn't work...

hdr = {

"Cache-Control": "no-cache",

"Content-Type": "application/json",

"OAuth-Token": session["access_token"],

}

pload = {"max_num": 1000}

resp = requests.get(urljoin(SITENAME, 'Contacts'), json=pload, headers=hdr)

Above code will give me all records for Contacts,

but I tried this pload

pload ={"max_num":1000, "filter": [{"name":{"$starts":"Olivia"}}]}

, and the filter doesn't work as I expected.

Parents

0 Rodrigo Manara over 1 year ago

I would recommend to use first_name or last name

{
  "filter": [
    {
      "first_name": {
        "$starts": "Charlotte"
      }
    }
  ],
  "max_num": 10,
  "fields": [
    "name",
    "email"
  ]
}

Reply

0 Rodrigo Manara over 1 year ago

I would recommend to use first_name or last name

{
  "filter": [
    {
      "first_name": {
        "$starts": "Charlotte"
      }
    }
  ],
  "max_num": 10,
  "fields": [
    "name",
    "email"
  ]
}

Children

0 sophie sun over 1 year ago in reply to Rodrigo Manara

Hi Rodrigo,

Yeah, you're right, when I tried filter by first_name, it worked; but when filter by name, it did not work...

Can you share the reason?

Thank you very much!
Cancel
Up 0 Down

Reply

Verify Answer

Cancel