Changes

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>

• ← Older edit
• Newer edit →

Lalaine Songalia

Smartstaff

1,385

edits