Monkeybread Software - MBS FileMaker Plugin: Magento2 REST API

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

MBS FileMaker Plugin Example Databases

Magento2 REST API

All examples are included with download of MBS FileMaker Plugin.

Magento2 REST API.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
tbl_debugger	6 fields defined, 1 record	tbl_debugger

Fields

Table Name: tbl_debugger - 6 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
MagentoURL	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		tbl_debugger		Token Auth Post SKU Get SKU Put SKU Delete SKU
header	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		tbl_debugger		Token Auth Post SKU Get SKU Put SKU Delete SKU
response	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		tbl_debugger		Post SKU Get SKU Put SKU Delete SKU
token	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		tbl_debugger		Token Auth Post SKU Get SKU Put SKU Delete SKU
Product Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		tbl_debugger		Post SKU Get SKU Put SKU Delete SKU
PEM File	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		tbl_debugger

Layout Objects: tbl_debugger

Regular Fields

Field Name: tbl_debugger::PEM File

Layout Name:

tbl_debugger

Top: 523 pt
Left: 188 pt
Bottom: 545 pt
Right: 441 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: tbl_debugger::MagentoURL

Layout Name:

tbl_debugger

Top: 107 pt
Left: 188 pt
Bottom: 129 pt
Right: 441 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: tbl_debugger::header

Layout Name:

tbl_debugger

Top: 131 pt
Left: 188 pt
Bottom: 271 pt
Right: 1006 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: tbl_debugger::response

Layout Name:

tbl_debugger

Top: 274 pt
Left: 188 pt
Bottom: 454 pt
Right: 1006 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: tbl_debugger::token

Layout Name:

tbl_debugger

Top: 465 pt
Left: 188 pt
Bottom: 487 pt
Right: 441 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: tbl_debugger::Product Name

Layout Name:

tbl_debugger

Top: 489 pt
Left: 188 pt
Bottom: 511 pt
Right: 441 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: Get Token

Layout Name:

tbl_debugger

Top: 581 pt
Left: 188 pt
Bottom: 629 pt
Right: 288 pt

Anchoring: Left, Top

Perform Script [ “Token Auth” ]

Scripts:

Token Auth

Button Properties

Coordinates

Script/Script Step

Type:

Text: Create SKU

Layout Name:

tbl_debugger

Top: 581 pt
Left: 310 pt
Bottom: 629 pt
Right: 410 pt

Anchoring: Left, Top

Perform Script [ “Post SKU” ]

Scripts:

Post SKU

Button Properties

Coordinates

Script/Script Step

Type:

Text: Update SKU

Layout Name:

tbl_debugger

Top: 581 pt
Left: 544 pt
Bottom: 629 pt
Right: 644 pt

Anchoring: Left, Top

Perform Script [ “Put SKU” ]

Scripts:

Put SKU

Button Properties

Coordinates

Script/Script Step

Type:

Text: Delete SKU

Layout Name:

tbl_debugger

Top: 581 pt
Left: 664 pt
Bottom: 629 pt
Right: 764 pt

Anchoring: Left, Top

Perform Script [ “Delete SKU” ]

Scripts:

Delete SKU

Button Properties

Coordinates

Script/Script Step

Type:

Text: Get SKU

Layout Name:

tbl_debugger

Top: 581 pt
Left: 432 pt
Bottom: 629 pt
Right: 532 pt

Anchoring: Left, Top

Perform Script [ “Get SKU” ]

Scripts:

Get SKU

Next Script: [Post SKU]

