SugarCRM REST

From Starfish ETL
Revision as of 15:29, 6 October 2014 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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""}]