SugarCRM Cookbook - The School of REST - Part 1

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Thu, 06 Jul 2017 07:23:51 GMT

Comment originally made by Mehul Bhandari.

how to use refresh_token in request ??

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Tue, 20 Jun 2017 04:04:53 GMT

Comment originally made by Anthony.

Can you explain me how to filter in collection. I want to filter user' name . I use the following GET request:

/rest/v10/Calls/6e8ed887-8250-e570-280c-557e95c10de7/collection/invitees?fields=name&filter[0][name]=abc

the Reply:

{

"records": [

{

"id": "seed_chris_id",

"name": "Chris Olliver",

"date_modified": "2016-12-08T11:24:52-08:00",

"_acl": {

"fields": {}

"_module": "Users",

"_link": "users"

{

"id": "e21bd475-0090-2448-082c-523cc7dff4d2",

"name": "Brandi Steel",

"date_modified": "2013-09-25T19:35:16-07:00",

"locked_fields": [],

"_acl": {

"fields": {}

"_module": "Contacts",

"_link": "contacts"

}

"next_offset": {

"contacts": -1,

"leads": -1,

"users": -1

}

I expected no record will return. it looks like the filter didn't work

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Sat, 27 Feb 2016 07:08:45 GMT

Comment originally made by testontashSudeep.

How can I access records in a custom module? Is there any specific way to provide the custom module name? When I tried to access my custom module, it returns only null.

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Thu, 11 Feb 2016 23:22:17 GMT

Comment originally made by Basu Ramanan.

What is the expected way for passing in multiple parameters to $in clause ?

While this works, filter[0][name][$in][]=one&filter[0][name][$in][]=two, I was expecting if we could pass in an array of values in one filter like below

filter[0][name][$in][]=[one,two] (or)

filter[0][name][$in][]={one,two} (or)

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Tue, 12 Jan 2016 21:09:59 GMT

Comment originally made by K.

After some serious googling and trial and error I found out how to use the OR-statement. As always it's simple. But hey, if you're not an expert (like me)...

this is what I need: field=0 or field is null. It translates to:

filter[0][$or][0][field][$equals]=0&filter[0][$or][1][field][$isnull]

Hope it helps

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Tue, 04 Aug 2015 22:38:59 GMT

Comment originally made by Vineeta.

Could you please explain the scenario with 3 email addresses. I tried by entering jim@mclauren.com in primary email, jim1@mclauren.com in email1 and jim2@mclauren.com in email2. However, the API returns -

"email":[{"email_address":"jim@mclauren.com","primary_address":true,"reply_to_address":false,"invalid_email":false,"opt_out":false},{"email_address":"jim2@mclauren.com","primary_address":false,"reply_to_address":false,"invalid_email":false,"opt_out":false},{"email_address":"jim1@mclauren.com","primary_address":false,"reply_to_address":false,"invalid_email":false,"opt_out":false}],"email1":"jim@mclauren.com","email2":"","invalid_email":false,"email_opt_out":false,"email_addresses_non_primary":""

The order of non-primary email addresses changes and nothing appears in email2. Do I need to do something else to get emails in desired order? Thank you.

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Sun, 12 Apr 2015 21:52:52 GMT

Comment originally made by closemarketing.

Hello, I'm looking for the method 'get_module_fields' that it was in SugarCRM 6, and I don't find it in SugarCRM 7 API Help.

Basically, I'm Looking for listing fields from a Module.

Any help? Thanks!

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Wed, 03 Sep 2014 12:22:52 GMT

Comment originally made by t1gana.

This has been incredibly helpful, however I cannot for the life of me figure out how to use the $in and $not_in filters....

I've tried filter[0][name][$in]=one,two

filter[0][name][$in]=[one,two]

filter[0][name][$in]={one,two}

It always says "$in requires an array". I ended up using two equals filters but it would be nice to see an example using an array.

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Thu, 17 Apr 2014 15:09:12 GMT

Comment originally made by Robert.

Could you please expand and explain how and why "email_addresses.email_address" works in the filter? There is no email_addresses "relationship" in the GUI or relationships table.

Which other "relationships" work? I experimented with a few (accounts, accounts_contacts, etc) and none succeeded. Which other items are available to the filter like this? Where is this documented?

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Tue, 15 Apr 2014 00:51:45 GMT

Comment originally made by hdanielb.

Jeff, you reminded me things that can be done using mongoDB.

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Tue, 15 Apr 2014 00:49:38 GMT

Comment originally made by hdanielb.

Great article! I was looking for this...asking about it in other posts. Just must note that url in curl should be between quotes, brackets escaped and space replaced by %20 (otherwise, you'll get a globbing error from curl).

This worked for me:

"htp://url/rest/v10/Accounts?filter\[0\]\[name\]=Burger%20Palace&fields=name,account_type,description,email"

RE: SugarCRM Cookbook - The School of REST - Part 1

SugarCRM Developers — Wed, 05 Mar 2014 17:18:19 GMT

Comment originally made by Jeff Walters.

This is good information on SugarCRM V7 REST.

Concerning filters, can custom expressions be used with multiple fields? For example, say I have custom latitude and longitude fields for my Accounts module. Based on a search by radius (estimation) expression, how would I pass in an expression using these two fields? The expression would require two fields and math functions such as COS() & SQRT(). Would I need to pull all records and then do the calculation in JavaScript?