SugarCRM REST: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) (Created page with "=SugarCRM REST Origin= ==Sample Origin Filters== See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ Note the [{...}] surrounding the fi...") |
Jkuehlthau (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
==Sample Origin Filters== | ==Sample Origin Filters== | ||
See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ | See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ | ||
Note the [{...}] surrounding the filter. This is required. | Note the [{...}] surrounding the filter. This is required. | ||
Line 7: | Line 8: | ||
A more complex filter: | A more complex filter: | ||
[{"$or":[{"import_source_id_c":{"$not_null":""}},{"import_source_id_c":{"$not_equals":""}}]}] | [{"$or":[{"import_source_id_c":{"$not_null":""}},{"import_source_id_c":{"$not_equals":""}}]}] | ||
Note that the $not_null operation still requires a blank string. | Note that the $not_null operation still requires a blank string. | ||
==VBScript Smart Lookup== | ==VBScript Smart Lookup== | ||
When filtering in a smart lookup, the filter must use double-double quotes: | When filtering in a smart lookup, the filter must use double-double quotes: | ||
[{""id"":""84b1c05c-1043-05c8-ced8-53a2ed18427b""}] | [{""id"":""84b1c05c-1043-05c8-ced8-53a2ed18427b""}] |
Revision as of 15:29, 6 October 2014
SugarCRM REST Origin
Sample Origin Filters
See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/
Note the [{...}] surrounding the filter. This is required.
[{"id":"84b1c05c-1043-05c8-ced8-53a2ed18427b"}]
A more complex filter:
[{"$or":[{"import_source_id_c":{"$not_null":""}},{"import_source_id_c":{"$not_equals":""}}]}]
Note that the $not_null operation still requires a blank string.
VBScript Smart Lookup
When filtering in a smart lookup, the filter must use double-double quotes:
[{""id"":""84b1c05c-1043-05c8-ced8-53a2ed18427b""}]