Monkeybread Software - MBS FileMaker Plugin: ebay Webservice

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

MBS FileMaker Plugin Example Databases

ebay Webservice

All examples are included with download of MBS FileMaker Plugin.

ebay Webservice.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	5
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
ebay Webservice	9 fields defined, 1 record	ebay Webservice

Fields

Table Name: ebay Webservice - 9 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
Client ID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		ebay Webservice		LoadLogin Get Access Token Refresh Token Query orders
Client Secret	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		ebay Webservice		Get Access Token Refresh Token Query orders
Runame	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		ebay Webservice		LoadLogin Refresh Token
Request	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		ebay Webservice		Get Access Token Query orders
DebugMessages	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		ebay Webservice		Get Access Token Refresh Token Query orders
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		ebay Webservice		Get Access Token Refresh Token Query orders
AccessToken	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		ebay Webservice		Get Access Token Refresh Token Query orders
RefreshToken	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		ebay Webservice		Get Access Token Refresh Token
Code	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		ebay Webservice		Get Code Get Access Token

Layout Objects: ebay Webservice

Regular Fields

Field Name: ebay Webservice::Client ID

Layout Name:

ebay Webservice

Top: 24 pt
Left: 108 pt
Bottom: 45 pt
Right: 485 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

Field Name: ebay Webservice::Client Secret

Layout Name:

ebay Webservice

Top: 47 pt
Left: 108 pt
Bottom: 68 pt
Right: 485 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

Field Name: ebay Webservice::Runame

Layout Name:

ebay Webservice

Top: 71 pt
Left: 108 pt
Bottom: 92 pt
Right: 485 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

Field Name: ebay Webservice::AccessToken

Layout Name:

ebay Webservice

Top: 48 pt
Left: 595 pt
Bottom: 69 pt
Right: 972 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

Field Name: ebay Webservice::RefreshToken

Layout Name:

ebay Webservice

Top: 71 pt
Left: 595 pt
Bottom: 92 pt
Right: 972 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

Field Name: ebay Webservice::Result

Layout Name:

ebay Webservice

Top: 362 pt
Left: 81 pt
Bottom: 604 pt
Right: 473 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: ebay Webservice::Request

Layout Name:

ebay Webservice

Top: 185 pt
Left: 81 pt
Bottom: 356 pt
Right: 473 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: ebay Webservice::DebugMessages

Layout Name:

ebay Webservice

Top: 161 pt
Left: 481 pt
Bottom: 604 pt
Right: 960 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: ebay Webservice::Code

Layout Name:

ebay Webservice

Top: 24 pt
Left: 596 pt
Bottom: 45 pt
Right: 972 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

Type:

Text: Login

Layout Name:

ebay Webservice

Top: 142 pt
Left: 20 pt
Bottom: 171 pt
Right: 154 pt

Anchoring: Left, Top

Perform Script [ “LoadLogin” ]

Scripts:

LoadLogin

Button Properties

Coordinates

Script/Script Step

Type:

Text: Copy Code

Layout Name:

ebay Webservice

Top: 142 pt
Left: 171 pt
Bottom: 172 pt
Right: 305 pt

Anchoring: Left, Top

Perform Script [ “Get Code” ]

Scripts:

Get Code

Button Properties

Coordinates

Script/Script Step

Type:

Text: Get Access Token

Layout Name:

ebay Webservice

Top: 144 pt
Left: 21 pt
Bottom: 177 pt
Right: 137 pt

Anchoring: Left, Top

Perform Script [ “Get Access Token” ]

Scripts:

Get Access Token

Button Properties

Coordinates

Script/Script Step

Type:

Text: Refresh Access Token

Layout Name:

ebay Webservice

Top: 144 pt
Left: 149 pt
Bottom: 177 pt
Right: 304 pt

Anchoring: Left, Top

Perform Script [ “Refresh Token” ]

Scripts:

Refresh Token

Button Properties

Coordinates

Script/Script Step

Type:

Text: Query Orders

Layout Name:

ebay Webservice

Top: 144 pt
Left: 315 pt
Bottom: 177 pt
Right: 470 pt

Anchoring: Left, Top

Perform Script [ “Query orders” ]

Scripts:

Query orders

Tab Controls

Tab Control Properties				Coordinates
Layout Name: ebay Webservice Justification: Left Tab Width: Default Front Tab: Tab 0				Top: 109 pt Left: 7 pt Bottom: 615 pt Right: 1015 pt Anchoring: Left, Top
Tabs
Tab Properties	Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
Tab 0: "Login" Object Name: tabs				Text: Login-->Perform Script [ “LoadLogin” ] at (142, 20, 171, 154) Text: Copy Code-->Perform Script [ “Get Code” ] at (142, 171, 172, 305)		1 Web Viewer Controls Coordinates (184, 20, 602, 1004)