Script Name	Token Auth
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	tbl_debugger
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $Curl; Value:MBS("CURL.New") ] #Change path to your CACert PEM File. Set Variable [ $CacertPath; Value:"C:\Users\Public\cacert.pem" ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionCAInfo"; $curl; $cacertPath ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 2 ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 1 ) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionVerbose"; $curl; 1) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionURL"; $curl; tbl_debugger::MagentoURL&"/rest/V1/integration/admin/token?username=test&password=a1234567 ") ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: application/json") ] Set Variable [ $Result; Value:MBS("CURL.SetOptionPost"; $curl; 1) ] Set Variable [ $Result; Value:MBS("CURL.Perform"; $curl) ] Set Variable [ $Header; Value:MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $Token; Value: Substitute ( MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ; "\""; "") ] Set Variable [ $Result; Value:MBS("CURL.Cleanup"; $curl) ] Set Field [ tbl_debugger::header; $Header ] Set Field [ tbl_debugger::token; $Token ]
Fields used in this script	tbl_debugger::MagentoURL tbl_debugger::header tbl_debugger::token
Scripts used in this script
Layouts used in this script
Tables used in this script	tbl_debugger
Table occurrences used by this script	tbl_debugger
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Token Auth]

Next Script: [Get SKU]

Script Name	Post SKU
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	tbl_debugger
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $Token; Value:tbl_debugger::token ] Set Variable [ $Curl; Value:MBS("CURL.New") ] #Change path to your CACert PEM File. Set Variable [ $CacertPath; Value:"C:\Users\Public\cacert.pem" ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionCAInfo"; $curl; $cacertPath ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 2 ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 1 ) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionVerbose"; $curl; 1) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionURL"; $curl; tbl_debugger::MagentoURL&"/rest/V1/products") ] Set Variable [ $Result; Value:MBS("CURL.SetOptionPost"; $curl; 1) ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: application/json" ; "Authorization: Bearer " & $Token ; "Cache-Control: no-cache" ) ] Set Variable [ $Body; Value:" { \"product\": { \"sku\": \""&tbl_debugger::Product Name&"\", \"name\": \" "&tbl_debugger::Product Name&" \", \"price\": 30.00, \"status\": 1, \"type_id\": \"simple\", \"attribute_set_id\":4, \"weight\": 1 } } " ] Set Variable [ $result; Value:MBS("CURL.SetOptionPostFields"; $curl; $Body ; "UTF-8") ] Set Variable [ $Result; Value:MBS("CURL.Perform"; $curl) ] Set Variable [ $Header; Value:MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $Response; Value:MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ] Set Variable [ $Result; Value:MBS("CURL.Cleanup"; $curl) ] Set Field [ tbl_debugger::header; $Header ] Set Field [ tbl_debugger::response; $Response ]
Fields used in this script	tbl_debugger::token tbl_debugger::MagentoURL tbl_debugger::Product Name tbl_debugger::header tbl_debugger::response
Scripts used in this script
Layouts used in this script
Tables used in this script	tbl_debugger
Table occurrences used by this script	tbl_debugger
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Post SKU]

Next Script: [Put SKU]

Script Name	Get SKU
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	tbl_debugger
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $Token; Value:tbl_debugger::token ] Set Variable [ $Curl; Value:MBS("CURL.New") ] #Change path to your CACert PEM File. Set Variable [ $CacertPath; Value:"C:\Users\Public\cacert.pem" ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionCAInfo"; $curl; $cacertPath ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 2 ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 1 ) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionVerbose"; $curl; 1) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionURL"; $curl; tbl_debugger::MagentoURL&"/rest/V1/products/"&tbl_debugger::Product Name) ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Authorization: Bearer " & $Token ) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionGet"; $curl; 1) ] Set Variable [ $Result; Value:MBS("CURL.Perform"; $curl) ] Set Variable [ $Header; Value:MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $Response; Value:MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ] Set Variable [ $Result; Value:MBS("CURL.Cleanup"; $curl) ] Set Field [ tbl_debugger::header; $Header ] Set Field [ tbl_debugger::response; $Response ]
Fields used in this script	tbl_debugger::token tbl_debugger::MagentoURL tbl_debugger::Product Name tbl_debugger::header tbl_debugger::response
Scripts used in this script
Layouts used in this script
Tables used in this script	tbl_debugger
Table occurrences used by this script	tbl_debugger
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Get SKU]

