Developer Guide
Understanding Magentrix Field Types

    Magentrix has a rich set of Field Types available. When working with REST API, it is useful to know how the fields in the Entity are defined so that they can be mapped back to their proper field type. Below is the list of available field types within Magentrix:

    • Auto Number : integer (FieldTypeId: 7NY00000000000k0000)
    • Formula : depending on how this field is defined, it could be string, datetime, decimal, or boolean. Formula fields are read-only. With the exception of Force entities, queries cannot be filtered based on Formula fields (FieldTypeId: 7NY00000000000j0000).
    • Rollup Summary : depending how this field is defined, it could be type of int64, string, datetime, decimal. Rollup fields are read-only (FieldTypeId: 7NY00000000000i0000).
    • Lookup : string, with length of 19 (FieldTypeId: 7NY0000000000060000).
    • Master Detail : string, with length of 19 (FieldTypeId: 7NY00000000000h0000).
    • Checkbox : boolean (FieldTypeId: 7NY0000000000050000).
    • Currency : decimal (FieldTypeId: 7NY00000000000a0000).
    • Date : DateTime; however, only the date portion is used (FieldTypeId: 7NY0000000000070000).
    • DateTime : DateTime (FieldTypeId: 7NY0000000000020000).
    • Email : string, with maximum length of 255 (FieldTypeId: 7NY00000000000d0000).
    • Global Picklist : string, with maximum length of 80 (FieldTypeId: 7NY0000000000030000).
    • Multi-Select Picklist : string, with maximum length of 150 (FieldTypeId: 7NY00000000000g0000).
    • Number : decimal (FieldTypeId: 7NY00000000000b0000).
    • Password : string, with maximum length of 50 (FieldTypeId: 7NY00000000000l0000).
    • Percent : decimal (FieldTypeId: 7NY00000000000c0000).
    • Phone : string, with maximum length of 40 (FieldTypeId: 7NY00000000000e0000).
    • Picklist : string, with maximum length of 150 (FieldTypeId: 7NY0000000000090000).
    • Text : string, with maximum length as defined (FieldTypeId: 7NY0000000000000000).
    • TextArea : string, with maximum length as defined (FieldTypeId: 7NY0000000000040000).
    • Time : string (FieldTypeId: 7NY0000000000080000).
     
    You can alternately query all the field types in the system as follows:
     
    https://<instance>.magentrix.com/rest/2.0/query?q=FROM Sys.FieldType SELECT Id,Name

     

    The JSON Response Content will look like:

    {
        "Count": 22,
        "Records": [
            {
                "Id": "7NY00000000000k0000",
                "Name": "Auto Number"
            },
            {
                "Id": "7NY0000000000050000",
                "Name": "Checkbox"
            },
            {
                "Id": "7NY00000000000a0000",
                "Name": "Currency"
            },
            {
                "Id": "7NY0000000000070000",
                "Name": "Date"
            },
            {
                "Id": "7NY0000000000020000",
                "Name": "DateTime"
            },
            {
                "Id": "7NY00000000000d0000",
                "Name": "Email"
            },
            {
                "Id": "7NY00000000000j0000",
                "Name": "Formula"
            },
            {
                "Id": "7NY0000000000030000",
                "Name": "Global Picklist"
            },
            {
                "Id": "7NY0000000000010000",
                "Name": "ID"
            },
            {
                "Id": "7NY0000000000060000",
                "Name": "Lookup"
            },
            {
                "Id": "7NY00000000000h0000",
                "Name": "Master Detail"
            },
            {
                "Id": "7NY00000000000g0000",
                "Name": "Multi-Select Picklist"
            },
            {
                "Id": "7NY00000000000b0000",
                "Name": "Number"
            },
            {
                "Id": "7NY00000000000l0000",
                "Name": "Password"
            },
            {
                "Id": "7NY00000000000c0000",
                "Name": "Percent"
            },
            {
                "Id": "7NY00000000000e0000",
                "Name": "Phone"
            },
            {
                "Id": "7NY0000000000090000",
                "Name": "Picklist"
            },
            {
                "Id": "7NY00000000000i0000",
                "Name": "Rollup Summary"
            },
            {
                "Id": "7NY0000000000000000",
                "Name": "Text"
            },
            {
                "Id": "7NY0000000000040000",
                "Name": "TextArea"
            },
            {
                "Id": "7NY0000000000080000",
                "Name": "Time"
            },
            {
                "Id": "7NY00000000000f0000",
                "Name": "URL"
            }
        ]
    }