Monkeybread Software - MBS FileMaker Plugin: Sales Force Test

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

Sales Force Test

All examples are included with download of MBS FileMaker Plugin.

Sales Force Test.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	2
Value Lists	0
Custom Functions	0
Custom Menus	24

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Login	10 fields defined, 1 record	Login

Fields

Table Name: Login - 10 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
username	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login
password	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login
Endpoint	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login Query
CURL Result	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login Query
CURL Output	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login Query
CURL Debug	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login Query
XML Template Login	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login
sessionId	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login Query
userId	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Login
XML Template Query	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Login		Query

Layout Objects: Login

Regular Fields

Field Name: Login::username

Layout Name:

Top: 60 pt
Left: 218 pt
Bottom: 81 pt
Right: 732 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::password

Layout Name:

Top: 83 pt
Left: 218 pt
Bottom: 104 pt
Right: 732 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::Endpoint

Layout Name:

Top: 106 pt
Left: 218 pt
Bottom: 127 pt
Right: 732 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::CURL Result

Layout Name:

Top: 229 pt
Left: 218 pt
Bottom: 250 pt
Right: 471 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::CURL Output

Layout Name:

Top: 252 pt
Left: 218 pt
Bottom: 370 pt
Right: 732 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::CURL Debug

Layout Name:

Top: 376 pt
Left: 218 pt
Bottom: 549 pt
Right: 732 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::XML Template Login

Layout Name:

Top: 566 pt
Left: 218 pt
Bottom: 587 pt
Right: 471 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::sessionId

Layout Name:

Top: 162 pt
Left: 218 pt
Bottom: 183 pt
Right: 471 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::userId

Layout Name:

Top: 185 pt
Left: 218 pt
Bottom: 206 pt
Right: 471 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Login::XML Template Query

Layout Name:

Top: 593 pt
Left: 218 pt
Bottom: 614 pt
Right: 471 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Script Name	Login
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Field [ Login::sessionId; "" ] Set Field [ Login::userId; "" ] #new session Set Variable [ $curl; Value:MBS("CURL.New") ] #talk to the URL of server Set Variable [ $r; Value:MBS("CURL.SetOptionURL"; $curl; Login::Endpoint) ] #we need to specify empty SOAPAction Set Variable [ $r; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"\"") ] #Our XML template where we enter username and password Set Variable [ $xml; Value:Login::XML Template Login ] Set Variable [ $xml; Value:Substitute($xml; "$username$"; MBS("Text.EncodeToXML"; Login::username)) ] Set Variable [ $xml; Value:Substitute($xml; "$password$"; MBS("Text.EncodeToXML"; Login::password)) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPostFields"; $curl; $xml) ] #Run the query Set Variable [ $result; Value:MBS("CURL.Perform"; $curl) ] #Query results Set Field [ Login::CURL Result; $result ] Set Variable [ $httpResponseCode; Value:MBS( "CURL.GetResponseCode"; $curl ) ] Set Field [ Login::CURL Result; $r ] Set Field [ Login::CURL Output; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ Login::CURL Debug; MBS("CURL.GetDebugMessages"; $curl; "UTF8") ] If [ $r = "OK" and $httpResponseCode >= 200 and $httpResponseCode < 300 ] #If okay, extract the session ID and user ID Set Field [ Login::sessionId; MBS( "XML.ExtractText"; MBS( "XML.SubTree"; Login::CURL Output; "Body¶loginResponse¶result¶sessionId")) ] Set Field [ Login::userId; MBS( "XML.ExtractText"; MBS( "XML.SubTree"; Login::CURL Output; "Body¶loginResponse¶result¶userId")) ] End If Set Variable [ $r; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	Login::sessionId Login::userId Login::Endpoint Login::XML Template Login Login::username Login::password Login::CURL Result Login::CURL Output Login::CURL Debug
Scripts used in this script
Layouts used in this script
Tables used in this script	Login
Table occurrences used by this script	Login
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Login]

Script Name	Query
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $curl; Value:MBS("CURL.New") ] Set Variable [ $r; Value:MBS("CURL.SetOptionURL"; $curl; Login::Endpoint) ] Set Variable [ $r; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: text/xml;charset=UTF-8"; "SOAPAction: \"\"") ] #using query template to send query Set Variable [ $xml; Value:Login::XML Template Query ] Set Variable [ $xml; Value:Substitute($xml; "$sessionid$"; MBS("Text.EncodeToXML"; Login::sessionId)) ] Set Variable [ $xml; Value:Substitute($xml; "$Query$"; MBS("Text.EncodeToXML"; "SELECT FirstName, LastName FROM Contact")) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPostFields"; $curl; $xml) ] Set Variable [ $r; Value:MBS("CURL.SetDebugWithData"; $curl; 1) ] Set Variable [ $result; Value:MBS("CURL.Perform"; $curl) ] Set Field [ Login::CURL Result; $result ] Set Variable [ $httpResponseCode; Value:MBS( "CURL.GetResponseCode"; $curl ) ] Set Field [ Login::CURL Result; $r ] Set Field [ Login::CURL Output; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ Login::CURL Debug; MBS("CURL.GetDebugMessages"; $curl; "UTF8") ] If [ $r = "OK" and $httpResponseCode >= 200 and $httpResponseCode < 300 ] #Process XML from results here End If Set Variable [ $r; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	Login::Endpoint Login::XML Template Query Login::sessionId Login::CURL Result Login::CURL Output Login::CURL Debug
Scripts used in this script
Layouts used in this script
Tables used in this script	Login
Table occurrences used by this script	Login
Custom Functions used by this script
Custom menu set used by this script

Download example: Sales Force Test

Used functions: