A
aventofilip
Guest
I checked the various responses from selectQuery and getRecord with xml and json. Here are the outcomes Field type selectQuery (json) selectQuery (xml) getRecord (json) getRecord (xml) Lookup (one to many) null null ID Name Lookup (many to one) ID ID ID Name Currency decimal with comma, breaks json ok integer value, e.g. 1,00 = 100 integer value, e.g. 1,00 = 100 Formula error error ok ok File upload gibberish gibberish name of file ok (name of file, type and content base64) Email Address ok ok ok ok Document template id? id? template name? template name? Date/Time Wed Feb 14 2018 08:06:05 (CEST) Wed Feb 14 08:06:05 CET 2018 Wed Feb 14 08:06:05 CET 2018 2018-02-14T07:06:05Z Date Wed Feb 14 2018 Wed Feb 14 00:00:00 CET 2018 Wed Feb 14 2018 2018-02-14 Checkbox 0/1 0/1 true/false true/false Group of checkboxes string representation of ids of values, splitted by comma "," string representation of ids of values, splitted by comma "," code of values, splitted with pipe "|" code of values, splitted with pipe "|" Integer ok ok ok ok Organization data → e.g. departmentId ID ID Name Name Picklist → e.g. deliverymethod ID ID Name - "Direct" Name - "Direct" Process → e.g. process ID ID Name - "Standard" Name - "Standard" Radio buttons → e.g. shortage ID ID Code - "MAN" Code - "MAN" Record lock 0/1 0/1 true/false true/false Record name ok ok ok ok Related field → e.g. Baseenhet (regnr) ok ok ok ok Status ID ID Code - "63" Code - "63" Template text error error Raw string HTML encoded string Text ok ok ok ok Text area ok ok ok ok Time numeric: 10800000 numeric(?): 10800000 string: "03:00" string(?): "03:00" User link ID ID Name Name Workflow actions error error missing field missing field
Continue reading...
Continue reading...