Changes

Jump to: navigation, search

SmartConnect - Appendix: Standard Field Names

1,462 bytes removed, 20:24, 20 April 2017
no edit summary
The following lists the database field names associated with [[Standard Fields]].<br> These are used in JSON API (SmartConnect).<br> == Field List Syntax ==
These are used in JSON API (SmartConnect).
==Field List Syntax==
{| class="wikitable"
|
|-
|||-!|Field List Syntax!|Example
|-
||Separate values with ";;" ||sf_Name;;cf_MyFieldName
|-
||Prefix Standard fields with "sf_"||sf_Name
|}
==Companies==
{| class="wikitable" style="text-align: center; width: 800px; height: 200px;"
|-
||
==Users==
* '''sf_User ID''': User ID (0 if new user)
* '''sf_Is External''': Flag (1=external, 0=internal)
* '''sf_Company ID''': ID of user's company. 0 if empty.
* '''sf_Company''': name of user's company.
* '''sf_Title''': Title standard field.
* '''sf_Prefix''': Prefix standard field.
* '''sf_Suffix''': Suffix standard field.
* '''sf_First Name''': First name standard field.
* '''sf_Last Name''': Last name standard field.
* '''sf_Email''': Email standard field.
* '''sf_Address''': Address standard field.
* '''sf_Address 2''': Address 2 standard field.
* '''sf_City''': City standard field.
* '''sf_State / Province''': Province standard field.
* '''sf_Country''': name of country field. 0 if empty.
* '''sf_Country ID''': ID of country field. 0 if empty.
* '''sf_Zip / Postal Code''': Postal code standard field.
* '''sf_Phone''': Phone standard field.
* '''sf_Phone Ext''': Phone extension field.
* '''sf_User Role''': Comma delimited list of role IDs. (Starts and ends with a comma)
* '''sf_Active Type''': 1 ('Administration or Portal Interface'), 3 ('User Centric or Applicant Interface'), 5 or 0 ('Web Service User','No Access')
* '''sf_User Type''': 10 ('User'), 30 ('Local User Administrator'), 40 ('Global User Administrator')
* '''sf_Status''': status ID of user
* '''sf_Updated By''': name of user who updated the record.
* '''sf_Last Updated''': date record was last updated.
* '''sf_Created Date''': date record was created.
* '''sf_Created By''': name of user who created the record.
 {|class="wikitable" style="text-align: center; width: 800px;"
|-
||
* '''sf_Branch ID''': Company ID of level 1 branch field. 0 if empty.
* '''sf_Person ID''': User ID of level 1 people field. 0 if empty.
* '''sf_Person''': name of User for level 1 people field.
* '''sf_Type ID''': ID of level 1 template.
* '''sf_Application Template Type''': Level 1 template type name.
* '''sf_Status''': Status name.
* '''sf_Owner ID''': User ID of owner. 0 if empty.
* '''sf_Owner''': Name of owner. * '''sf_Updated By''': Name of user who updated the record. * '''sf_Last Modified''': Date the record was modified. * '''sf_Created By''': Name of user who created the record.
* '''sf_Created Date''': Date the record was created.
==Level 3==
See Level 2.
 
==See Also==
[[JSON API (SmartConnect)]] <br/>[[JSON API (SmartConnect) Prerequisite]]<br>
Lalaine Songalia
Smartstaff
1,385
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/29412’

Navigation menu