1.
Open the Console Web Application
2.
Register as a HostMy® API User
a.
Register a Valid Email Address with HostMy® API
b.
Retrieve the Emailed Registration Code
c.
Create a HostMy® API User Account using the Emailed Registration Code
d.
Logon to the HostMy® API Console
e.
Logout of the HostMy® API Console
3.
Creating and Retrieving Data
a.
b.
c.
Create an ADMIN and READONLY Access Key
d.
Upload the JSON Product Catalogue
e.
Retrieve the JSON Product Catalogue from Shell Console using CURL
f.
Retrieve CURL Statement URL including Key from API History
g.
Defining a default key to make data Universally Available without Key
h.
Retrieving a single record
4.
Fetching Data using APIs
a.
b.
Compile the FetchDataTutorial Java Program E.g. javac FetchDataTutorial.java
c.
Execute the FetchDataTutorial Java Program E.g. java FetchDataTutorial
d.
e.
Compile the FetchRecordTutorial Java Program E.g. javac FetchRecordTutorial.java
c.
Execute the FetchRecordTutorial Java Program E.g. java FetchRecordTutorial
5.
Maintain a Data Document using APIs
a.
Create new
DaysOfWeek Branch in the existing
/<Your Org>/Live/Sales Hierarchy using the
HostMy® API Console ⇢a1.
Create a new DaysOfWeek Dataset Hierarchy Element on the Sales Scope
a2.
Create a new Version Hierarchy Element on the new DaysOfWeek Dataset
a3.
Create a DayOfWeekAdmin Key with full Read, Write and Delete privileges to the DaysOfWeek Dataset Version
a4.
Review at the Editor Area to see there is no data
b.
Create a new Document against the DaysOfWeek Version Hierarchy Element
b1.
b2.
Compile the CreateDocumentTutorial Java Program E.g. javac CreateDocumentTutorial.java
b3.
View the DaysOfWeek Dataset Version and assign the DayOfWeekAdmin Key. N.B. Copy the TABLE URL and KEY ID for later use
b4.
Execute the CreateDocumentTutorial Java Program E.g. java CreateDocumentTutorial <TABLE URL> <KEY ID>
b4.
Click the Load Button above the Editor Area and note the Week Day Records in the new document
c.
Append New Records to the existing WeekendData.json Document
c1.
c2.
Compile the AppendRecordsTutorial Java Program E.g. javac AppendRecordsTutorial.java
c3.
Execute the AppendRecordsTutorial Java Program E.g. java AppendRecordsTutorial <TABLE URL> <KEY ID>
c4.
Click the Load Button above the Editor Area and note new DaysOfWeek Saturday and Sunday records have been appended to the data
d.
Replace the existing DaysOfWeek Document with an English and German DaysOfWeek Document, using a DELETE and POST Method
d1.
d2.
Compile the ReplaceDocumentTutorial Java Program E.g. javac ReplaceDocumentTutorial.java
d3.
Execute the ReplaceDocumentTutorial Java Program E.g. java ReplaceDocumentTutorial <TABLE URL> <KEY ID>
d4.
Click the Load Button above the Editor Area and note that the DaysOfWeek Document now has English and German entries
e.
Update a record within the DaysOfWeek Document
e1.
e2.
Compile the UpdateRecordTutorial Java Program E.g. javac UpdateRecordTutorial.java
e3.
Execute the UpdateRecordTutorial Java Program E.g. java UpdateRecordTutorial <TABLE URL> <KEY ID> <RECORD ID>
e4.
Click the Load Button above the Editor Area and note that the incorrect Saturday record day_short_de field has been corrected
6.
Access Key Security Controls
7.
URL Alias
HostMy® API