MBS FileMaker Plugin Example Databases

Google OAUTH 2 example

All examples are included with download of MBS FileMaker Plugin.

Google OAUTH 2 example.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts3
Value Lists0
Custom Functions2
Custom Menus0
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Google OAUTH 2 example
14 fields defined, 1 record
Google OAUTH 2 example

Fields

Table Name: Google OAUTH 2 example - 14 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
client_secretNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: English
      client_idNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: English
      Enter your client_id from https://code.google.com/apis/console
          curl_result_as_textNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: English
              curl_header_as_textNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: English
                  device_codeNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: English
                      user_codeNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: English
                          verification_urlNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: English
                              expires_inNormal, NumberAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: English
                                  intervalNormal, NumberAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: English
                                      access_tokenNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: English
                                          token_typeNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: English
                                              token_expires_inNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: English
                                                  id_tokenNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: English
                                                      refresh_tokenNormal, TextAuto-Enter:
                                                      • Allow editing
                                                      Validation:
                                                      • Only during data entry
                                                      Storage:
                                                      • Repetitions: 1
                                                      • Indexing: None
                                                      • Automatically create indexes as needed
                                                      • Index Language: English

                                                          Layout Objects: Google OAUTH 2 example

                                                          Regular Fields

                                                          Field Name: Google OAUTH 2 example::client_secret
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 22 pt
                                                          • Left: 80 pt
                                                          • Bottom: 44 pt
                                                          • Right: 404 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::client_id
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 0 pt
                                                          • Left: 80 pt
                                                          • Bottom: 22 pt
                                                          • Right: 404 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::curl_result_as_text
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 100 pt
                                                          • Left: 0 pt
                                                          • Bottom: 266 pt
                                                          • Right: 316 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          • Include vertical scrollbar
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::curl_header_as_text
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 100 pt
                                                          • Left: 327 pt
                                                          • Bottom: 266 pt
                                                          • Right: 570 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          • Include vertical scrollbar
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::device_code
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 275 pt
                                                          • Left: 96 pt
                                                          • Bottom: 297 pt
                                                          • Right: 349 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::user_code
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 301 pt
                                                          • Left: 95 pt
                                                          • Bottom: 323 pt
                                                          • Right: 348 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::verification_url
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 325 pt
                                                          • Left: 95 pt
                                                          • Bottom: 347 pt
                                                          • Right: 348 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::expires_in
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 349 pt
                                                          • Left: 95 pt
                                                          • Bottom: 371 pt
                                                          • Right: 348 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::interval
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 373 pt
                                                          • Left: 95 pt
                                                          • Bottom: 395 pt
                                                          • Right: 348 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::access_token
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 438 pt
                                                          • Left: 138 pt
                                                          • Bottom: 460 pt
                                                          • Right: 570 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::token_type
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 462 pt
                                                          • Left: 134 pt
                                                          • Bottom: 484 pt
                                                          • Right: 387 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::token_expires_in
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 487 pt
                                                          • Left: 131 pt
                                                          • Bottom: 509 pt
                                                          • Right: 384 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::id_token
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 511 pt
                                                          • Left: 136 pt
                                                          • Bottom: 601 pt
                                                          • Right: 568 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          • Include vertical scrollbar
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Field Name: Google OAUTH 2 example::refresh_token
                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                          • Top: 611 pt
                                                          • Left: 124 pt
                                                          • Bottom: 633 pt
                                                          • Right: 570 pt
                                                          • Anchoring: Left, Top
                                                          Field Format:
                                                          • Edit Box
                                                          Field Behavior:
                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                          • Touch keyboard type: System Default
                                                          • Go to next field using: Tab key
                                                          Yes

                                                          Buttons

                                                          Button PropertiesCoordinatesScript/Script Step
                                                            Type:
                                                          • Text: Obtain a User Code
                                                          • Top: 61 pt
                                                          • Left: 80 pt
                                                          • Bottom: 83 pt
                                                          • Right: 220 pt
                                                          • Anchoring: Left, Top
                                                          Perform Script [ “MonkeyBread Post using Curl to obtain user code” ]

                                                          Scripts:


                                                          Button PropertiesCoordinatesScript/Script Step
                                                            Type:
                                                          • Text: Verify Access by entering User Code in browser
                                                          • Top: 325 pt
                                                          • Left: 406 pt
                                                          • Bottom: 362 pt
                                                          • Right: 570 pt
                                                          • Anchoring: Left, Top
                                                          Open URL [ Google OAUTH 2 example::verification_url ] [ No dialog ]

                                                          Fields:


                                                          Button PropertiesCoordinatesScript/Script Step
                                                            Type:
                                                          • Text: Obtain Access and Refresh Tokens
                                                          • Top: 414 pt
                                                          • Left: 57 pt
                                                          • Bottom: 436 pt
                                                          • Right: 275 pt
                                                          • Anchoring: Left, Top
                                                          Perform Script [ “MonkeyBread Post using Curl to obtain access and refresh tokens” ]

                                                          Scripts:


                                                          Button PropertiesCoordinatesScript/Script Step
                                                            Type:
                                                          • Text: Call the API
                                                          • Top: 638 pt
                                                          • Left: 57 pt
                                                          • Bottom: 660 pt
                                                          • Right: 275 pt
                                                          • Anchoring: Left, Top
                                                          Open URL [ "https://www.googleapis.com/oauth2/v1/userinfo?access_token=" & Google OAUTH 2 example::access_token ] [ No dialog ]

                                                          Fields:


                                                          Button PropertiesCoordinatesScript/Script Step
                                                            Type:
                                                          • Text: Refresh The Token
                                                          • Top: 681 pt
                                                          • Left: 58 pt
                                                          • Bottom: 703 pt
                                                          • Right: 276 pt
                                                          • Anchoring: Left, Top
                                                          Perform Script [ “MonkeyBread Post using Curl to refresh token” ]

                                                          Scripts:


                                                          Script Hierarchy

                                                          MonkeyBread Post using Curl to obtain user code
                                                          MonkeyBread Post using Curl to obtain access and refresh tokens
                                                          MonkeyBread Post using Curl to refresh token

                                                          Next Script: [MonkeyBread Post using Curl to obtain access and refresh tokens]
                                                          Script NameMonkeyBread Post using Curl to obtain user code
                                                          Run script with full access privilegesOff
                                                          Include In MenuYes
                                                          Layouts that use this script
                                                          Scripts that use this script
                                                            Script Definition
                                                            Script Steps
                                                            • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                            • Set Variable [ $result; Value:MBS("CURL.SetOptionPost"; $curl; 1) ]
                                                            • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; "https://accounts.google.com/o/oauth2/device/code") ]
                                                            • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "client_id"; Google OAUTH 2 example::client_id) ]
                                                            • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "scope"; "https://www.googleapis.com/auth/userinfo.email https://www.googleapis.com/auth/userinfo.profile") ]
                                                            • Set Variable [ $result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 0 ) ]
                                                            • Set Variable [ $result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 0 ) ]
                                                            • Set Variable [ $result; Value:MBS("CURL.FormFinish"; $curl; $input) ]
                                                            • Set Variable [ $$curl_result; Value:MBS("CURL.Perform"; $curl) ]
                                                            • Set Field [ Google OAUTH 2 example::curl_result_as_text; MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ]
                                                            • Set Field [ Google OAUTH 2 example::curl_header_as_text; MBS("String.ReplaceNewline"; MBS("CURL.GetHeaderAsText"; $curl);1) ]
                                                            • Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
                                                            • Set Field [ Google OAUTH 2 example::device_code; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "\"device_code\" : \"" ; "\"" ; 1 ) ]
                                                            • Set Field [ Google OAUTH 2 example::user_code; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "\"user_code\" : \"" ; "\"" ; 1 ) ]
                                                            • Set Field [ Google OAUTH 2 example::verification_url; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "\"verification_url\" : \"" ; "\"" ; 1 ) ]
                                                            • Set Field [ Google OAUTH 2 example::expires_in; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "\"expires_in\" : " ; "," ; 1 ) ]
                                                            • Set Field [ Google OAUTH 2 example::interval; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "\"interval\" : " ; "¶" ; 1 ) ]
                                                            • Exit Script [ ]
                                                            Fields used in this script
                                                            Scripts used in this script
                                                              Layouts used in this script
                                                                Tables used in this script
                                                                Table occurrences used by this script
                                                                Custom Functions used by this script
                                                                Custom menu set used by this script

                                                                  Previous Script: [MonkeyBread Post using Curl to obtain user code]Next Script: [MonkeyBread Post using Curl to refresh token]
                                                                  Script NameMonkeyBread Post using Curl to obtain access and refresh tokens
                                                                  Run script with full access privilegesOff
                                                                  Include In MenuYes
                                                                  Layouts that use this script
                                                                  Scripts that use this script
                                                                    Script Definition
                                                                    Script Steps
                                                                    • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionPost"; $curl; 1) ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; "https://accounts.google.com/o/oauth2/token") ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "client_id"; Google OAUTH 2 example::client_id) ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "client_secret"; Google OAUTH 2 example::client_secret) ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "code"; Google OAUTH 2 example::device_code) ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "grant_type"; "http://oauth.net/grant_type/device/1.0") ]
                                                                    • Set Variable [ $result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 0 ) ]
                                                                    • Set Variable [ $result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 0 ) ]
                                                                    • Set Variable [ $result; Value:MBS("CURL.FormFinish"; $curl; $input) ]
                                                                    • Set Variable [ $$curl_result; Value:MBS("CURL.Perform"; $curl) ]
                                                                    • Set Field [ Google OAUTH 2 example::curl_result_as_text; MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ]
                                                                    • Set Field [ Google OAUTH 2 example::curl_header_as_text; MBS("String.ReplaceNewline"; MBS("CURL.GetHeaderAsText"; $curl);1) ]
                                                                    • Set Field [ Google OAUTH 2 example::access_token; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "access_token\" : \"" ; "\"" ; 1 ) ]
                                                                    • Set Field [ Google OAUTH 2 example::token_type; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "token_type\" : \"" ; "\"" ; 1 ) ]
                                                                    • Set Field [ Google OAUTH 2 example::token_expires_in; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "expires_in\" : " ; "," ; 1 ) ]
                                                                    • Set Field [ Google OAUTH 2 example::id_token; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "id_token\" : \"" ; "\"" ; 1 ) ]
                                                                    • Set Field [ Google OAUTH 2 example::refresh_token; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "refresh_token\" : \"" ; "\"" ; 1 ) ]
                                                                    • Exit Script [ ]
                                                                    Fields used in this script
                                                                    Scripts used in this script
                                                                      Layouts used in this script
                                                                        Tables used in this script
                                                                        Table occurrences used by this script
                                                                        Custom Functions used by this script
                                                                        Custom menu set used by this script

                                                                          Previous Script: [MonkeyBread Post using Curl to obtain access and refresh tokens]
                                                                          Script NameMonkeyBread Post using Curl to refresh token
                                                                          Run script with full access privilegesOff
                                                                          Include In MenuYes
                                                                          Layouts that use this script
                                                                          Scripts that use this script
                                                                            Script Definition
                                                                            Script Steps
                                                                            • Set Variable [ $curl; Value:MBS("CURL.New") ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.SetOptionPost"; $curl; 1) ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; "https://accounts.google.com/o/oauth2/token") ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "client_id"; Google OAUTH 2 example::client_id) ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "client_secret"; Google OAUTH 2 example::client_secret) ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "refresh_token"; Google OAUTH 2 example::refresh_token) ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.FormAddKeyValue"; $curl; "grant_type"; "refresh_token") ]
                                                                            • Set Variable [ $result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 0 ) ]
                                                                            • Set Variable [ $result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 0 ) ]
                                                                            • Set Variable [ $result; Value:MBS("CURL.FormFinish"; $curl; $input) ]
                                                                            • Set Variable [ $$curl_result; Value:MBS("CURL.Perform"; $curl) ]
                                                                            • Set Field [ Google OAUTH 2 example::curl_result_as_text; MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ]
                                                                            • Set Field [ Google OAUTH 2 example::curl_header_as_text; MBS("String.ReplaceNewline"; MBS("CURL.GetHeaderAsText"; $curl);1) ]
                                                                            • Set Field [ Google OAUTH 2 example::access_token; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "access_token\" : \"" ; "\"" ; 1 ) ]
                                                                            • Set Field [ Google OAUTH 2 example::token_type; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "token_type\" : \"" ; "\"" ; 1 ) ]
                                                                            • Set Field [ Google OAUTH 2 example::token_expires_in; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "expires_in\" : " ; "," ; 1 ) ]
                                                                            • Set Field [ Google OAUTH 2 example::id_token; ParseData ( Google OAUTH 2 example::curl_result_as_text ; "id_token\" : \"" ; "\"" ; 1 ) ]
                                                                            • Exit Script [ ]
                                                                            Fields used in this script
                                                                            Scripts used in this script
                                                                              Layouts used in this script
                                                                                Tables used in this script
                                                                                Table occurrences used by this script
                                                                                Custom Functions used by this script
                                                                                Custom menu set used by this script

                                                                                  Custom Functions

                                                                                  Function NameParametersAvailabilityDefinitionIn Field DefinitionsIn Scripts
                                                                                  GetNamedParametername;paramsAll accounts// Version: Mar 18 2011, 11:30 // Retrives a named value from a string of serialized parameters // The params parameter is the serialized string If( GetValue ( params ; 1 ) = name; Middle ( params ; Position ( params ; ¶ ; 0 ; 2) + 1; GetValue ( params; 2 ) ); If( Length( params ) - (Position ( params ; ¶ ; 0 ; 2) + GetValue ( params; 2 ) ) > 0; GetNamedParameter( name; Right ( params ; Length( params ) - (Position ( params ; ¶ ; 0 ; 2) + GetValue ( params; 2 ) ) ) ); "?" ) )
                                                                                    ParseDatatheText;theStartTag;theEndTag;theOccuranceAll accounts// ParseData ( theText; theStartTag; theEndTag; theOccurance) // // Extract the text between two strings. // // Parameters: // theText = the text to parse // theStartTag = the string that comes before the text to extract // theEndTag = the string that comes after the text to extract // theOccurance = the instance of the text to extract // // Return Value: // the instance of text found in theText beween theStartTag and theEndTag based on theOccurance // Let ( [ theStartPos = Position ( theText ; theStartTag ; 1 ; theOccurance ) ; theResult = Case ( // ------------------------------ // If theStartTag was not found, return an empty string. theStartPos = 0 ; "" ; // ------------------------------ // ------------------------------ // If theStartTag was found, get the string we are looking for. theStartPos > 0 ; Let ( [ theStartPos = theStartPos + Length ( theStartTag ) ; theEndPos = Position ( theText ; theEndTag ; theStartPos ; 1 ) ; theLengthToKeep = theEndPos - theStartPos; theResult = Middle ( theText ; theStartPos ; theLengthToKeep ) ] ; theResult ) // ------------------------------ ) // End case ] ; theResult )

                                                                                      Custom Menu Sets

                                                                                      Menu SetsMenusIn ScriptsIn LayoutsComments
                                                                                      [Standard FileMaker Menus]
                                                                                      • All Standard Menus

                                                                                      Download example: Google OAUTH 2 example

                                                                                      Used functions:




                                                                                      Links
                                                                                      MBS Xojo PDF Plugins