Tab 1: "Functions"			Field Objects ebay Webservice::Result at (362, 81, 604, 473) ebay Webservice::Request at (185, 81, 356, 473) ebay Webservice::DebugMessages at (161, 481, 604, 960)	Text: Get Access Token-->Perform Script [ “Get Access Token” ] at (144, 21, 177, 137) Text: Refresh Access Token-->Perform Script [ “Refresh Token” ] at (144, 149, 177, 304) Text: Query Orders-->Perform Script [ “Query orders” ] at (144, 315, 177, 470)

Web Viewer Controls

Web Viewer Control Properties

Coordinates

Web Address

Object Name:

Layout Name:

ebay Webservice

Additional Properties:

Allow interaction with web viewer content
Display progress bar
Display status messages
Automatically encode URL

Top: 184 pt
Left: 20 pt
Bottom: 602 pt
Right: 1004 pt

Anchoring: Left, Top

Next Script: [Get Code]

Script Name	LoadLogin
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	ebay Webservice
Scripts that use this script
Script Definition
Script Steps	Go to Object [ Object Name: "Login" ] Go to Object [ Object Name: "Web" ] Set Variable [ $scopes; Value:"https://api.ebay.com/oauth/api_scope https://api.ebay.com/oauth/api_scope/sell.marketing https://api.ebay.com/oauth/api_scope/sell.inventory https://api.ebay.com/oauth/api_scope/sell.account https://api.ebay.com/oauth/api_scope/sell.fulfillment" ] Set Variable [ $scopes; Value:Substitute($scopes; Char(13); " ") ] Set Variable [ $scopes; Value:Substitute($scopes; Char(10); " ") ] // Set Variable [ $scopes; Value:Substitute($scopes; " "; "%20") ] Set Variable [ $URL; Value:"https://auth.sandbox.ebay.com/oauth2/authorize?client_id=" & ebay Webservice::Client ID & "&response_type=code&redirect_uri=" & ebay Webservice::Runame & "&scope=" & $scopes ] Set Web Viewer [ Object Name: "web"; URL: $URL ]
Fields used in this script	ebay Webservice::Client ID ebay Webservice::Runame
Scripts used in this script
Layouts used in this script
Tables used in this script	ebay Webservice
Table occurrences used by this script	ebay Webservice
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [LoadLogin]

Next Script: [Get Access Token]

Script Name	Get Code
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	ebay Webservice
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $text; Value:MBS( "WebView.GetPlainText"; "web" ) ] Set Variable [ $text; Value:Trim($text) ] If [ Left ( $text ; 19 ) = "eBay Login Accepted" ] Set Variable [ $code; Value:Trim(Middle($text; 22; Length($text))) ] Set Field [ ebay Webservice::Code; $code ] End If
Fields used in this script	ebay Webservice::Code
Scripts used in this script
Layouts used in this script
Tables used in this script	ebay Webservice
Table occurrences used by this script	ebay Webservice
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Get Code]

Next Script: [Refresh Token]

Script Name	Get Access Token
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	ebay Webservice
Scripts that use this script
Script Definition
Script Steps	#https://developer.ebay.com/api-docs/static/oauth-auth-code-grant-request.html #Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $r; Value:MBS("CURL.SetOptionURL"; $curl; "https://api.sandbox.ebay.com/identity/v1/oauth2/token") ] Set Variable [ $r; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "application/x-www-form-urlencoded") ] Set Variable [ $r; Value:MBS("CURL.SetOptionUsername"; $curl; ebay Webservice::Client ID) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPassword"; $curl; ebay Webservice::Client Secret) ] Set Variable [ $r; Value:MBS("CURL.SetDebugWithData"; $curl; 1) ] Set Variable [ $request; Value:"grant_type=authorization_code&code=" & ebay Webservice::Code & "&redirect_uri=Christian_Schmi-Christia-MBSTes-kbrjfkry" ] Set Variable [ $r; Value:MBS("CURL.SetOptionPostFields"; $curl; $request) ] #RUN now Set Variable [ $r; Value:MBS("CURL.Perform"; $curl) ] #Check result Set Variable [ $json; Value:MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ ebay Webservice::Result; $json ] Set Field [ ebay Webservice::Request; $request ] Set Field [ ebay Webservice::DebugMessages; MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $ResponseCode; Value:MBS( "CURL.GetResponseCode"; $curl ) ] If [ $r = "OK" and $ResponseCode = 200 ] Set Variable [ $access_token; Value:MBS( "JSON.GetPathItem"; $json; "access_token"; 3 ) ] Set Variable [ $expires_in; Value:MBS( "JSON.GetPathItem"; $json; "expires_in"; 3 ) ] Set Variable [ $refresh_token; Value:MBS( "JSON.GetPathItem"; $json; "refresh_token"; 3 ) ] Set Variable [ $refresh_token_expires_in; Value:MBS( "JSON.GetPathItem"; $json; "refresh_token_expires_in"; 3 ) ] Set Variable [ $token_type; Value:MBS( "JSON.GetPathItem"; $json; "token_type"; 3 ) ] Set Field [ ebay Webservice::AccessToken; $access_token ] Set Field [ ebay Webservice::RefreshToken; $refresh_token ] End If #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	ebay Webservice::Client ID ebay Webservice::Client Secret ebay Webservice::Code ebay Webservice::Result ebay Webservice::Request ebay Webservice::DebugMessages ebay Webservice::AccessToken ebay Webservice::RefreshToken
Scripts used in this script
Layouts used in this script
Tables used in this script	ebay Webservice
Table occurrences used by this script	ebay Webservice
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Get Access Token]

