HTML Reports work without issue in CRM Online, but not in offline CRM (iPad/Windows), or vice versa.
Our Development team is working on the best way to align these differences at a future date.
|Boolean fields||true/false (boolean)||iPad - 1, 0 (number)||"True", "False" (string)|
|When there is no value return for the selected field||null||"" (empty string)||same as iPad|
|In the return object from getDataForCurrentObject()||"ID"||The property name will match the case from the query field
e.g. "Id" or "ID"
|same as iPad|
|When selecting Date/DateTime/Time/Boolean fields||2/1/2018||"2018-02-01" (require value to be surrounded by quotes)||same as iPad|
|When querying with boolean fields in "where"||true/false (boolean)||either case work:
- true/false (boolean)
-"true"/"false" (as string, surrounded by quotes)
|"true"/"false" (as string, surrounded by quotes)|
|When querying field with no value in "where"||the empty value need to be specify as null||the empty value need to be specify as ' ' (empty string)||same as iPad|
|Case sensitiveness of Object API names and Field API names||Insensitive||Sensitive||Insensitive|
|Number field||0,1,2...||0,1,2...||"0","1","2"... (in string)|
HTML reports that are designed for use on different platforms will require additional logic and testing to ensure that these differences do not cause issues.
CRM Help Documentation: MyInsights API Reference
Send us your feedback: We are always looking for feedback to help improve our Knowledge Base! Please let us know if this article is helpful or provide feedback on how we can improve your experience by clicking here.