Next Script: [Delete SKU]

Script Name	Put SKU
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	tbl_debugger
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $Token; Value:tbl_debugger::token ] Set Variable [ $Curl; Value:MBS("CURL.New") ] #Change path to your CACert PEM File. Set Variable [ $CacertPath; Value:"C:\Users\Public\cacert.pem" ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionCAInfo"; $curl; $cacertPath ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 2 ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 1 ) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionVerbose"; $curl; 1) ] #PUT item Set Variable [ $Result; Value:MBS("CURL.SetOptionURL"; $curl; tbl_debugger::MagentoURL&"/rest/V1/products/"&tbl_debugger::Product Name) ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: application/json" ; "Authorization: Bearer "&$token&"" ) ] Set Variable [ $result; Value:MBS("CURL.SetOptionUpload"; $curl; 1) ] Set Variable [ $Body; Value:" { \"product\": { \"sku\": \""&tbl_debugger::Product Name&"\", \"name\": \""&tbl_debugger::Product Name&"\", \"price\": 35.01, \"status\": 1, \"type_id\": \"simple\", \"attribute_set_id\":4, \"weight\": 1 } } " ] Set Variable [ $result; Value:MBS("CURL.SetInputText"; $curl; $Body ) ] Set Variable [ $Result; Value:MBS("CURL.Perform"; $curl) ] Set Variable [ $Header; Value:MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $Response; Value:MBS("String.ReplaceNewline"; MBS("CURL.GetResultAsText"; $curl);1) ] Set Variable [ $Result; Value:MBS("CURL.Cleanup"; $curl) ] Set Field [ tbl_debugger::header; $Header ] Set Field [ tbl_debugger::response; $Response ]
Fields used in this script	tbl_debugger::token tbl_debugger::MagentoURL tbl_debugger::Product Name tbl_debugger::header tbl_debugger::response
Scripts used in this script
Layouts used in this script
Tables used in this script	tbl_debugger
Table occurrences used by this script	tbl_debugger
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Put SKU]

Script Name	Delete SKU
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script	tbl_debugger
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $Token; Value:tbl_debugger::token ] Set Variable [ $Curl; Value:MBS("CURL.New") ] #Change path to your CACert PEM File. Set Variable [ $CacertPath; Value:"C:\Users\Public\cacert.pem" ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionCAInfo"; $curl; $cacertPath ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyHost"; $curl; 2 ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionSSLVerifyPeer"; $curl; 1 ) ] Set Variable [ $Result; Value:MBS("CURL.SetOptionVerbose"; $curl; 1) ] #Delete SKU Set Variable [ $Result; Value:MBS("CURL.SetOptionURL"; $curl; tbl_debugger::MagentoURL&"/rest/V1/products/"&tbl_debugger::Product Name) ] Set Variable [ $result; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "Content-Type: application/json" ; "Authorization: Bearer "&$Token&"" ) ] Set Variable [ $Result; Value:MBS( "CURL.SetOptionCustomRequest"; $curl; "DELETE" ) ] Set Variable [ $Result; Value:MBS("CURL.Perform"; $curl) ] Set Variable [ $Header; Value:MBS("CURL.GetDebugMessages"; $curl) ] Set Variable [ $Response; Value:MBS("CURL.GetResultAsText"; $curl) ] Set Variable [ $Result; Value:MBS("CURL.Cleanup"; $curl) ] Set Field [ tbl_debugger::header; $Header ] Set Field [ tbl_debugger::response; $Response ]
Fields used in this script	tbl_debugger::token tbl_debugger::MagentoURL tbl_debugger::Product Name tbl_debugger::header tbl_debugger::response
Scripts used in this script
Layouts used in this script
Tables used in this script	tbl_debugger
Table occurrences used by this script	tbl_debugger
Custom Functions used by this script
Custom menu set used by this script

Download example: Magento2 REST API

Used functions: