In order to use the Ocelot / Slate integration, there are several setup steps necessary.


A] Installing "Get Queries"


First, you will need to install the "Get Queries" Saved Query inside of Slate so that it can be utilized in Ocelot's integration.  The "Get Queries" Saved Query is an important part of the automatic registration of Saved Queries into Ocelot.


Installing "Get Queries" Saved Query


Start in the Navigation Bar

Click the "Database" item in the "Database" menu.


This will bring up the Database page, where many Slate administrative pages are available.  In the Configurations section, select the "Briefcase Import" link.


Import Query from Briefcase


This will bring up the briefcase page.


Select the area with the hint text "Briefcase ID".  Enter the following briefcase ID into the selected area (copy and paste the following text): 


1e5af487-770f-d97e-2f25-fed85e3a00d4@oce-test



 
Push the "Add to Database" button.

This will import the "Get Queries" query then bring up the "Edit Get Queries" page.


B] Configure the "Get Queries" query
Next we configure the "Get Queries" query so that it can be utilized in the integration with Ocelot.  Configuring requires a few edits of the settings of the "Get Queries" query.


Edit Permissions

From the "Edit Query" page, its permissions settings are edited next.  Find the set of buttons near the upper right corner of the page.


Press the "Edit Permissions" button. This will bring up the "Edit Permissions" dialog.


Press on the "Add Grantee" link.  This will bring up the "Edit Grantee" dialog.
Set the type to "User Token".

The Name, Token, and Permissions fields will appear in the "Edit Grantee" dialog.

Enter "OcelotAPI" in the name field.

Select the web service permission.


Press "Save".

This will return you to the "Edit Permissions" dialog.

The Ocelot Grantee will now be listed.


Press "Save".  This will return you to the "Edit Query" page.



C] Capture Web Service URL


Press the "JSON" link to the right of the "Web Service" label.

This will bring up the "Web Service" dialog.


For "Service Account", select the User Token that we created.


The "URL" field will then appear. Capture the full URL and keep in a safe location.

The full URL will be used when registering the "Get Queries" Query in Ocelot.


Press "Close".  This will return us to the "Edit Query" page. Now we have the Web Service URL that points to the "Get Queries" Query in Slate.