Next Script: [Query orders]

Script Name	Refresh Token
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	ebay Webservice
Scripts that use this script
Script Definition
Script Steps	#https://developer.ebay.com/api-docs/static/oauth-auth-code-grant-request.html #Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $r; Value:MBS("CURL.SetOptionURL"; $curl; "https://api.sandbox.ebay.com/identity/v1/oauth2/token") ] Set Variable [ $r; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "application/x-www-form-urlencoded") ] Set Variable [ $r; Value:MBS("CURL.SetOptionUsername"; $curl; ebay Webservice::Client ID) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPassword"; $curl; ebay Webservice::Client Secret) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPostFields"; $curl; "grant_type=refresh_token&refresh_token=" & ebay Webservice::RefreshToken & "&redirect_uri=" & ebay Webservice::Runame) ] Set Variable [ $r; Value:MBS("CURL.SetDebugWithData"; $curl; 1) ] #RUN now Set Variable [ $r; Value:MBS("CURL.Perform"; $curl) ] #Check result Set Variable [ $json; Value:MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ ebay Webservice::Result; $json ] Set Field [ ebay Webservice::DebugMessages; MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $ResponseCode; Value:MBS( "CURL.GetResponseCode"; $curl ) ] If [ $r = "OK" and $ResponseCode = 200 ] Set Variable [ $access_token; Value:MBS( "JSON.GetPathItem"; $json; "access_token"; 3 ) ] Set Variable [ $expires_in; Value:MBS( "JSON.GetPathItem"; $json; "expires_in"; 3 ) ] Set Variable [ $token_type; Value:MBS( "JSON.GetPathItem"; $json; "token_type"; 3 ) ] Set Field [ ebay Webservice::AccessToken; $access_token ] End If #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	ebay Webservice::Client ID ebay Webservice::Client Secret ebay Webservice::RefreshToken ebay Webservice::Runame ebay Webservice::Result ebay Webservice::DebugMessages ebay Webservice::AccessToken
Scripts used in this script
Layouts used in this script
Tables used in this script	ebay Webservice
Table occurrences used by this script	ebay Webservice
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Refresh Token]

Script Name	Query orders
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	ebay Webservice
Scripts that use this script
Script Definition
Script Steps	Go to Object [ Object Name: "Authorization" ] #Start new session Set Variable [ $curl; Value:MBS("CURL.New") ] #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.) Set Variable [ $URL; Value:"https://api.sandbox.ebay.com/sell/fulfillment/v1/order" ] Set Variable [ $r; Value:MBS( "CURL.SetOptionURL"; $curl; $URL) ] Set Variable [ $r; Value:MBS( "CURL.SetOptionHTTPHeader"; $curl; "Accept: application/json"; "Authorization: Bearer " & ebay Webservice::AccessToken) ] // Set Variable [ $r; Value:MBS( "CURL.SetOptionXOAuth2Bearer"; $curl; ebay Webservice::AccessToken ) ] Set Variable [ $r; Value:MBS("CURL.SetDebugWithData"; $curl; 1) ] // Set Variable [ $r; Value:MBS( "CURL.SetupOAuth"; $curl; ebay Webservice::Client ID; ebay Webservice::Client Secret; ebay Webservice::AccessToken; ""; "GET"; $URL) ] #RUN now Set Variable [ $r; Value:MBS("CURL.Perform"; $curl) ] #Check result Set Field [ ebay Webservice::Request; "" ] Set Field [ ebay Webservice::Result; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ ebay Webservice::DebugMessages; MBS("CURL.GetDebugMessages"; $curl) ] #Cleanup Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	ebay Webservice::AccessToken ebay Webservice::Client ID ebay Webservice::Client Secret ebay Webservice::Request ebay Webservice::Result ebay Webservice::DebugMessages
Scripts used in this script
Layouts used in this script
Tables used in this script	ebay Webservice
Table occurrences used by this script	ebay Webservice
Custom Functions used by this script
Custom menu set used by this script

Download example: ebay Webservice

Used functions: