<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.goldenretrieverapp.com/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Dave</id>
	<title>Golden Retriever Wiki - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.goldenretrieverapp.com/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Dave"/>
	<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php/Special:Contributions/Dave"/>
	<updated>2026-04-14T14:42:55Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.45.1</generator>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=Account_Settings&amp;diff=454</id>
		<title>Account Settings</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=Account_Settings&amp;diff=454"/>
		<updated>2026-03-26T17:47:18Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Main_Page|Main Page]]&lt;br /&gt;
===Account Settings===&lt;br /&gt;
In the admin portal, each User can manage their personal settings.&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[File:Screenshot 2026-03-26 113338.png|Thumb|None|Account Settings]]&lt;br /&gt;
&lt;br /&gt;
====User Name====&lt;br /&gt;
Your current user name is shown here. To save changes click the &amp;lt;code&amp;gt;Save changes&amp;lt;/code&amp;gt; button.&lt;br /&gt;
====Email Address====&lt;br /&gt;
Your current email address is shown here. To save changes click the &amp;lt;code&amp;gt;Save changes&amp;lt;/code&amp;gt; button.&lt;br /&gt;
====Change Password====&lt;br /&gt;
To change your password enter it into the &#039;&#039;New passphrase&#039;&#039; and &#039;&#039;Confirm new passphrase&#039;&#039; boxes and click the &amp;lt;code&amp;gt;Update passphrase&amp;lt;/code&amp;gt; button.&lt;br /&gt;
====Delete Portal Account====&lt;br /&gt;
Each user may delete their online account access at any time. This will not delete the Golden Retriever account, just the specific user&#039;s ability to log into the web portal. Once you delete your web portal profile, there is no going back. Please be certain.&lt;br /&gt;
====Activating Sleep Mode====&lt;br /&gt;
Golden Retriever allows accounts to be placed in &#039;&#039;sleep mode&#039;&#039; in cases where accounts are only required on a seasonal basis. While in sleep mode a minimal charge is billed monthly to retain full access to the admin portal. During this time the mobile app will have no access to any dictionary tied to the account.&lt;br /&gt;
*A minimal amount will be charged each month to maintain data storage and retain all account dictionaries, databases and settings - &#039;&#039;there will be no monthly charge for any active license keys&#039;&#039;&lt;br /&gt;
*All data will remain accessible (view, edit, download, delete)&lt;br /&gt;
*Manage license keys - set up new devices as necessary in advance of resuming your account&lt;br /&gt;
*Build new or edict current dictionaries&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Viewing Status=====&lt;br /&gt;
From the main Admin Portal menu on the top left menu, select &#039;&#039;sleep status&#039;&#039;. Here you will see any accounts tied to your administrator account and their current status.&lt;br /&gt;
[[File:Screenshot 2026-03-26 113817.png|none]]&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
To change the status of the account simply click on the &#039;No&#039; or &#039;Yes&#039;. &lt;br /&gt;
*YES - account is in sleep mode&lt;br /&gt;
*NO - account is active and mobile app will collect data&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:Screenshot 2026-03-26 114221.png|none]]&lt;br /&gt;
Billing will automatically be adjusted for your next billing cycle.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
 &#039;&#039;If you are a paying customer and are wanting to delete your entire Golden Retriever account please send an email to info@goldenretrieverapp.com requesting your account be closed.&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_114221.png&amp;diff=453</id>
		<title>File:Screenshot 2026-03-26 114221.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_114221.png&amp;diff=453"/>
		<updated>2026-03-26T17:44:04Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Sleep mode on off&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_113817.png&amp;diff=452</id>
		<title>File:Screenshot 2026-03-26 113817.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_113817.png&amp;diff=452"/>
		<updated>2026-03-26T17:39:39Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Sleep mode&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_113338.png&amp;diff=451</id>
		<title>File:Screenshot 2026-03-26 113338.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_113338.png&amp;diff=451"/>
		<updated>2026-03-26T17:34:23Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Account settings&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=Admin_Portal&amp;diff=450</id>
		<title>Admin Portal</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=Admin_Portal&amp;diff=450"/>
		<updated>2026-03-26T16:44:08Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;===Admin Portal===&lt;br /&gt;
The Admin Portal (https://goldenretrieverapp.com/admin) is the place for all account administration and data management. &lt;br /&gt;
&lt;br /&gt;
[[File:Screenshot 2026-03-26 103241.png|none|frame|Caption:https://goldenretrieverapp.com/admin]]&lt;br /&gt;
&lt;br /&gt;
Here you can:&lt;br /&gt;
* [[Data_Management|View/Edit/Download Collected Data]]&lt;br /&gt;
* [[Share_Maps|Share Maps and Data]]&lt;br /&gt;
* Get to this documentation wiki&lt;br /&gt;
* [[License_Keys|Purchase/Cancel License Keys]]&lt;br /&gt;
* [[Update_Sleep_Status|Update Sleep Status]]&lt;br /&gt;
* [[Update_Payment_Settings|Update Payment Settings]]&lt;br /&gt;
* [[Export_to_ArcGIS|Manage ArcGIS Settings]]&lt;br /&gt;
* [[Manage_Users|Add/Edit/Delete User Accounts]]&lt;br /&gt;
* [[Manage_Users|Manage Account Settings]]&lt;br /&gt;
* [[Upload_Data|Upload Data Directly Into Databases]]&lt;br /&gt;
* [[Dictionary_Creator|Create/Edit/Delete Collection Dictionaries]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Admin Portal access is not only for your account administrator(s) but also for any user who needs to access inspection records. Users of your account will see only the dictionaries which they have been given access to.&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_103241.png&amp;diff=449</id>
		<title>File:Screenshot 2026-03-26 103241.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2026-03-26_103241.png&amp;diff=449"/>
		<updated>2026-03-26T16:43:05Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Admin menu&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=Dictionary_Creator&amp;diff=448</id>
		<title>Dictionary Creator</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=Dictionary_Creator&amp;diff=448"/>
		<updated>2025-09-02T13:53:25Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Upload Supplied Data */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Main_Page|Main Page]]&lt;br /&gt;
__FORCETOC__&lt;br /&gt;
 Note: This page is under development and as such is not yet complete.&lt;br /&gt;
&amp;lt;strong&amp;gt;Dictionary Creator&amp;lt;/strong&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;Collection dictionaries are made by account administrators from the &#039;&#039;Admin Portal&#039;&#039; in the &#039;&#039;Dictionary Creator&#039;&#039; main menu item. Here you can create, view and edit what data is collected and how it is collected.&lt;br /&gt;
[[File:DC_MainPage.png|thumb|upright=3|none]]&lt;br /&gt;
When you first navigate to the Dictionary Creator window you will see a drop-down menu which contains all of your collection dictionaries as well as an empty collection dictionary form. You can either start a new dictionary from scratch by typing in a name and adding new fields or modify an existing one by selecting it from the list &#039;&#039;&#039;(selecting the option of &amp;quot;-----&amp;quot; from the drop-down list will reset the Dictionary Creator for you)&#039;&#039;&#039;. &lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=Dictionary Settings=&lt;br /&gt;
[[File:DC_DictOptions.png|thumb|none]]&lt;br /&gt;
===Saving Changes===&lt;br /&gt;
When you load an existing dictionary you will have both a &amp;lt;code&amp;gt;Duplicate/Create New&amp;lt;/code&amp;gt; button and a &amp;lt;code&amp;gt;Save Changes&amp;lt;/code&amp;gt; button. The &#039;&#039;Duplicate/Create New&#039;&#039; works like &#039;&#039;save as&#039;&#039; and will create a new dictionary with whatever name you have entered in the &#039;&#039;Dictionary Name&#039;&#039; box. &#039;&#039;Save Changes&#039;&#039; will save your changes to the existing dictionary.&lt;br /&gt;
[[File:DC_UpdateOrNew.png|thumb|none]]&lt;br /&gt;
If you have started from the blank template click the &amp;lt;code&amp;gt;Create New Dictionary&amp;lt;/code&amp;gt; button after assigning a name (and sub-folder if desired) to create the dictionary.&lt;br /&gt;
[[File:DC_CreateNew.png|thumb|none]]&lt;br /&gt;
===Dictionary Name===&lt;br /&gt;
Each dictionary needs a name. It is suggested to name each dictionary with the customer name and year. Where multiple dictionaries are used for the same customer those line or circuit names can be used as well.&lt;br /&gt;
===Sub Folder===&lt;br /&gt;
Sub Folders are a great way to organize your collection dictionaries in the mobile app. This is optional and if not set here the dictionary will be shown in the main dictionary directory.&lt;br /&gt;
===Dictionary Order===&lt;br /&gt;
By default all dictionaries will be shown in the mobile app in alphabetical order. Normally this works but if you wish to specify the order manually the number you enter here will dictate the order shown when selecting a dictionary in the app.&lt;br /&gt;
===Default Search Field===&lt;br /&gt;
The mobile app user has an option to search the existing collected records right from the device. While any field can be used for the search, the administrator has the option to set the default field for the search. To make things more efficient the most common search field can be set here (i.e. Pole Number).&lt;br /&gt;
[[File:DC DictOptions.png|thumb|none]]&lt;br /&gt;
 &lt;br /&gt;
A second use of this setting is for the map labels on the mobile app. Common fields used for this are the pole number or circuit number. &lt;br /&gt;
&lt;br /&gt;
If this setting is left blank (in the Dictionary Creator) simple map pins will be used.&lt;br /&gt;
[[File:AppMapStyles.jpg|thumb|none]]&lt;br /&gt;
&lt;br /&gt;
 It is possible for the mobile app user to temporarily change the label by using the search function for the field they wish to see on the map labels. The labels will reflect the most recent field used for the search during the current session. The next time the user opens the dictionary the labels will revert back to the default set in the Dictionary Creator.&lt;br /&gt;
&lt;br /&gt;
===Field for Device Map===&lt;br /&gt;
In the [[https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Databases_Summary_Page Databases Summary Page]] it is possible to view on a map, the most recent record&#039;s GPS location for each device. By setting an inspector name instead of the id of the device, any change in phone/tablet will not effect this maps functionality.&lt;br /&gt;
===Duplicate Records Allowed===&lt;br /&gt;
By default saving changes as duplicate records is allowed. This is to avoid data loss due to editing mistakes. However, this does create more administration work later on to edit and consolidate these duplicates. By selecting this option no duplicates will be allowed by the mobile app for map markers once they turn from red to green. This is when working from a map of data supplied by the utility as this is location specific (Pole Number, etc makes no difference.&lt;br /&gt;
===Photo Required===&lt;br /&gt;
If a photo is required for every inspection record select this check-box to force a photo before the app will save a new record.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=Dictionary Fields=&lt;br /&gt;
[[File:AddField.png|none]]&lt;br /&gt;
==Default Dictionary Fields==&lt;br /&gt;
Golden Retriever uses several fields for every dictionary which are automatically completed by the system. These fields are shown in the Database view. They are:&lt;br /&gt;
*RecordNo - the record number assigned by the database when the record is uploaded&lt;br /&gt;
*Latitude - the latitude of the GPS location&lt;br /&gt;
*Longitude - the longitude of the GPS location&lt;br /&gt;
*Date - An automatic timestamp when the record is saved in the mobile app&lt;br /&gt;
*Device - The unique device id as supplied by the mobile device.&lt;br /&gt;
[[File:DC_AutoFields.png|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Optional Dictionary Fields==&lt;br /&gt;
In addition to the basic fields, you can define as many other fields as you wish. These custom fields will all be placed after the automatic fields.&lt;br /&gt;
===Add Field===&lt;br /&gt;
To add a new dictionary field click on the green &amp;lt;code&amp;gt;Add field here&amp;lt;/code&amp;gt; button at the location you wish to add the field.&lt;br /&gt;
[[File:AddField.png|none]]&lt;br /&gt;
&lt;br /&gt;
===Move Field===&lt;br /&gt;
The fields will appear on the mobile app collection form according to the order they are in the Dictionary Creator. They can be moved by entering the desired position number in the box to the right of the green field box and clicking the &amp;lt;code&amp;gt;Move&amp;lt;/code&amp;gt; button. The Dictionary Creator will automatically adjust all subsequent fields so there is no worry of overwriting a field.&lt;br /&gt;
[[File:DC_MoveField.png|thumb|none]]&lt;br /&gt;
&lt;br /&gt;
===Delete Field===&lt;br /&gt;
To delete a field click on the red &#039;&#039;&#039;X&#039;&#039;&#039; by the field. You will be asked to confirm before deletion. Once this is done it is final; there is no &#039;undo&#039; option.&lt;br /&gt;
&lt;br /&gt;
===Define Fields===&lt;br /&gt;
Several data collection field types are available. Once you add a new field, you first need to select the field type from the drop-down list. &lt;br /&gt;
[[File:DC_NewField.png|none]]&lt;br /&gt;
====Define Field Type====&lt;br /&gt;
The first step is to select the field type from the dropdown list.&lt;br /&gt;
====Field Name====&lt;br /&gt;
This is the name which will be visible in the collection form on the mobile app. It will also be the column name in the online spreadsheet.&lt;br /&gt;
====Field Description====&lt;br /&gt;
This field description can be used to give more information for the end user (Mobile App user) as well as for anyone with a shared map link. This is an optional field attribute and may not be useful for all fields.&lt;br /&gt;
[[File:DC_FieldNaming.png|none]]&lt;br /&gt;
The field types are grouped into categories and are as follows:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Classic Fields=====&lt;br /&gt;
======Comment======&lt;br /&gt;
This is a text field which always defaults to a blank value. Instructions may be added which show up when entering a new record (on the mobile app). This text does not show up in the final data.&lt;br /&gt;
[[File:Field_Comment.png|none]]&lt;br /&gt;
&lt;br /&gt;
======Picklist======&lt;br /&gt;
A drop-down list of values for the user to select. Click the &amp;lt;code&amp;gt;Add Picklist Option&amp;lt;/code&amp;gt; as many times as necessary and type in the options you would like available to your users. Any unneeded picklist options may be deleted by clicking the red X to the right of the picklist option. &lt;br /&gt;
[[File:Field_Picklist.png|none]]&lt;br /&gt;
By default, the mobile app users may only select from the list. If desired you may allow custom entries by specifying a &#039;&#039;Length of Custom Entries&#039;&#039; value. The length value represents the maximum amount of characters they can use when creating a new picklist options. User-added picklist itmes will be recurring on the user&#039;s device (until they next refresh their dictionaries) but &#039;&#039;will not&#039;&#039; transfer to the dictionary or other devices. &lt;br /&gt;
[[File:Field_Picklist_useredit.jpg|thumb|none]]&lt;br /&gt;
 Be careful what you wish for when opening up picklists to users. Whatever is inputted by the user will end up in the data. These entries will very easily include typo&#039;s and are bound to differ from user to user.&lt;br /&gt;
&lt;br /&gt;
======Text======&lt;br /&gt;
This is one of the most common field types to use and while this is a &#039;simple text&#039; field, there are several options available and some must be defined before your dictionary can be saved.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Default Value&amp;lt;/strong&amp;gt; - You may set a default value here. As users are entering records, the previous value will be transferred to the new record unless the &#039;&#039;Force Default&#039;&#039; checkbox is selected.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Max Length&amp;lt;/strong&amp;gt; - A maximum length must be set. A standard length length for text is 15 but can be shorter or longer. For a numeric field this number is how many characters are left of the decimal - the &#039;&#039;Number of Decimals Allowed&#039;&#039; setting will add to the maximum length.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Min Length&amp;lt;/strong&amp;gt; - An optional minimum length may also be set here.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Max Value&amp;lt;/strong&amp;gt; - A maximum value may be specified for numeric fields. For example, you may wish to disallow any pole year greater than the current year to minimize data entry errors.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Min Value&amp;lt;/strong&amp;gt; - A minimum value may be specified for numeric fields. For example, you may wish to disallow any pole year older than 1940.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Number of Decimals Allowed&amp;lt;/strong&amp;gt; - For numeric fields you may set the maximum number of decimals allowed. This is optional and may be left blank.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Alphanumeric&amp;lt;/strong&amp;gt; - You can set this to &#039;&#039;All Characters&#039;&#039; (including special characters), &#039;&#039;Letters and Numbers&#039;&#039;, &#039;&#039;Numbers Only&#039;&#039; or &#039;&#039;Letters Only&#039;&#039;. &lt;br /&gt;
*&amp;lt;strong&amp;gt;GPS Data&amp;lt;/strong&amp;gt; - In addition to the default GPS fields which Golden Retriever automatically collects you may specify GPS coordinate fields for navigation. When defining these fields set this option to either &#039;&#039;longitude&#039;&#039; or &#039;&#039;latitude&#039;&#039;. Without defining this option Golden Retriever will not recognize this field as containing GPS coordinates and will not plot the pole locations on the navigation map.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Capitalize&amp;lt;/strong&amp;gt; - When an &#039;&#039;Alphanumeric&#039;&#039; option containing letters has been selected you may choose to have Golden Retriever automatically capitalize either the first letter of each word or all letters. This avoids inconsistent data in the final data. This option is not shown when &#039;&#039;Numbers Only&#039;&#039; is the selected &#039;&#039;Alphanumeric&#039;&#039; option.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Increment&amp;lt;/strong&amp;gt; - When you have selected &#039;&#039;Numbers Only&#039;&#039; as the &#039;&#039;Alphanumeric&#039;&#039; option you may set this number to increment up or increment down. This option is not shown when &#039;&#039;Numbers Only&#039;&#039; is not the selected &#039;&#039;Alphanumeric&#039;&#039; option.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Barcode Scanning&amp;lt;/strong&amp;gt; - Select this option to enable barcode scanning as the input method for this field.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Make This A TimeStamp&amp;lt;/strong&amp;gt; - &lt;br /&gt;
*&amp;lt;strong&amp;gt;Always Locked&amp;lt;/strong&amp;gt; - This prevents this field from being edited by the user.&lt;br /&gt;
[[File:Field_Text.png|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Modern Fields=====&lt;br /&gt;
======Attachment======&lt;br /&gt;
With Golden Retriever you are able to add pdf documents to the collection dictionary. This can give the mobile app user quick access to Safety Data Sheets, Product Labels, Instructions, etc. through a clickable link from within the collection record.&lt;br /&gt;
======Date Picker======&lt;br /&gt;
The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.&lt;br /&gt;
======Formula======&lt;br /&gt;
With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format &amp;lt;code&amp;gt;&amp;quot;~~Field Name~~&amp;quot;&amp;lt;/code&amp;gt; (The quotes are important as ~~Field Name~~ will be replaced by the current value of the field).&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Operator Precedence&lt;br /&gt;
|-&lt;br /&gt;
! Operator !! Associativity !! Description&lt;br /&gt;
|-&lt;br /&gt;
| (...) || None || Grouping&lt;br /&gt;
|-&lt;br /&gt;
| f(), x.y, a[i] || Left || Function call, property access, array indexing&lt;br /&gt;
|-&lt;br /&gt;
| ! || Left || Factorial&lt;br /&gt;
|-&lt;br /&gt;
| ^ || Right || Exponentiation&lt;br /&gt;
|-&lt;br /&gt;
| +, -, not, sqrt, etc. || Right || Unary prefix operators (see below for the full list)&lt;br /&gt;
|-&lt;br /&gt;
| *, /, % || Left || Multiplication, division, remainder&lt;br /&gt;
|-&lt;br /&gt;
| +, - || Left || Addition, subtraction&lt;br /&gt;
|-&lt;br /&gt;
| ==, !=, &amp;gt;=, &amp;lt;=, &amp;gt;, &amp;lt;, in || Left || Equals, not equals, etc. &amp;quot;in&amp;quot; means &amp;quot;is the left operand included in the right array operand?&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
| and || Left || Logical AND&lt;br /&gt;
|-&lt;br /&gt;
| or || Left || Logical OR&lt;br /&gt;
|-&lt;br /&gt;
| x ? y : z || Right || Ternary conditional (if x then y else z)&lt;br /&gt;
|-&lt;br /&gt;
| = || Right || Variable assignment&lt;br /&gt;
|-&lt;br /&gt;
| ; || Left || Expression separator&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Unary operators&lt;br /&gt;
|-&lt;br /&gt;
! Operator !! Description&lt;br /&gt;
|-&lt;br /&gt;
| -x || Negation&lt;br /&gt;
|-&lt;br /&gt;
| +x || Unary plus. This converts it&#039;s operand to a number, but has no other effect.&lt;br /&gt;
|-&lt;br /&gt;
| x! || Factorial (x * (x-1) * (x-2) * … * 2 * 1). gamma(x + 1) for non-integers.&lt;br /&gt;
|-&lt;br /&gt;
|abs x || Absolute value (magnitude) of x&lt;br /&gt;
|-&lt;br /&gt;
| acos x || Arc cosine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| acosh x || Hyperbolic arc cosine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| asin x || Arc sine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| asinh x || Hyperbolic arc sine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| atan x || Arc tangent of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
|atanh x || Hyperbolic arc tangent of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| cbrt x || Cube root of x&lt;br /&gt;
|-&lt;br /&gt;
| ceil x || Ceiling of x — the smallest integer that’s &amp;gt;= x&lt;br /&gt;
|-&lt;br /&gt;
| cos x || Cosine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| cosh x || Hyperbolic cosine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| exp x || e^x (exponential/antilogarithm function with base e)&lt;br /&gt;
|-&lt;br /&gt;
| expm1 x || e^x - 1&lt;br /&gt;
|-&lt;br /&gt;
| floor x || Floor of x — the largest integer that’s &amp;lt;= x&lt;br /&gt;
|-&lt;br /&gt;
| length x || String or array length of x&lt;br /&gt;
|-&lt;br /&gt;
| ln x || Natural logarithm of x&lt;br /&gt;
|-&lt;br /&gt;
| log x || Natural logarithm of x (synonym for ln, not base-10)&lt;br /&gt;
|-&lt;br /&gt;
| log10 x || Base-10 logarithm of x&lt;br /&gt;
|-&lt;br /&gt;
| log2 x || Base-2 logarithm of x&lt;br /&gt;
|-&lt;br /&gt;
| log1p x || Natural logarithm of (1 + x)&lt;br /&gt;
|-&lt;br /&gt;
| not x || Logical NOT operator&lt;br /&gt;
|-&lt;br /&gt;
| round x || X, rounded to the nearest integer, using &amp;quot;grade-school rounding&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
| sign x || Sign of x (-1, 0, or 1 for negative, zero, or positive respectively)&lt;br /&gt;
|-&lt;br /&gt;
| sin x || Sine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| sinh x || Hyperbolic sine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| sqrt x || Square root of x. Result is NaN (Not a Number) if x is negative.&lt;br /&gt;
|-&lt;br /&gt;
| tan x || Tangent of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| tanh x || Hyperbolic tangent of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| trunc x || Integral part of a X, looks like floor(x) unless for negative number&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Pre-defined functions&lt;br /&gt;
|-&lt;br /&gt;
! Function !! Description&lt;br /&gt;
|-&lt;br /&gt;
| random(n) || Get a random number in the range [0, n). If n is zero, or not provided, it defaults to 1.&lt;br /&gt;
|-&lt;br /&gt;
| fac(n) || n! (factorial of n: &amp;quot;n * (n-1) * (n-2) * … * 2 * 1&amp;quot;) Deprecated. Use the ! operator instead.&lt;br /&gt;
|-&lt;br /&gt;
| min(a,b,…) || Get the smallest (minimum) number in the list.&lt;br /&gt;
|-&lt;br /&gt;
| max(a,b,…) || Get the largest (maximum) number in the list.&lt;br /&gt;
|-&lt;br /&gt;
| hypot(a,b) || Hypotenuse, i.e. the square root of the sum of squares of its arguments.&lt;br /&gt;
|-&lt;br /&gt;
| pyt(a, b) || Alias for hypot.&lt;br /&gt;
|-&lt;br /&gt;
| pow(x, y) || Equivalent to x^y&lt;br /&gt;
|-&lt;br /&gt;
| atan2(y, x) || Arc tangent of x/y. i.e. the angle between (0, 0) and (x, y) in radians.&lt;br /&gt;
|-&lt;br /&gt;
| roundTo(x, n) || Rounds x to n places after the decimal point.&lt;br /&gt;
|-&lt;br /&gt;
| map(f, a) || Array map: Pass each element of &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; the function &amp;lt;code&amp;gt;f&amp;lt;/code&amp;gt;, and return an array of the results.&lt;br /&gt;
|-&lt;br /&gt;
| fold(f, y, a) || Array fold: Fold/reduce array &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; into a single value, &amp;lt;code&amp;gt;y&amp;lt;/code&amp;gt; by setting &amp;lt;code&amp;gt;y = f(y, x, index)&amp;lt;/code&amp;gt; for each element &amp;lt;code&amp;gt;x&amp;lt;/code&amp;gt; of the array.&lt;br /&gt;
|-&lt;br /&gt;
| filter(f, a) || Array filter: Return an array containing only the values from &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; where &amp;lt;code&amp;gt;f(x, index)&amp;lt;/code&amp;gt; is &amp;lt;code&amp;gt;true&amp;lt;/code&amp;gt;.&lt;br /&gt;
|-&lt;br /&gt;
| indexOf(x, a) || Return the first index of string or array &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; matching the value &amp;lt;code&amp;gt;x&amp;lt;/code&amp;gt;, or &amp;lt;code&amp;gt;-1&amp;lt;/code&amp;gt; if not found.&lt;br /&gt;
|-&lt;br /&gt;
| join(sep, a) || Concatenate the elements of &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt;, separated by &amp;lt;code&amp;gt;sep&amp;lt;/code&amp;gt;.&lt;br /&gt;
|-&lt;br /&gt;
| if(c, a, b) || Function form of c ? a : b. Note: This always evaluates both &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; and &amp;lt;code&amp;gt;b&amp;lt;/code&amp;gt;, regardless of whether &amp;lt;code&amp;gt;c&amp;lt;/code&amp;gt; is true or not. Use &amp;lt;code&amp;gt;c ? a : b&amp;lt;/code&amp;gt; instead if there are side effects, or if evaluating the branches could be expensive.&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Constants&lt;br /&gt;
|-&lt;br /&gt;
! Constant !! Description&lt;br /&gt;
|-&lt;br /&gt;
| E || The value of E &lt;br /&gt;
|-&lt;br /&gt;
| PI || The value of PI&lt;br /&gt;
|-&lt;br /&gt;
| true || Logical true value&lt;br /&gt;
|-&lt;br /&gt;
| false || Logical false value&lt;br /&gt;
|}&lt;br /&gt;
&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
======Picklist - Multiple Selection======&lt;br /&gt;
A multiple-selection picklist allows for multiple choices. This is used for dictionary fields where you need to record multiple things, if they exist. This data is stored in a text field similar to a notes field and &#039;&#039;can not&#039;&#039; be used for any show/hide rules.&lt;br /&gt;
======Signature======&lt;br /&gt;
The signature field allows for signature collection using the device&#039;s touchscreen. This is most useful when customizing a collection dictionary as for &#039;&#039;Tailgate safety meetings&#039;&#039; and for other administrative tasks. Due to crews being spread out it can be difficult to distribute forms to the crews and to receive the completed forms back. Golden Retriever can be used as a tool to aid in this by creating specific dictionaries.&lt;br /&gt;
======Spacer======&lt;br /&gt;
The spacer is not a data field but a horizontal line which is displayed in the mobile app to visually separate different categories of fields in the collection form. Use of this is completely voluntary.&lt;br /&gt;
======Weather======&lt;br /&gt;
When a user taps this field in the mobile app, while conducting the inspection, the current weather conditions will be recorded in the inspection record. Golden Retriever is also often used by vegetation control companies to record their herbicide mixing and application - in which weather plays a large role.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Calculator Fields=====&lt;br /&gt;
Golden Retriever has two pole strength calculator fields available. One based on the RUS Tables and one on the ANSI remaining strength tables. These can be used by field personnel to help determine pole integrity. Both calculator fields allow the author of the dictionary to set fields to pull data from as well as fields to record the results.&lt;br /&gt;
======RUS Deduction - RUS Tables======&lt;br /&gt;
======Strength Calc - ANSI Tables======&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Golden Retriever has remaining strength calculations for symmetrical decay (internal and external) based on the ANSI tables. This field can be set up to pull information from other fields as well as record all data used for the calculations in a comment or text field. The image below shows assigned fields for most of the required information.&lt;br /&gt;
[[File:Field_StrCalc.png|none]]&lt;br /&gt;
Any information not automatically imported into the calculation will need to be added when the calculation popup is shown. Once the user taps the &amp;lt;code&amp;gt;CALCULATE&amp;lt;/code&amp;gt; button the remaining strength values are recorded into the &#039;&#039;Remaining Strength&#039;&#039; field as well as the data used for the calculation into an assigned field.&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
| [[File:Field_StrCalc_Calc.jpg|thumb|none]] || [[File:Field_StrCalc_Record.jpg|thumb|none]]&lt;br /&gt;
|}&lt;br /&gt;
&amp;lt;br&amp;gt;This information can be accessed later by engineering staff either through the Admin Portal or from downloaded data.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&#039;&#039;&#039;Online View&#039;&#039;&#039;&lt;br /&gt;
[[File:StregthCalc_OnlineData.png|none|border]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Spreadsheet View&#039;&#039;&#039;&lt;br /&gt;
[[File:StrengthCalc_Data.png|none|border]]&lt;br /&gt;
&lt;br /&gt;
=====Monitoring Fields=====&lt;br /&gt;
======Altered Data======&lt;br /&gt;
This is a hidden field from the mobile app user and will record any changes made to the original utility supplied data (as seen by the app users in the map or online search function).&lt;br /&gt;
======Custom GPS======&lt;br /&gt;
Normally, if the mobile device is unable to obtain a GPS lock the user will be presented with a pop-up stating &#039;&#039;Could not get a GPS lock. Do you wish to wait?&#039;&#039;. With this field, which is hidden from the collection screen, the user will be given the option to manually enter the GPS coordinates in addition to waiting.&lt;br /&gt;
======Elevation======&lt;br /&gt;
Elevation is a hidden field (hidden from the mobile app user) and is automatically populated during the inspection. It can be set to Metric (metres) or Imperial (feet).&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Utility Pole Fields=====&lt;br /&gt;
For convenience Golden Retriever has some predefined pick lists for common utility pole inspection fields.&lt;br /&gt;
======Class======&lt;br /&gt;
A picklist of pole classes (1-10 and H1-H6). Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
======Height======&lt;br /&gt;
A picklist of pole heights (lengths) from 15 to 120 in increments of five. Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
======Manufacturer======&lt;br /&gt;
A very extensive picklist of current and historical pole manufacturers. Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
======Species======&lt;br /&gt;
A picklist of common utility pole species. These are the common abbreviations for the species names (ie. WC - Western Cedar, SP - Southern Yellow Pine). Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Field Options==&lt;br /&gt;
Once you have selected the field type, all of it&#039;s options will be displayed. Assign a name to it and complete any field options.&lt;br /&gt;
Most fields have four basic options.&lt;br /&gt;
[[File:DC_FieldOptions.png|thumb|none]]&lt;br /&gt;
===Required Field===&lt;br /&gt;
If the required checkbox is selected, this field must be completed for the record to save.&lt;br /&gt;
===Hidden Field===&lt;br /&gt;
Is the field visible on the mobile app. Sometimes it makes sense to pass data through to the final reports without cluttering up the field user&#039;s screen.&lt;br /&gt;
===Lock From Search===&lt;br /&gt;
If this is a field that will contain utility supplied data that the mobile app should never need to change, select this option. If the mobile app user doesn&#039;t need to see the data, use a Hidden Field instead.&lt;br /&gt;
&lt;br /&gt;
===Force Default===&lt;br /&gt;
&#039;&#039;Text&#039;&#039; and &#039;&#039;Single select Picklists&#039;&#039; can have default values assigned. If the &#039;&#039;Force Default&#039;&#039; is selected, whatever is in the default value box (can be left blank) is pre-populated in the collection form . Otherwise whatever has been entered in the previous record will copy to the new record - this is good for fields such as &#039;&#039;line&#039;&#039; or &#039;&#039;circuit&#039;&#039; number which do not change often.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
===Show/Hide Field===&lt;br /&gt;
[[File:DC_ShowHidePhoto.png|none]]&lt;br /&gt;
To keep collection forms easier to navigate hiding certain fields if unneeded can be beneficial. For example, different collection data is required for poles than for meters if both are being inspected. For this to work all possible combinations must be defined - if the picklist you are referencing has five different options then all five must be accounted for. When you are setting this up there is an option &#039;&#039;everything else&#039;&#039; which can be used to save time. Once the dictionary is saved this will be filled out &#039;&#039;long hand&#039;&#039; and show all combinations.&lt;br /&gt;
[[File:DC_ShowHideExample.png|none]]&lt;br /&gt;
 Note: Failure to account for all options will lead to inconsistent results.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Require Photo===&lt;br /&gt;
Sometimes a photo is required only when a certain condition is met. This can be set here.&lt;br /&gt;
&lt;br /&gt;
==Upload Supplied Data==&lt;br /&gt;
When asset location and other details are supplied by the utility this information can be uploaded into the collection dictionary to give a map of the assets to be inspected (if GPS locations are included in the data) and/or simply provide a local database of data that can be searched using the magnifying glass button in the app.&lt;br /&gt;
When uploading data into a dictionary it is important that the required field names match. Keep these things in mind:&lt;br /&gt;
*Latitude field &#039;&#039;should&#039;&#039; be named &amp;lt;strong&amp;gt;Y&amp;lt;/strong&amp;gt; and must be set to the GPS Data type of &#039;Latitude&#039;&lt;br /&gt;
*Longitude field &#039;&#039;should&#039;&#039; be named &amp;lt;strong&amp;gt;X&amp;lt;/strong&amp;gt; and must be set to the GPS Data type of &#039;Longitude&#039;&lt;br /&gt;
[[File:DC_LatField.png|thumb|none]]&lt;br /&gt;
*Field names are &#039;&#039;not&#039;&#039; case sensitive. As well, spaces and special characters are also ignored.&lt;br /&gt;
 i.e. &#039;&#039;Pole Number&#039;&#039;, &#039;&#039;POLE NUMBER&#039;&#039;, &#039;&#039;pole number&#039;&#039;, &#039;&#039;Pole_Number&#039;&#039;, &#039;&#039;PoleNumber&#039;&#039; are all exactly the same and therefore considered duplicates&lt;br /&gt;
*Do not include these field names as they are reserved by the system&lt;br /&gt;
**RecordNo&lt;br /&gt;
**Latitude&lt;br /&gt;
**Longitude&lt;br /&gt;
**Date&lt;br /&gt;
**Device&lt;br /&gt;
&lt;br /&gt;
*By default, Golden Retriever sets all supplied coordinates to a Red map marker and completed ones as Green. You may alternately set other colors by defining them (by number) in a &#039;&#039;&#039;MapColor&#039;&#039;&#039; field in your csv file. Green is &#039;reserved&#039; for completed records. Red, Blue, Purple, Yellow and Orange are currently the other colors available for the &#039;TO DO&#039; map markers. These are set in the csv which contains the utility supplied data. To accomplish this, add a field (csv only and &#039;&#039;not&#039;&#039; in the Dictionary Creator) called &#039;&#039;&#039;MapColor&#039;&#039;&#039; and identify the requested color by its number:&lt;br /&gt;
** &#039;&#039;&#039;0&#039;&#039;&#039; - Red&lt;br /&gt;
** &#039;&#039;&#039;1&#039;&#039;&#039; - Green (It is not recommended to use green markers)&lt;br /&gt;
** &#039;&#039;&#039;2&#039;&#039;&#039; - Blue&lt;br /&gt;
** &#039;&#039;&#039;3&#039;&#039;&#039; - Purple&lt;br /&gt;
** &#039;&#039;&#039;4&#039;&#039;&#039; - Yellow&lt;br /&gt;
** &#039;&#039;&#039;5&#039;&#039;&#039; - Orange&lt;br /&gt;
[[File:GR MapMarkerColors2.jpg|none|thumb]]&lt;br /&gt;
&lt;br /&gt;
 Note: The colors do not show the same on iOS and Android - the colors shown here are how they display on Android.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
 Note: the file must be a &#039;&#039;CSV&#039;&#039; (comma delimited and enclosed with double quotes), any coordinates must be in &#039;&#039;WGS84 format (EPSG:4326)&#039;&#039;, and the column names must match the columns in the dictionary for them to be used by the program.&lt;br /&gt;
[[File:DC_UploadCSV1.png|thumb|none]]&lt;br /&gt;
Once the file has successfully been uploaded the Local Database will show is &#039;&#039;Database Uploaded&#039;&#039;. The csv can be removed at any time by clicking the red &#039;&#039;click to unassign&#039;&#039; link.&lt;br /&gt;
You can verify all fields with data by looking for the &#039;&#039;Note: field exists in uploaded database&#039;&#039; (in red) statement, located immediately under the Field Name.&lt;br /&gt;
[[File:DC_CSVUploaded.png|thumb|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:DC_UploadCSV2.png|none]]&lt;br /&gt;
 Note: For instructions on how to extract pole data from a Utility supplied &#039;&#039;shapefile&#039;&#039; and other QGIS specific functions [[QGIS#Exporting_a_csv_for_Golden_Retriever_from_utility_supplied_shapefile|follow these instructions]].&lt;br /&gt;
&lt;br /&gt;
Once you have uploaded the csv file and saved the dictionary, the data will be available on the mobile app once dictionaries are refreshed. &lt;br /&gt;
 &#039;&#039;If the poles do not show up in the expected location on the mobile app&#039;s map it is most likely due to incompatible GPS coordinates. Confirm that they have been supplied to Golden Retriever in &amp;lt;strong&amp;gt;EPSG:4326, WGS 84&amp;lt;/strong&amp;gt;.&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
=Assign Dictionary=&lt;br /&gt;
For Administrators working with multiple Golden Retriever accounts you may assign/unassign collection dictionaries as needed. Select the checkbox beside the account(s) you wish to have access to the dictionary - both on mobile app and in the [[https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Databases_Summary_Page Dictionary Summary]] page of the Admin Portal.&lt;br /&gt;
[[File:DC_Assign.png|thumb|none]]&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=447</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=447"/>
		<updated>2025-07-22T15:21:12Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
.mw-wiki-logo.timeless-logo img {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-related-navigation {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#p-navigation{&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-site-navigation #site-tools {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=446</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=446"/>
		<updated>2025-07-22T15:20:42Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
.mw-wiki-logo.timeless-logo img {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-related-navigation {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#p-navigation{&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-site-navigation .sidebar-chunk {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=445</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=445"/>
		<updated>2025-07-22T15:19:48Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
.mw-wiki-logo.timeless-logo img {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-related-navigation {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#p-navigation{&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=444</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=444"/>
		<updated>2025-07-22T15:19:34Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
.mw-wiki-logo.timeless-logo img {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-related-navigation {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
.p-navigation{&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=443</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=443"/>
		<updated>2025-07-22T15:18:34Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
.mw-wiki-logo.timeless-logo img {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;br /&gt;
#mw-related-navigation {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=442</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=442"/>
		<updated>2025-07-22T15:17:49Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
.mw-wiki-logo.timeless-logo img {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=441</id>
		<title>MediaWiki:Timeless.css</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Timeless.css&amp;diff=441"/>
		<updated>2025-07-22T15:16:31Z</updated>

		<summary type="html">&lt;p&gt;Dave: Created page with &amp;quot;/* All CSS here will be loaded for users of the Timeless skin */ #mw-wiki-logo {     display: none !important; }&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/* All CSS here will be loaded for users of the Timeless skin */&lt;br /&gt;
#mw-wiki-logo {&lt;br /&gt;
    display: none !important;&lt;br /&gt;
}&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=Utility_Supplied_Data&amp;diff=440</id>
		<title>Utility Supplied Data</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=Utility_Supplied_Data&amp;diff=440"/>
		<updated>2025-07-08T16:59:04Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Map Marker Colors */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Utility Supplied Data=&lt;br /&gt;
Utility supplied data is uploaded into Golden Retriever in a csv file. This is done in the Dictionary Creator. There are a few rules to follow to ensure that things function correctly.&lt;br /&gt;
==File Requirements==&lt;br /&gt;
When asset location and other details are supplied by the utility this information can be uploaded into the collection dictionary to give a map of the assets to be inspected (if GPS locations are included in the data) and/or simply provide a local database of data that can be searched using the magnifying glass button in the app.&lt;br /&gt;
When uploading data into a dictionary it is important that the required field names match. Keep these things in mind:&lt;br /&gt;
*Latitude field &#039;&#039;should&#039;&#039; be named &amp;lt;strong&amp;gt;Y&amp;lt;/strong&amp;gt; and must be set to the GPS Data type of &#039;Latitude&#039;&lt;br /&gt;
*Longitude field &#039;&#039;should&#039;&#039; be named &amp;lt;strong&amp;gt;X&amp;lt;/strong&amp;gt; and must be set to the GPS Data type of &#039;Longitude&#039;&lt;br /&gt;
[[File:DC_LatField.png|thumb|none]]&lt;br /&gt;
*Field names are &#039;&#039;not&#039;&#039; case sensitive. As well, spaces and special characters are also ignored.&lt;br /&gt;
 i.e. &#039;&#039;Pole Number&#039;&#039;, &#039;&#039;POLE NUMBER&#039;&#039;, &#039;&#039;pole number&#039;&#039;, &#039;&#039;Pole_Number&#039;&#039;, &#039;&#039;PoleNumber&#039;&#039; are all exactly the same and therefore considered duplicates&lt;br /&gt;
*Do not include these field names as they are reserved by the system&lt;br /&gt;
**RecordNo&lt;br /&gt;
**Latitude&lt;br /&gt;
**Longitude&lt;br /&gt;
**Date&lt;br /&gt;
**Device&lt;br /&gt;
==Extracting Data From Shapefiles==&lt;br /&gt;
&lt;br /&gt;
==Map Marker Colors==&lt;br /&gt;
*By default, Golden Retriever sets all supplied coordinates to a Red map marker and completed ones as Green. You may alternately set other colors by defining them (by number) in a &#039;&#039;&#039;MapColor&#039;&#039;&#039; field in your csv file. Green is &#039;reserved&#039; for completed records. Red, Blue, Purple, Yellow and Orange are currently the other colors available for the &#039;TO DO&#039; map markers. These are set in the csv which contains the utility supplied data. To accomplish this, add a field (csv only and &#039;&#039;not&#039;&#039; in the Dictionary Creator) called &#039;&#039;&#039;MapColor&#039;&#039;&#039; and identify the requested color by its number:&lt;br /&gt;
** &#039;&#039;&#039;0&#039;&#039;&#039; - Red&lt;br /&gt;
** &#039;&#039;&#039;1&#039;&#039;&#039; - Green (It is not recommended to use green markers)&lt;br /&gt;
** &#039;&#039;&#039;2&#039;&#039;&#039; - Blue&lt;br /&gt;
** &#039;&#039;&#039;3&#039;&#039;&#039; - Purple&lt;br /&gt;
** &#039;&#039;&#039;4&#039;&#039;&#039; - Yellow&lt;br /&gt;
** &#039;&#039;&#039;5&#039;&#039;&#039; - Orange&lt;br /&gt;
[[File:GR MapMarkerColors2.jpg|none|thumb]]&lt;br /&gt;
&lt;br /&gt;
 Note: The colors do not show the same on iOS and Android - the colors shown here are how they display on Android.&lt;br /&gt;
&lt;br /&gt;
==GPS Coordinate Format==&lt;br /&gt;
 Note: the file must be a &#039;&#039;CSV&#039;&#039; (comma delimited and enclosed with double quotes), any coordinates must be in &#039;&#039;WGS84 format (EPSG:4326)&#039;&#039;, and the column names must match the columns in the dictionary for them to be used by the program.&lt;br /&gt;
[[File:DC_UploadCSV1.png|thumb|none]]&lt;br /&gt;
Once the file has successfully been uploaded the Local Database will show is &#039;&#039;Database Uploaded&#039;&#039;. The csv can be removed at any time by clicking the red &#039;&#039;click to unassign&#039;&#039; link.&lt;br /&gt;
You can verify all fields with data by looking for the &#039;&#039;Note: field exists in uploaded database&#039;&#039; (in red) statement, located immediately under the Field Name.&lt;br /&gt;
[[File:DC_CSVUploaded.png|thumb|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:DC_UploadCSV2.png|none]]&lt;br /&gt;
 Note: For instructions on how to extract pole data from a Utility supplied &#039;&#039;shapefile&#039;&#039; and other QGIS specific functions [[QGIS#Exporting_a_csv_for_Golden_Retriever_from_utility_supplied_shapefile|follow these instructions]].&lt;br /&gt;
&lt;br /&gt;
Once you have uploaded the csv file and saved the dictionary, the data will be available on the mobile app once dictionaries are refreshed. &lt;br /&gt;
 &#039;&#039;If the poles do not show up in the expected location on the mobile app&#039;s map it is most likely due to incompatible GPS coordinates. Confirm that they have been supplied to Golden Retriever in &amp;lt;strong&amp;gt;EPSG:4326, WGS 84&amp;lt;/strong&amp;gt;.&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=Dictionary_Creator&amp;diff=439</id>
		<title>Dictionary Creator</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=Dictionary_Creator&amp;diff=439"/>
		<updated>2025-03-17T20:08:39Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Main_Page|Main Page]]&lt;br /&gt;
__FORCETOC__&lt;br /&gt;
 Note: This page is under development and as such is not yet complete.&lt;br /&gt;
&amp;lt;strong&amp;gt;Dictionary Creator&amp;lt;/strong&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;Collection dictionaries are made by account administrators from the &#039;&#039;Admin Portal&#039;&#039; in the &#039;&#039;Dictionary Creator&#039;&#039; main menu item. Here you can create, view and edit what data is collected and how it is collected.&lt;br /&gt;
[[File:DC_MainPage.png|thumb|upright=3|none]]&lt;br /&gt;
When you first navigate to the Dictionary Creator window you will see a drop-down menu which contains all of your collection dictionaries as well as an empty collection dictionary form. You can either start a new dictionary from scratch by typing in a name and adding new fields or modify an existing one by selecting it from the list &#039;&#039;&#039;(selecting the option of &amp;quot;-----&amp;quot; from the drop-down list will reset the Dictionary Creator for you)&#039;&#039;&#039;. &lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=Dictionary Settings=&lt;br /&gt;
[[File:DC_DictOptions.png|thumb|none]]&lt;br /&gt;
===Saving Changes===&lt;br /&gt;
When you load an existing dictionary you will have both a &amp;lt;code&amp;gt;Duplicate/Create New&amp;lt;/code&amp;gt; button and a &amp;lt;code&amp;gt;Save Changes&amp;lt;/code&amp;gt; button. The &#039;&#039;Duplicate/Create New&#039;&#039; works like &#039;&#039;save as&#039;&#039; and will create a new dictionary with whatever name you have entered in the &#039;&#039;Dictionary Name&#039;&#039; box. &#039;&#039;Save Changes&#039;&#039; will save your changes to the existing dictionary.&lt;br /&gt;
[[File:DC_UpdateOrNew.png|thumb|none]]&lt;br /&gt;
If you have started from the blank template click the &amp;lt;code&amp;gt;Create New Dictionary&amp;lt;/code&amp;gt; button after assigning a name (and sub-folder if desired) to create the dictionary.&lt;br /&gt;
[[File:DC_CreateNew.png|thumb|none]]&lt;br /&gt;
===Dictionary Name===&lt;br /&gt;
Each dictionary needs a name. It is suggested to name each dictionary with the customer name and year. Where multiple dictionaries are used for the same customer those line or circuit names can be used as well.&lt;br /&gt;
===Sub Folder===&lt;br /&gt;
Sub Folders are a great way to organize your collection dictionaries in the mobile app. This is optional and if not set here the dictionary will be shown in the main dictionary directory.&lt;br /&gt;
===Dictionary Order===&lt;br /&gt;
By default all dictionaries will be shown in the mobile app in alphabetical order. Normally this works but if you wish to specify the order manually the number you enter here will dictate the order shown when selecting a dictionary in the app.&lt;br /&gt;
===Default Search Field===&lt;br /&gt;
The mobile app user has an option to search the existing collected records right from the device. While any field can be used for the search, the administrator has the option to set the default field for the search. To make things more efficient the most common search field can be set here (i.e. Pole Number).&lt;br /&gt;
[[File:DC DictOptions.png|thumb|none]]&lt;br /&gt;
 &lt;br /&gt;
A second use of this setting is for the map labels on the mobile app. Common fields used for this are the pole number or circuit number. &lt;br /&gt;
&lt;br /&gt;
If this setting is left blank (in the Dictionary Creator) simple map pins will be used.&lt;br /&gt;
[[File:AppMapStyles.jpg|thumb|none]]&lt;br /&gt;
&lt;br /&gt;
 It is possible for the mobile app user to temporarily change the label by using the search function for the field they wish to see on the map labels. The labels will reflect the most recent field used for the search during the current session. The next time the user opens the dictionary the labels will revert back to the default set in the Dictionary Creator.&lt;br /&gt;
&lt;br /&gt;
===Field for Device Map===&lt;br /&gt;
In the [[https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Databases_Summary_Page Databases Summary Page]] it is possible to view on a map, the most recent record&#039;s GPS location for each device. By setting an inspector name instead of the id of the device, any change in phone/tablet will not effect this maps functionality.&lt;br /&gt;
===Duplicate Records Allowed===&lt;br /&gt;
By default saving changes as duplicate records is allowed. This is to avoid data loss due to editing mistakes. However, this does create more administration work later on to edit and consolidate these duplicates. By selecting this option no duplicates will be allowed by the mobile app for map markers once they turn from red to green. This is when working from a map of data supplied by the utility as this is location specific (Pole Number, etc makes no difference.&lt;br /&gt;
===Photo Required===&lt;br /&gt;
If a photo is required for every inspection record select this check-box to force a photo before the app will save a new record.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=Dictionary Fields=&lt;br /&gt;
[[File:AddField.png|none]]&lt;br /&gt;
==Default Dictionary Fields==&lt;br /&gt;
Golden Retriever uses several fields for every dictionary which are automatically completed by the system. These fields are shown in the Database view. They are:&lt;br /&gt;
*RecordNo - the record number assigned by the database when the record is uploaded&lt;br /&gt;
*Latitude - the latitude of the GPS location&lt;br /&gt;
*Longitude - the longitude of the GPS location&lt;br /&gt;
*Date - An automatic timestamp when the record is saved in the mobile app&lt;br /&gt;
*Device - The unique device id as supplied by the mobile device.&lt;br /&gt;
[[File:DC_AutoFields.png|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Optional Dictionary Fields==&lt;br /&gt;
In addition to the basic fields, you can define as many other fields as you wish. These custom fields will all be placed after the automatic fields.&lt;br /&gt;
===Add Field===&lt;br /&gt;
To add a new dictionary field click on the green &amp;lt;code&amp;gt;Add field here&amp;lt;/code&amp;gt; button at the location you wish to add the field.&lt;br /&gt;
[[File:AddField.png|none]]&lt;br /&gt;
&lt;br /&gt;
===Move Field===&lt;br /&gt;
The fields will appear on the mobile app collection form according to the order they are in the Dictionary Creator. They can be moved by entering the desired position number in the box to the right of the green field box and clicking the &amp;lt;code&amp;gt;Move&amp;lt;/code&amp;gt; button. The Dictionary Creator will automatically adjust all subsequent fields so there is no worry of overwriting a field.&lt;br /&gt;
[[File:DC_MoveField.png|thumb|none]]&lt;br /&gt;
&lt;br /&gt;
===Delete Field===&lt;br /&gt;
To delete a field click on the red &#039;&#039;&#039;X&#039;&#039;&#039; by the field. You will be asked to confirm before deletion. Once this is done it is final; there is no &#039;undo&#039; option.&lt;br /&gt;
&lt;br /&gt;
===Define Fields===&lt;br /&gt;
Several data collection field types are available. Once you add a new field, you first need to select the field type from the drop-down list. &lt;br /&gt;
[[File:DC_NewField.png|none]]&lt;br /&gt;
====Define Field Type====&lt;br /&gt;
The first step is to select the field type from the dropdown list.&lt;br /&gt;
====Field Name====&lt;br /&gt;
This is the name which will be visible in the collection form on the mobile app. It will also be the column name in the online spreadsheet.&lt;br /&gt;
====Field Description====&lt;br /&gt;
This field description can be used to give more information for the end user (Mobile App user) as well as for anyone with a shared map link. This is an optional field attribute and may not be useful for all fields.&lt;br /&gt;
[[File:DC_FieldNaming.png|none]]&lt;br /&gt;
The field types are grouped into categories and are as follows:&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Classic Fields=====&lt;br /&gt;
======Comment======&lt;br /&gt;
This is a text field which always defaults to a blank value. Instructions may be added which show up when entering a new record (on the mobile app). This text does not show up in the final data.&lt;br /&gt;
[[File:Field_Comment.png|none]]&lt;br /&gt;
&lt;br /&gt;
======Picklist======&lt;br /&gt;
A drop-down list of values for the user to select. Click the &amp;lt;code&amp;gt;Add Picklist Option&amp;lt;/code&amp;gt; as many times as necessary and type in the options you would like available to your users. Any unneeded picklist options may be deleted by clicking the red X to the right of the picklist option. &lt;br /&gt;
[[File:Field_Picklist.png|none]]&lt;br /&gt;
By default, the mobile app users may only select from the list. If desired you may allow custom entries by specifying a &#039;&#039;Length of Custom Entries&#039;&#039; value. The length value represents the maximum amount of characters they can use when creating a new picklist options. User-added picklist itmes will be recurring on the user&#039;s device (until they next refresh their dictionaries) but &#039;&#039;will not&#039;&#039; transfer to the dictionary or other devices. &lt;br /&gt;
[[File:Field_Picklist_useredit.jpg|thumb|none]]&lt;br /&gt;
 Be careful what you wish for when opening up picklists to users. Whatever is inputted by the user will end up in the data. These entries will very easily include typo&#039;s and are bound to differ from user to user.&lt;br /&gt;
&lt;br /&gt;
======Text======&lt;br /&gt;
This is one of the most common field types to use and while this is a &#039;simple text&#039; field, there are several options available and some must be defined before your dictionary can be saved.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Default Value&amp;lt;/strong&amp;gt; - You may set a default value here. As users are entering records, the previous value will be transferred to the new record unless the &#039;&#039;Force Default&#039;&#039; checkbox is selected.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Max Length&amp;lt;/strong&amp;gt; - A maximum length must be set. A standard length length for text is 15 but can be shorter or longer. For a numeric field this number is how many characters are left of the decimal - the &#039;&#039;Number of Decimals Allowed&#039;&#039; setting will add to the maximum length.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Min Length&amp;lt;/strong&amp;gt; - An optional minimum length may also be set here.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Max Value&amp;lt;/strong&amp;gt; - A maximum value may be specified for numeric fields. For example, you may wish to disallow any pole year greater than the current year to minimize data entry errors.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Min Value&amp;lt;/strong&amp;gt; - A minimum value may be specified for numeric fields. For example, you may wish to disallow any pole year older than 1940.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Number of Decimals Allowed&amp;lt;/strong&amp;gt; - For numeric fields you may set the maximum number of decimals allowed. This is optional and may be left blank.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Alphanumeric&amp;lt;/strong&amp;gt; - You can set this to &#039;&#039;All Characters&#039;&#039; (including special characters), &#039;&#039;Letters and Numbers&#039;&#039;, &#039;&#039;Numbers Only&#039;&#039; or &#039;&#039;Letters Only&#039;&#039;. &lt;br /&gt;
*&amp;lt;strong&amp;gt;GPS Data&amp;lt;/strong&amp;gt; - In addition to the default GPS fields which Golden Retriever automatically collects you may specify GPS coordinate fields for navigation. When defining these fields set this option to either &#039;&#039;longitude&#039;&#039; or &#039;&#039;latitude&#039;&#039;. Without defining this option Golden Retriever will not recognize this field as containing GPS coordinates and will not plot the pole locations on the navigation map.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Capitalize&amp;lt;/strong&amp;gt; - When an &#039;&#039;Alphanumeric&#039;&#039; option containing letters has been selected you may choose to have Golden Retriever automatically capitalize either the first letter of each word or all letters. This avoids inconsistent data in the final data. This option is not shown when &#039;&#039;Numbers Only&#039;&#039; is the selected &#039;&#039;Alphanumeric&#039;&#039; option.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Increment&amp;lt;/strong&amp;gt; - When you have selected &#039;&#039;Numbers Only&#039;&#039; as the &#039;&#039;Alphanumeric&#039;&#039; option you may set this number to increment up or increment down. This option is not shown when &#039;&#039;Numbers Only&#039;&#039; is not the selected &#039;&#039;Alphanumeric&#039;&#039; option.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Barcode Scanning&amp;lt;/strong&amp;gt; - Select this option to enable barcode scanning as the input method for this field.&lt;br /&gt;
*&amp;lt;strong&amp;gt;Make This A TimeStamp&amp;lt;/strong&amp;gt; - &lt;br /&gt;
*&amp;lt;strong&amp;gt;Always Locked&amp;lt;/strong&amp;gt; - This prevents this field from being edited by the user.&lt;br /&gt;
[[File:Field_Text.png|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=====Modern Fields=====&lt;br /&gt;
======Attachment======&lt;br /&gt;
With Golden Retriever you are able to add pdf documents to the collection dictionary. This can give the mobile app user quick access to Safety Data Sheets, Product Labels, Instructions, etc. through a clickable link from within the collection record.&lt;br /&gt;
======Date Picker======&lt;br /&gt;
The Date Picker field will open up a calendar screen where the user can select a date. This is different from the automatic timestamp field for each record.&lt;br /&gt;
======Formula======&lt;br /&gt;
With the formula field you can enter an equation string that is evaluated in the app. To reference another field in the dictionary use the format &amp;lt;code&amp;gt;&amp;quot;~~Field Name~~&amp;quot;&amp;lt;/code&amp;gt; (The quotes are important as ~~Field Name~~ will be replaced by the current value of the field).&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Operator Precedence&lt;br /&gt;
|-&lt;br /&gt;
! Operator !! Associativity !! Description&lt;br /&gt;
|-&lt;br /&gt;
| (...) || None || Grouping&lt;br /&gt;
|-&lt;br /&gt;
| f(), x.y, a[i] || Left || Function call, property access, array indexing&lt;br /&gt;
|-&lt;br /&gt;
| ! || Left || Factorial&lt;br /&gt;
|-&lt;br /&gt;
| ^ || Right || Exponentiation&lt;br /&gt;
|-&lt;br /&gt;
| +, -, not, sqrt, etc. || Right || Unary prefix operators (see below for the full list)&lt;br /&gt;
|-&lt;br /&gt;
| *, /, % || Left || Multiplication, division, remainder&lt;br /&gt;
|-&lt;br /&gt;
| +, - || Left || Addition, subtraction&lt;br /&gt;
|-&lt;br /&gt;
| ==, !=, &amp;gt;=, &amp;lt;=, &amp;gt;, &amp;lt;, in || Left || Equals, not equals, etc. &amp;quot;in&amp;quot; means &amp;quot;is the left operand included in the right array operand?&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
| and || Left || Logical AND&lt;br /&gt;
|-&lt;br /&gt;
| or || Left || Logical OR&lt;br /&gt;
|-&lt;br /&gt;
| x ? y : z || Right || Ternary conditional (if x then y else z)&lt;br /&gt;
|-&lt;br /&gt;
| = || Right || Variable assignment&lt;br /&gt;
|-&lt;br /&gt;
| ; || Left || Expression separator&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Unary operators&lt;br /&gt;
|-&lt;br /&gt;
! Operator !! Description&lt;br /&gt;
|-&lt;br /&gt;
| -x || Negation&lt;br /&gt;
|-&lt;br /&gt;
| +x || Unary plus. This converts it&#039;s operand to a number, but has no other effect.&lt;br /&gt;
|-&lt;br /&gt;
| x! || Factorial (x * (x-1) * (x-2) * … * 2 * 1). gamma(x + 1) for non-integers.&lt;br /&gt;
|-&lt;br /&gt;
|abs x || Absolute value (magnitude) of x&lt;br /&gt;
|-&lt;br /&gt;
| acos x || Arc cosine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| acosh x || Hyperbolic arc cosine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| asin x || Arc sine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| asinh x || Hyperbolic arc sine of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| atan x || Arc tangent of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
|atanh x || Hyperbolic arc tangent of x (in radians)&lt;br /&gt;
|-&lt;br /&gt;
| cbrt x || Cube root of x&lt;br /&gt;
|-&lt;br /&gt;
| ceil x || Ceiling of x — the smallest integer that’s &amp;gt;= x&lt;br /&gt;
|-&lt;br /&gt;
| cos x || Cosine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| cosh x || Hyperbolic cosine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| exp x || e^x (exponential/antilogarithm function with base e)&lt;br /&gt;
|-&lt;br /&gt;
| expm1 x || e^x - 1&lt;br /&gt;
|-&lt;br /&gt;
| floor x || Floor of x — the largest integer that’s &amp;lt;= x&lt;br /&gt;
|-&lt;br /&gt;
| length x || String or array length of x&lt;br /&gt;
|-&lt;br /&gt;
| ln x || Natural logarithm of x&lt;br /&gt;
|-&lt;br /&gt;
| log x || Natural logarithm of x (synonym for ln, not base-10)&lt;br /&gt;
|-&lt;br /&gt;
| log10 x || Base-10 logarithm of x&lt;br /&gt;
|-&lt;br /&gt;
| log2 x || Base-2 logarithm of x&lt;br /&gt;
|-&lt;br /&gt;
| log1p x || Natural logarithm of (1 + x)&lt;br /&gt;
|-&lt;br /&gt;
| not x || Logical NOT operator&lt;br /&gt;
|-&lt;br /&gt;
| round x || X, rounded to the nearest integer, using &amp;quot;grade-school rounding&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
| sign x || Sign of x (-1, 0, or 1 for negative, zero, or positive respectively)&lt;br /&gt;
|-&lt;br /&gt;
| sin x || Sine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| sinh x || Hyperbolic sine of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| sqrt x || Square root of x. Result is NaN (Not a Number) if x is negative.&lt;br /&gt;
|-&lt;br /&gt;
| tan x || Tangent of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| tanh x || Hyperbolic tangent of x (x is in radians)&lt;br /&gt;
|-&lt;br /&gt;
| trunc x || Integral part of a X, looks like floor(x) unless for negative number&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Pre-defined functions&lt;br /&gt;
|-&lt;br /&gt;
! Function !! Description&lt;br /&gt;
|-&lt;br /&gt;
| random(n) || Get a random number in the range [0, n). If n is zero, or not provided, it defaults to 1.&lt;br /&gt;
|-&lt;br /&gt;
| fac(n) || n! (factorial of n: &amp;quot;n * (n-1) * (n-2) * … * 2 * 1&amp;quot;) Deprecated. Use the ! operator instead.&lt;br /&gt;
|-&lt;br /&gt;
| min(a,b,…) || Get the smallest (minimum) number in the list.&lt;br /&gt;
|-&lt;br /&gt;
| max(a,b,…) || Get the largest (maximum) number in the list.&lt;br /&gt;
|-&lt;br /&gt;
| hypot(a,b) || Hypotenuse, i.e. the square root of the sum of squares of its arguments.&lt;br /&gt;
|-&lt;br /&gt;
| pyt(a, b) || Alias for hypot.&lt;br /&gt;
|-&lt;br /&gt;
| pow(x, y) || Equivalent to x^y&lt;br /&gt;
|-&lt;br /&gt;
| atan2(y, x) || Arc tangent of x/y. i.e. the angle between (0, 0) and (x, y) in radians.&lt;br /&gt;
|-&lt;br /&gt;
| roundTo(x, n) || Rounds x to n places after the decimal point.&lt;br /&gt;
|-&lt;br /&gt;
| map(f, a) || Array map: Pass each element of &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; the function &amp;lt;code&amp;gt;f&amp;lt;/code&amp;gt;, and return an array of the results.&lt;br /&gt;
|-&lt;br /&gt;
| fold(f, y, a) || Array fold: Fold/reduce array &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; into a single value, &amp;lt;code&amp;gt;y&amp;lt;/code&amp;gt; by setting &amp;lt;code&amp;gt;y = f(y, x, index)&amp;lt;/code&amp;gt; for each element &amp;lt;code&amp;gt;x&amp;lt;/code&amp;gt; of the array.&lt;br /&gt;
|-&lt;br /&gt;
| filter(f, a) || Array filter: Return an array containing only the values from &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; where &amp;lt;code&amp;gt;f(x, index)&amp;lt;/code&amp;gt; is &amp;lt;code&amp;gt;true&amp;lt;/code&amp;gt;.&lt;br /&gt;
|-&lt;br /&gt;
| indexOf(x, a) || Return the first index of string or array &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; matching the value &amp;lt;code&amp;gt;x&amp;lt;/code&amp;gt;, or &amp;lt;code&amp;gt;-1&amp;lt;/code&amp;gt; if not found.&lt;br /&gt;
|-&lt;br /&gt;
| join(sep, a) || Concatenate the elements of &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt;, separated by &amp;lt;code&amp;gt;sep&amp;lt;/code&amp;gt;.&lt;br /&gt;
|-&lt;br /&gt;
| if(c, a, b) || Function form of c ? a : b. Note: This always evaluates both &amp;lt;code&amp;gt;a&amp;lt;/code&amp;gt; and &amp;lt;code&amp;gt;b&amp;lt;/code&amp;gt;, regardless of whether &amp;lt;code&amp;gt;c&amp;lt;/code&amp;gt; is true or not. Use &amp;lt;code&amp;gt;c ? a : b&amp;lt;/code&amp;gt; instead if there are side effects, or if evaluating the branches could be expensive.&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
{| class=&amp;quot;wikitable&amp;quot; style=&amp;quot;margin:auto&amp;quot;&lt;br /&gt;
|+ Constants&lt;br /&gt;
|-&lt;br /&gt;
! Constant !! Description&lt;br /&gt;
|-&lt;br /&gt;
| E || The value of E &lt;br /&gt;
|-&lt;br /&gt;
| PI || The value of PI&lt;br /&gt;
|-&lt;br /&gt;
| true || Logical true value&lt;br /&gt;
|-&lt;br /&gt;
| false || Logical false value&lt;br /&gt;
|}&lt;br /&gt;
&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
======Picklist - Multiple Selection======&lt;br /&gt;
A multiple-selection picklist allows for multiple choices. This is used for dictionary fields where you need to record multiple things, if they exist. This data is stored in a text field similar to a notes field and &#039;&#039;can not&#039;&#039; be used for any show/hide rules.&lt;br /&gt;
======Signature======&lt;br /&gt;
The signature field allows for signature collection using the device&#039;s touchscreen. This is most useful when customizing a collection dictionary as for &#039;&#039;Tailgate safety meetings&#039;&#039; and for other administrative tasks. Due to crews being spread out it can be difficult to distribute forms to the crews and to receive the completed forms back. Golden Retriever can be used as a tool to aid in this by creating specific dictionaries.&lt;br /&gt;
======Spacer======&lt;br /&gt;
The spacer is not a data field but a horizontal line which is displayed in the mobile app to visually separate different categories of fields in the collection form. Use of this is completely voluntary.&lt;br /&gt;
======Weather======&lt;br /&gt;
When a user taps this field in the mobile app, while conducting the inspection, the current weather conditions will be recorded in the inspection record. Golden Retriever is also often used by vegetation control companies to record their herbicide mixing and application - in which weather plays a large role.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Calculator Fields=====&lt;br /&gt;
Golden Retriever has two pole strength calculator fields available. One based on the RUS Tables and one on the ANSI remaining strength tables. These can be used by field personnel to help determine pole integrity. Both calculator fields allow the author of the dictionary to set fields to pull data from as well as fields to record the results.&lt;br /&gt;
======RUS Deduction - RUS Tables======&lt;br /&gt;
======Strength Calc - ANSI Tables======&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
Golden Retriever has remaining strength calculations for symmetrical decay (internal and external) based on the ANSI tables. This field can be set up to pull information from other fields as well as record all data used for the calculations in a comment or text field. The image below shows assigned fields for most of the required information.&lt;br /&gt;
[[File:Field_StrCalc.png|none]]&lt;br /&gt;
Any information not automatically imported into the calculation will need to be added when the calculation popup is shown. Once the user taps the &amp;lt;code&amp;gt;CALCULATE&amp;lt;/code&amp;gt; button the remaining strength values are recorded into the &#039;&#039;Remaining Strength&#039;&#039; field as well as the data used for the calculation into an assigned field.&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
| [[File:Field_StrCalc_Calc.jpg|thumb|none]] || [[File:Field_StrCalc_Record.jpg|thumb|none]]&lt;br /&gt;
|}&lt;br /&gt;
&amp;lt;br&amp;gt;This information can be accessed later by engineering staff either through the Admin Portal or from downloaded data.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&#039;&#039;&#039;Online View&#039;&#039;&#039;&lt;br /&gt;
[[File:StregthCalc_OnlineData.png|none|border]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&#039;&#039;&#039;Spreadsheet View&#039;&#039;&#039;&lt;br /&gt;
[[File:StrengthCalc_Data.png|none|border]]&lt;br /&gt;
&lt;br /&gt;
=====Monitoring Fields=====&lt;br /&gt;
======Altered Data======&lt;br /&gt;
This is a hidden field from the mobile app user and will record any changes made to the original utility supplied data (as seen by the app users in the map or online search function).&lt;br /&gt;
======Custom GPS======&lt;br /&gt;
Normally, if the mobile device is unable to obtain a GPS lock the user will be presented with a pop-up stating &#039;&#039;Could not get a GPS lock. Do you wish to wait?&#039;&#039;. With this field, which is hidden from the collection screen, the user will be given the option to manually enter the GPS coordinates in addition to waiting.&lt;br /&gt;
======Elevation======&lt;br /&gt;
Elevation is a hidden field (hidden from the mobile app user) and is automatically populated during the inspection. It can be set to Metric (metres) or Imperial (feet).&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
=====Utility Pole Fields=====&lt;br /&gt;
For convenience Golden Retriever has some predefined pick lists for common utility pole inspection fields.&lt;br /&gt;
======Class======&lt;br /&gt;
A picklist of pole classes (1-10 and H1-H6). Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
======Height======&lt;br /&gt;
A picklist of pole heights (lengths) from 15 to 120 in increments of five. Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
======Manufacturer======&lt;br /&gt;
A very extensive picklist of current and historical pole manufacturers. Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
======Species======&lt;br /&gt;
A picklist of common utility pole species. These are the common abbreviations for the species names (ie. WC - Western Cedar, SP - Southern Yellow Pine). Once selected the list may be modified for your specific use by adding, deleting or editing any of the picklist items.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Field Options==&lt;br /&gt;
Once you have selected the field type, all of it&#039;s options will be displayed. Assign a name to it and complete any field options.&lt;br /&gt;
Most fields have four basic options.&lt;br /&gt;
[[File:DC_FieldOptions.png|thumb|none]]&lt;br /&gt;
===Required Field===&lt;br /&gt;
If the required checkbox is selected, this field must be completed for the record to save.&lt;br /&gt;
===Hidden Field===&lt;br /&gt;
Is the field visible on the mobile app. Sometimes it makes sense to pass data through to the final reports without cluttering up the field user&#039;s screen.&lt;br /&gt;
===Lock From Search===&lt;br /&gt;
If this is a field that will contain utility supplied data that the mobile app should never need to change, select this option. If the mobile app user doesn&#039;t need to see the data, use a Hidden Field instead.&lt;br /&gt;
&lt;br /&gt;
===Force Default===&lt;br /&gt;
&#039;&#039;Text&#039;&#039; and &#039;&#039;Single select Picklists&#039;&#039; can have default values assigned. If the &#039;&#039;Force Default&#039;&#039; is selected, whatever is in the default value box (can be left blank) is pre-populated in the collection form . Otherwise whatever has been entered in the previous record will copy to the new record - this is good for fields such as &#039;&#039;line&#039;&#039; or &#039;&#039;circuit&#039;&#039; number which do not change often.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
===Show/Hide Field===&lt;br /&gt;
[[File:DC_ShowHidePhoto.png|none]]&lt;br /&gt;
To keep collection forms easier to navigate hiding certain fields if unneeded can be beneficial. For example, different collection data is required for poles than for meters if both are being inspected. For this to work all possible combinations must be defined - if the picklist you are referencing has five different options then all five must be accounted for. When you are setting this up there is an option &#039;&#039;everything else&#039;&#039; which can be used to save time. Once the dictionary is saved this will be filled out &#039;&#039;long hand&#039;&#039; and show all combinations.&lt;br /&gt;
[[File:DC_ShowHideExample.png|none]]&lt;br /&gt;
 Note: Failure to account for all options will lead to inconsistent results.&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
===Require Photo===&lt;br /&gt;
Sometimes a photo is required only when a certain condition is met. This can be set here.&lt;br /&gt;
&lt;br /&gt;
==Upload Supplied Data==&lt;br /&gt;
When asset location and other details are supplied by the utility this information can be uploaded into the collection dictionary to give a map of the assets to be inspected (if GPS locations are included in the data) and/or simply provide a local database of data that can be searched using the magnifying glass button in the app.&lt;br /&gt;
When uploading data into a dictionary it is important that the required field names match. Keep these things in mind:&lt;br /&gt;
*Latitude field &#039;&#039;should&#039;&#039; be named &amp;lt;strong&amp;gt;Y&amp;lt;/strong&amp;gt; and must be set to the GPS Data type of &#039;Latitude&#039;&lt;br /&gt;
*Longitude field &#039;&#039;should&#039;&#039; be named &amp;lt;strong&amp;gt;X&amp;lt;/strong&amp;gt; and must be set to the GPS Data type of &#039;Longitude&#039;&lt;br /&gt;
[[File:DC_LatField.png|thumb|none]]&lt;br /&gt;
*Field names are &#039;&#039;not&#039;&#039; case sensitive. As well, spaces and special characters are also ignored.&lt;br /&gt;
 i.e. &#039;&#039;Pole Number&#039;&#039;, &#039;&#039;POLE NUMBER&#039;&#039;, &#039;&#039;pole number&#039;&#039;, &#039;&#039;Pole_Number&#039;&#039;, &#039;&#039;PoleNumber&#039;&#039; are all exactly the same and therefore considered duplicates&lt;br /&gt;
*Do not include these field names as they are reserved by the system&lt;br /&gt;
**RecordNo&lt;br /&gt;
**Latitude&lt;br /&gt;
**Longitude&lt;br /&gt;
**Date&lt;br /&gt;
**Device&lt;br /&gt;
&lt;br /&gt;
*By default, Golden Retriever sets all supplied coordinates to a Red map marker and completed ones as Green. You may alternately set other colors by defining them (by number) in a &#039;&#039;&#039;MapColr&#039;&#039;&#039; field in your csv file. Green is &#039;reserved&#039; for completed records. Red, Blue, Purple, Yellow and Orange are currently the other colors available for the &#039;TO DO&#039; map markers. These are set in the csv which contains the utility supplied data. To accomplish this, add a field (csv only and &#039;&#039;not&#039;&#039; in the Dictionary Creator) called &#039;&#039;&#039;MapColor&#039;&#039;&#039; and identify the requested color by its number:&lt;br /&gt;
** &#039;&#039;&#039;0&#039;&#039;&#039; - Red&lt;br /&gt;
** &#039;&#039;&#039;1&#039;&#039;&#039; - Green (It is not recommended to use green markers)&lt;br /&gt;
** &#039;&#039;&#039;2&#039;&#039;&#039; - Blue&lt;br /&gt;
** &#039;&#039;&#039;3&#039;&#039;&#039; - Purple&lt;br /&gt;
** &#039;&#039;&#039;4&#039;&#039;&#039; - Yellow&lt;br /&gt;
** &#039;&#039;&#039;5&#039;&#039;&#039; - Orange&lt;br /&gt;
[[File:GR MapMarkerColors2.jpg|none|thumb]]&lt;br /&gt;
&lt;br /&gt;
 Note: The colors do not show the same on iOS and Android - the colors shown here are how they display on Android.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
 Note: the file must be a &#039;&#039;CSV&#039;&#039; (comma delimited and enclosed with double quotes), any coordinates must be in &#039;&#039;WGS84 format (EPSG:4326)&#039;&#039;, and the column names must match the columns in the dictionary for them to be used by the program.&lt;br /&gt;
[[File:DC_UploadCSV1.png|thumb|none]]&lt;br /&gt;
Once the file has successfully been uploaded the Local Database will show is &#039;&#039;Database Uploaded&#039;&#039;. The csv can be removed at any time by clicking the red &#039;&#039;click to unassign&#039;&#039; link.&lt;br /&gt;
You can verify all fields with data by looking for the &#039;&#039;Note: field exists in uploaded database&#039;&#039; (in red) statement, located immediately under the Field Name.&lt;br /&gt;
[[File:DC_CSVUploaded.png|thumb|none]]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
[[File:DC_UploadCSV2.png|none]]&lt;br /&gt;
 Note: For instructions on how to extract pole data from a Utility supplied &#039;&#039;shapefile&#039;&#039; and other QGIS specific functions [[QGIS#Exporting_a_csv_for_Golden_Retriever_from_utility_supplied_shapefile|follow these instructions]].&lt;br /&gt;
&lt;br /&gt;
Once you have uploaded the csv file and saved the dictionary, the data will be available on the mobile app once dictionaries are refreshed. &lt;br /&gt;
 &#039;&#039;If the poles do not show up in the expected location on the mobile app&#039;s map it is most likely due to incompatible GPS coordinates. Confirm that they have been supplied to Golden Retriever in &amp;lt;strong&amp;gt;EPSG:4326, WGS 84&amp;lt;/strong&amp;gt;.&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
=Assign Dictionary=&lt;br /&gt;
For Administrators working with multiple Golden Retriever accounts you may assign/unassign collection dictionaries as needed. Select the checkbox beside the account(s) you wish to have access to the dictionary - both on mobile app and in the [[https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Databases_Summary_Page Dictionary Summary]] page of the Admin Portal.&lt;br /&gt;
[[File:DC_Assign.png|thumb|none]]&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Sidebar&amp;diff=438</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Sidebar&amp;diff=438"/>
		<updated>2025-01-13T21:31:40Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;br /&gt;
* navigation&lt;br /&gt;
** mainpage|mainpage-description&lt;br /&gt;
* Online Admin Portal&lt;br /&gt;
** Admin_Portal|Admin Portal&lt;br /&gt;
** Account_Settings|Manage Account Settings&lt;br /&gt;
** Data_Management|Databases &amp;amp; Managing Uploaded Data&lt;br /&gt;
** Dictionary_Creator|Dictionary Creator&lt;br /&gt;
*** Utility_Supplied_Data|Utility Supplied Data&lt;br /&gt;
** License_Keys|Manage Mobile App Access&lt;br /&gt;
** Manage_Users|Manage User Accounts&lt;br /&gt;
** Update_Payment_Settings|Update Payment Settings&lt;br /&gt;
** Update_Sleep_Status|Update Sleep Status&lt;br /&gt;
** Upload_Data|Upload Modified Data Directly Into Databases&lt;br /&gt;
* Viewing And Sharing Data&lt;br /&gt;
** Viewing And Filtering Data&lt;br /&gt;
** Data_Management#Downloading_Records|Downloading Collected Data&lt;br /&gt;
** Download To Spreadsheet&lt;br /&gt;
** Data_Management#Viewing_Photos|Downloading Photos&lt;br /&gt;
** Data_Management#Export_as_a_Shapefile | Export As Shapefile&lt;br /&gt;
** Share_Maps|Shareable Maps&lt;br /&gt;
* Mobile App&lt;br /&gt;
** App_Setup|Mobile App Setup&lt;br /&gt;
** App_Use|Data Collection&lt;br /&gt;
** App_GPS|Acquiring GPS Coordinates&lt;br /&gt;
* Tips Tricks &amp;amp; Troubleshooting&lt;br /&gt;
** Tips Tricks &amp;amp; Troubleshooting|Tips Tricks &amp;amp; Troubleshooting&lt;br /&gt;
* Mapping Data with External Applications&lt;br /&gt;
** Export_to_ArcGIS | Export to ArcGIS&lt;br /&gt;
** Create_public_map | Create a public map (ArcGIS)&lt;br /&gt;
** QGIS|QGIS&lt;br /&gt;
** MyGeodata|My Geodata - Convert Shapefiles to CSV easily&lt;br /&gt;
* Read Only API Access&lt;br /&gt;
** API_Authentication|Authentication&lt;br /&gt;
** API_Responses|Manipulating Responses&lt;br /&gt;
** API_Dictionary|Endpoint: Dictionary Information&lt;br /&gt;
** API_Data|Endpoint: Data&lt;br /&gt;
** API_Photos|Endpoint: Photos&lt;br /&gt;
* Changelogs&lt;br /&gt;
** Admin_portal_changelog|Admin Portal Changelog&lt;br /&gt;
** Mobile_app_changelog|Mobile App Changelog&lt;br /&gt;
* SEARCH&lt;br /&gt;
* TOOLBOX&lt;br /&gt;
* LANGUAGES&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Sidebar&amp;diff=437</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Sidebar&amp;diff=437"/>
		<updated>2025-01-13T21:31:11Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;br /&gt;
* navigation&lt;br /&gt;
** mainpage|mainpage-description&lt;br /&gt;
* Online Admin Portal&lt;br /&gt;
** Admin_Portal|Admin Portal&lt;br /&gt;
** Account_Settings|Manage Account Settings&lt;br /&gt;
** Data_Management|Databases &amp;amp; Managing Uploaded Data&lt;br /&gt;
** Dictionary_Creator|Dictionary Creator&lt;br /&gt;
*** Utility_Supplied_Data|Utility Supplied Data&lt;br /&gt;
** License_Keys|Manage Mobile App Access&lt;br /&gt;
** Manage_Users|Manage User Accounts&lt;br /&gt;
** Update_Payment_Settings|Update Payment Settings&lt;br /&gt;
** Update_Sleep_Status|Update Sleep Status&lt;br /&gt;
** Upload_Data|Upload Modified Data Directly Into Databases&lt;br /&gt;
* Viewing And Sharing Data&lt;br /&gt;
** Viewing And Filtering Data&lt;br /&gt;
** Data_Management#Downloading_Records|Downloading Collected Data&lt;br /&gt;
** Download To Spreadsheet&lt;br /&gt;
** Data_Management#Viewing_Photos|Downloading Photos&lt;br /&gt;
** Data_Management#Export_as_a_Shapefile | Export As Shapefile&lt;br /&gt;
** Share_Maps|Shareable Maps&lt;br /&gt;
* Mobile App&lt;br /&gt;
** App_Setup|Mobile App Setup&lt;br /&gt;
** App_Use|Data Collection&lt;br /&gt;
** App_GPS|Acquiring GPS Coordinates&lt;br /&gt;
* Tips Tricks &amp;amp; Troubleshooting&lt;br /&gt;
** Tips Tricks &amp;amp; Troubleshooting|Tips Tricks &amp;amp; Troubleshooting&lt;br /&gt;
* Mapping Data with External Applications&lt;br /&gt;
** Export_to_ArcGIS | Export to ArcGIS&lt;br /&gt;
** Create_public_map | Create a public map (ArcGIS)&lt;br /&gt;
** QGIS|QGIS&lt;br /&gt;
** MyGeodata|MyGeodata&lt;br /&gt;
* Read Only API Access&lt;br /&gt;
** API_Authentication|Authentication&lt;br /&gt;
** API_Responses|Manipulating Responses&lt;br /&gt;
** API_Dictionary|Endpoint: Dictionary Information&lt;br /&gt;
** API_Data|Endpoint: Data&lt;br /&gt;
** API_Photos|Endpoint: Photos&lt;br /&gt;
* Changelogs&lt;br /&gt;
** Admin_portal_changelog|Admin Portal Changelog&lt;br /&gt;
** Mobile_app_changelog|Mobile App Changelog&lt;br /&gt;
* SEARCH&lt;br /&gt;
* TOOLBOX&lt;br /&gt;
* LANGUAGES&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MyGeodata&amp;diff=436</id>
		<title>MyGeodata</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MyGeodata&amp;diff=436"/>
		<updated>2025-01-13T21:26:09Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Main_Page|Main Page]]&lt;br /&gt;
&lt;br /&gt;
===My Geodata - Convert Shapefiles to CSV easily===&lt;br /&gt;
As Golden Retriever requires its data in CVS format with the coordinates in EPSG:4326 (WGS84) you can use the free service [https://mygeodata.cloud My Geodata] to convert Shapefiles to this format. &lt;br /&gt;
&lt;br /&gt;
When you first visit [https://mygeodata.cloud My Geodata] you will see a button to upload your Shapefile. Click to find the zip file that was provided to you.&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 13.47.57 mygeodata.cloud c46b56a2df97.png|none]]&lt;br /&gt;
&lt;br /&gt;
The website will analyze the file and then provide you a preview of how the data would plot&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 13.48.57 mygeodata.cloud c905d8e218f5.png|none]]&lt;br /&gt;
[[File:2025-01-13 13.50.06 mygeodata.cloud 806e35a24c0e.png|none]]&lt;br /&gt;
&lt;br /&gt;
If everything looks good, click &amp;quot;Looks Good&amp;quot;. Next select CSV for the output format and then select EPSG:4326 for the export coordinate system. Then click &amp;quot;Convert&amp;quot;&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 13.51.05 mygeodata.cloud 36725e85a382.png|none]]&lt;br /&gt;
&lt;br /&gt;
If you are only converting about one Shapefile a month, you should be able to make use of the Free plan to complete the conversion. In this case you will be presented with the screen to download your new CSV.&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 14.02.04 mygeodata.cloud b3c0956bf513.png|none]]&lt;br /&gt;
&lt;br /&gt;
In the downloaded CSV you will now have two new columns at the start: X &amp;amp; Y. These are the coordinates for the records in WGS84 format.&lt;br /&gt;
&lt;br /&gt;
[[File:Screenshot 2025-01-13 142046.png|none]]&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MyGeodata&amp;diff=435</id>
		<title>MyGeodata</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MyGeodata&amp;diff=435"/>
		<updated>2025-01-13T21:21:14Z</updated>

		<summary type="html">&lt;p&gt;Dave: Created page with &amp;quot;Main Page  ===My Geodata - Convert Shapefiles to CSV easily=== As Golden Retriever requires its data in CVS format with the coordinates in EPSG:4326 (WGS84) you can use the free service [https://mygeodata.cloud My Geodata] to convert Shapefiles to this format.   When you first visit [https://mygeodata.cloud My Geodata] you will see a button to upload your Shapefile. Click to find the zip file that was provided to you.  File:2025-01-13 13.47.57 mygeodata.c...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Main_Page|Main Page]]&lt;br /&gt;
&lt;br /&gt;
===My Geodata - Convert Shapefiles to CSV easily===&lt;br /&gt;
As Golden Retriever requires its data in CVS format with the coordinates in EPSG:4326 (WGS84) you can use the free service [https://mygeodata.cloud My Geodata] to convert Shapefiles to this format. &lt;br /&gt;
&lt;br /&gt;
When you first visit [https://mygeodata.cloud My Geodata] you will see a button to upload your Shapefile. Click to find the zip file that was provided to you.&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 13.47.57 mygeodata.cloud c46b56a2df97.png|thumb]]&lt;br /&gt;
&lt;br /&gt;
The website will analyze the file and then provide you a preview of how the data would plot&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 13.48.57 mygeodata.cloud c905d8e218f5.png|thumb]]&lt;br /&gt;
[[File:2025-01-13 13.50.06 mygeodata.cloud 806e35a24c0e.png|thumb]]&lt;br /&gt;
&lt;br /&gt;
If everything looks good, click &amp;quot;Looks Good&amp;quot;. Next select CSV for the output format and then select EPSG:4326 for the export coordinate system. Then click &amp;quot;Next&amp;quot;&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 13.51.05 mygeodata.cloud 36725e85a382.png|thumb]]&lt;br /&gt;
&lt;br /&gt;
If you are only converting one Shapefile a month or so, you should be able to make use of the Free plan to complete the conversion.&lt;br /&gt;
&lt;br /&gt;
[[File:2025-01-13 14.02.04 mygeodata.cloud b3c0956bf513.png|thumb]]&lt;br /&gt;
&lt;br /&gt;
In the downloaded CSV you will now have two new columns at the start: X &amp;amp; Y&lt;br /&gt;
&lt;br /&gt;
[[File:Screenshot 2025-01-13 142046.png|thumb]]&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2025-01-13_142046.png&amp;diff=434</id>
		<title>File:Screenshot 2025-01-13 142046.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:Screenshot_2025-01-13_142046.png&amp;diff=434"/>
		<updated>2025-01-13T21:21:07Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;CSV with new columns&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_14.02.04_mygeodata.cloud_b3c0956bf513.png&amp;diff=433</id>
		<title>File:2025-01-13 14.02.04 mygeodata.cloud b3c0956bf513.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_14.02.04_mygeodata.cloud_b3c0956bf513.png&amp;diff=433"/>
		<updated>2025-01-13T21:20:38Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;mygeodata.cloud download&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.51.05_mygeodata.cloud_36725e85a382.png&amp;diff=432</id>
		<title>File:2025-01-13 13.51.05 mygeodata.cloud 36725e85a382.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.51.05_mygeodata.cloud_36725e85a382.png&amp;diff=432"/>
		<updated>2025-01-13T21:20:13Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;mygeodata.cloud export settings&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.50.06_mygeodata.cloud_806e35a24c0e.png&amp;diff=431</id>
		<title>File:2025-01-13 13.50.06 mygeodata.cloud 806e35a24c0e.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.50.06_mygeodata.cloud_806e35a24c0e.png&amp;diff=431"/>
		<updated>2025-01-13T21:19:38Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt; mygeodata.cloud preview&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.48.57_mygeodata.cloud_c905d8e218f5.png&amp;diff=430</id>
		<title>File:2025-01-13 13.48.57 mygeodata.cloud c905d8e218f5.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.48.57_mygeodata.cloud_c905d8e218f5.png&amp;diff=430"/>
		<updated>2025-01-13T21:19:13Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;mygeodata.cloud analyze&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.47.57_mygeodata.cloud_c46b56a2df97.png&amp;diff=429</id>
		<title>File:2025-01-13 13.47.57 mygeodata.cloud c46b56a2df97.png</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=File:2025-01-13_13.47.57_mygeodata.cloud_c46b56a2df97.png&amp;diff=429"/>
		<updated>2025-01-13T21:18:07Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;mygeodata.cloud home page&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Photos&amp;diff=428</id>
		<title>API Photos</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Photos&amp;diff=428"/>
		<updated>2024-10-31T21:17:25Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Each data object returned from the [[API_Data|Data]] endpoint will contain a comma separated list as the value for the key &amp;quot;Photos&amp;quot;. These are the ids of the photos. &lt;br /&gt;
&lt;br /&gt;
You can download a photo from a dictionary using the following example: &lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/photo/{Dictionary_no}/{Photo_no}&amp;lt;/nowiki&amp;gt;&amp;quot; -o photo.jpg&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
The response will be the file &#039;&#039;&#039;photo.jpg&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Photos&amp;diff=427</id>
		<title>API Photos</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Photos&amp;diff=427"/>
		<updated>2024-10-31T21:17:17Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Each data object returned from the [[API_Data|Data]] endpoint will contain a comma separated list as the value for the key &amp;quot;Photos&amp;quot;. These are the ids of the photos. &lt;br /&gt;
&lt;br /&gt;
You can download a photo from a dictionary using the following example: &lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/photo/{Dictionary_no}/{Photo_no}&amp;lt;/nowiki&amp;gt;&amp;quot; -o photo.jpg&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
The response will be the file &#039;&#039;&#039;photo.jpg&#039;&#039;&#039; 1&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Photos&amp;diff=426</id>
		<title>API Photos</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Photos&amp;diff=426"/>
		<updated>2023-12-22T16:48:08Z</updated>

		<summary type="html">&lt;p&gt;Dave: Created page with &amp;quot;Each data object returned from the Data endpoint will contain a comma separated list as the value for the key &amp;quot;Photos&amp;quot;. These are the ids of the photos.   You can download a photo from a dictionary using the following example:     &amp;#039;&amp;#039;&amp;#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/photo/{Dictionary_no}/{Photo_no}&amp;lt;/nowiki&amp;gt;&amp;quot; -o photo.jpg&amp;#039;&amp;#039;&amp;#039;  The response will be the file &amp;#039;&amp;#039;&amp;#039;photo.jpg&amp;#039;&amp;#039;&amp;#039;&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Each data object returned from the [[API_Data|Data]] endpoint will contain a comma separated list as the value for the key &amp;quot;Photos&amp;quot;. These are the ids of the photos. &lt;br /&gt;
&lt;br /&gt;
You can download a photo from a dictionary using the following example: &lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/photo/{Dictionary_no}/{Photo_no}&amp;lt;/nowiki&amp;gt;&amp;quot; -o photo.jpg&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
The response will be the file &#039;&#039;&#039;photo.jpg&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Data&amp;diff=425</id>
		<title>API Data</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Data&amp;diff=425"/>
		<updated>2023-12-22T16:42:43Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Once you have the Dictionary_no you wish to pull the data from (Use the [[API_Dictionary|Dictionary]] endpoint to find the Dictionary_no) you can use the following format to pull the data.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/data/{Dictionary_no}&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Data&amp;diff=424</id>
		<title>API Data</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Data&amp;diff=424"/>
		<updated>2023-12-22T16:42:06Z</updated>

		<summary type="html">&lt;p&gt;Dave: Created page with &amp;quot;Once you have the Dictionary_no you wish to pull the data from (Use the Dictionary endpoint to find the Dictionary_no ) you can use the following format to pull the data.    &amp;#039;&amp;#039;&amp;#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/data/{Dictionary_no}&amp;lt;/nowiki&amp;gt;&amp;quot;&amp;#039;&amp;#039;&amp;#039;  Each response from the API will be in the following JSON format:    {     &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,     &amp;quot;skip&amp;quot;: 0,     &amp;quot;limit&amp;quot;: 10,...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Once you have the Dictionary_no you wish to pull the data from (Use the [[API_Dictionary|Dictionary]] endpoint to find the Dictionary_no ) you can use the following format to pull the data.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/data/{Dictionary_no}&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=423</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=423"/>
		<updated>2023-12-22T16:37:16Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Microsoft Azure */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
  Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
  $or[Display_Name][$search]=5L37&lt;br /&gt;
  $or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Microsoft Azure ====&lt;br /&gt;
&lt;br /&gt;
When integrating the API with Microsoft Azure data pipelines there is an additional parameter that can be of assistance. The response from our API is a JSON object with a key called &amp;quot;data&amp;quot; which contains an array of objects. Azure instead wants the response to simply be that array of objects only. So in order to force the Golden Retriever API to return the data in the format expected by Azure add the URL parameter $azure=1&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$azure=1&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24azure=1&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=422</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=422"/>
		<updated>2023-12-22T16:36:24Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
  Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
  $or[Display_Name][$search]=5L37&lt;br /&gt;
  $or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Microsoft Azure ====&lt;br /&gt;
&lt;br /&gt;
When integrating the API with Microsoft Azure data pipelines there is an additional parameter that can be of assistance. In the API standard we utilize the response from out API is a JSON object with a key called &amp;quot;data&amp;quot; which contains an array of objects. Azure instead wants the response to simply be that array of objects only. So in order to force the Golden Retriever API to return the data in the format expected by Azure add the URL parameter $azure=1&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$azure=1&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24azure=1&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=421</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=421"/>
		<updated>2023-12-22T16:31:27Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Filtering Results */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
  Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
  $or[Display_Name][$search]=5L37&lt;br /&gt;
  $or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=420</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=420"/>
		<updated>2023-12-22T16:31:15Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Filtering Results */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
  Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
For Example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
For Example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
  $or[Display_Name][$search]=5L37&lt;br /&gt;
  $or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=419</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=419"/>
		<updated>2023-12-22T16:30:49Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Filtering Results */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
  Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
For Example:&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
  $or[Display_Name][$search]=5L37&lt;br /&gt;
  $or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=418</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=418"/>
		<updated>2023-12-22T16:30:32Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Search */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
  $or[Display_Name][$search]=5L37&lt;br /&gt;
  $or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
For example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=417</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=417"/>
		<updated>2023-12-22T16:30:03Z</updated>

		<summary type="html">&lt;p&gt;Dave: /* Search */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
$or[Display_Name][$search]=5L37&lt;br /&gt;
$or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=416</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=416"/>
		<updated>2023-12-22T16:29:47Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also currently have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
$or[Display_Name][$search]=5L37&lt;br /&gt;
$or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=415</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=415"/>
		<updated>2023-12-22T16:29:08Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
==== Search ====&lt;br /&gt;
&lt;br /&gt;
Lastly we also currently have the ability to search for a substring in a field:&lt;br /&gt;
&lt;br /&gt;
$or[Display_Name][$search]=5L37&lt;br /&gt;
$or[Display_Name][$search]=5L38&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$or[Display_Name][$search]=5L37&amp;amp;$or[Display_Name][$search]=5L38&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24or%5BDisplay_Name%5D%5B%24search%5D=5L37&amp;amp;%24or%5BDisplay_Name%5D%5B%24search%5D=5L38&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=414</id>
		<title>API Dictionary</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=414"/>
		<updated>2023-12-22T16:22:39Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This endpoint is used to list of all the dictionaries tied to your account along with their unique &amp;quot;Dictionary_no&amp;quot;, which you will need as the {id} for using the [[API_Data|Data]] endpoint.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Authentication&amp;diff=413</id>
		<title>API Authentication</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Authentication&amp;diff=413"/>
		<updated>2023-12-22T16:22:10Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;In order to use the API you will need to generate an API Key from within the Admin Portal. Once logged into the Admin portal use the side menu to open the &amp;quot;My Profile&amp;quot; page.&lt;br /&gt;
&lt;br /&gt;
[[File:API Menu.png|thumb|center]]&lt;br /&gt;
&lt;br /&gt;
Near the bottom of the page you will find a section where you can generate an API Key. Click on the &amp;quot;Generate API Key&amp;quot; button to generate a new API Key.&lt;br /&gt;
&lt;br /&gt;
[[File:Generate API KEY.png|thumb|center]]&lt;br /&gt;
&lt;br /&gt;
Once you have generated an API Key it will show up in the list. You will also be able to delete the key.&lt;br /&gt;
&lt;br /&gt;
[[File:Generated API Key.png|thumb|center]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
When using any of the API endpoints you will be required to pass a valid API Key as a header in the following format:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;authorization: CgHxb18BvJu4IMSnGDrNXsfWHJISjT227JJFB2gwVDrCrKc7koY3wARyK4BiBvR7&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
For Example:&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: CgHxb18BvJu4IMSnGDrNXsfWHJISjT227JJFB2gwVDrCrKc7koY3wARyK4BiBvR7&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=412</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=412"/>
		<updated>2023-12-22T16:21:57Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=411</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=411"/>
		<updated>2023-12-22T16:21:08Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;&amp;lt;nowiki&amp;gt;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;lt;/nowiki&amp;gt;&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=410</id>
		<title>API Responses</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Responses&amp;diff=410"/>
		<updated>2023-12-22T16:19:49Z</updated>

		<summary type="html">&lt;p&gt;Dave: Created page with &amp;quot;==== Pagination ====  By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)    &amp;#039;&amp;#039;&amp;#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;quot;&amp;#039;&amp;#039;&amp;#039;  or    &amp;#039;&amp;#039;&amp;#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;aut...&amp;quot;&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=409</id>
		<title>API Dictionary</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=409"/>
		<updated>2023-12-22T16:19:37Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This endpoint is used to list of all the dictionaries tied to your account along with their unique &amp;quot;Dictionary_no&amp;quot;, which you will need as the {id} for using the [[API_Data|Data]] endpoint.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Sidebar&amp;diff=408</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=MediaWiki:Sidebar&amp;diff=408"/>
		<updated>2023-12-22T16:19:07Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;&lt;br /&gt;
* navigation&lt;br /&gt;
** mainpage|mainpage-description&lt;br /&gt;
* Online Admin Portal&lt;br /&gt;
** Admin_Portal|Admin Portal&lt;br /&gt;
** Account_Settings|Manage Account Settings&lt;br /&gt;
** Data_Management|Databases &amp;amp; Managing Uploaded Data&lt;br /&gt;
** Dictionary_Creator|Dictionary Creator&lt;br /&gt;
*** Utility_Supplied_Data|Utility Supplied Data&lt;br /&gt;
** License_Keys|Manage Mobile App Access&lt;br /&gt;
** Manage_Users|Manage User Accounts&lt;br /&gt;
** Update_Payment_Settings|Update Payment Settings&lt;br /&gt;
** Update_Sleep_Status|Update Sleep Status&lt;br /&gt;
** Upload_Data|Upload Modified Data Directly Into Databases&lt;br /&gt;
* Viewing And Sharing Data&lt;br /&gt;
** Viewing And Filtering Data&lt;br /&gt;
** Data_Management#Downloading_Records|Downloading Collected Data&lt;br /&gt;
** Download To Spreadsheet&lt;br /&gt;
** Data_Management#Viewing_Photos|Downloading Photos&lt;br /&gt;
** Data_Management#Export_as_a_Shapefile | Export As Shapefile&lt;br /&gt;
** Share_Maps|Shareable Maps&lt;br /&gt;
* Mobile App&lt;br /&gt;
** App_Setup|Mobile App Setup&lt;br /&gt;
** App_Use|Data Collection&lt;br /&gt;
** App_GPS|Acquiring GPS Coordinates&lt;br /&gt;
* Tips Tricks &amp;amp; Troubleshooting&lt;br /&gt;
** Tips Tricks &amp;amp; Troubleshooting|Tips Tricks &amp;amp; Troubleshooting&lt;br /&gt;
* Mapping Data with External Applications&lt;br /&gt;
** Export_to_ArcGIS | Export to ArcGIS&lt;br /&gt;
** Create_public_map | Create a public map (ArcGIS)&lt;br /&gt;
** QGIS|QGIS&lt;br /&gt;
* Read Only API Access&lt;br /&gt;
** API_Authentication|Authentication&lt;br /&gt;
** API_Responses|Manipulating Responses&lt;br /&gt;
** API_Dictionary|Endpoint: Dictionary Information&lt;br /&gt;
** API_Data|Endpoint: Data&lt;br /&gt;
** API_Photos|Endpoint: Photos&lt;br /&gt;
* Changelogs&lt;br /&gt;
** Admin_portal_changelog|Admin Portal Changelog&lt;br /&gt;
** Mobile_app_changelog|Mobile App Changelog&lt;br /&gt;
* SEARCH&lt;br /&gt;
* TOOLBOX&lt;br /&gt;
* LANGUAGES&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=407</id>
		<title>API Dictionary</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=407"/>
		<updated>2023-12-22T16:16:16Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This endpoint is used to list of all the dictionaries tied to your account along with their unique &amp;quot;Dictionary_no&amp;quot;, which you will need as the {id} for using the [[API_Data|Data]] endpoint.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;br /&gt;
&lt;br /&gt;
==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=406</id>
		<title>API Dictionary</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=406"/>
		<updated>2023-12-22T16:15:27Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This endpoint is used to list of all the dictionaries tied to your account along with their unique &amp;quot;Dictionary_no&amp;quot;, which you will need as the {id} for using the [[API_Data|Data]] endpoint.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;br /&gt;
&lt;br /&gt;
==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;br /&gt;
&lt;br /&gt;
==== Filtering Results ====&lt;br /&gt;
&lt;br /&gt;
If you wish to restrict to multiple values you can use the special term &amp;quot;$in&amp;quot; or &amp;quot;$nin&amp;quot; (not in) like so:&lt;br /&gt;
&lt;br /&gt;
  Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name[$in][]=A&amp;amp;Display_Name[$in][]=I,B&amp;amp;Display_Name[$in][]=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Display_Name%5B%24in%5D%5B%5D=A&amp;amp;Display_Name%5B%24in%5D%5B%5D=I,B&amp;amp;Display_Name%5B%24in%5D%5B%5D=R&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can also use greater than, greater than or equal to, less than, etc&lt;br /&gt;
&lt;br /&gt;
  Dictionary_no[$gte]=55&lt;br /&gt;
  Dictionary_no[$lt]=43&lt;br /&gt;
  Dictionary_no[$eq]=55&lt;br /&gt;
  Dictionary_no[$ne]=55&lt;br /&gt;
  etc&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no[$lt]=43&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
or&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?Dictionary_no%5B%24lt%5D=43&amp;quot;&#039;&#039;&#039;&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
	<entry>
		<id>https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=405</id>
		<title>API Dictionary</title>
		<link rel="alternate" type="text/html" href="https://wiki.goldenretrieverapp.com/index.php?title=API_Dictionary&amp;diff=405"/>
		<updated>2023-12-22T16:10:59Z</updated>

		<summary type="html">&lt;p&gt;Dave: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This endpoint is used to list of all the dictionaries tied to your account along with their unique &amp;quot;Dictionary_no&amp;quot;, which you will need as the {id} for using the [[API_Data|Data]] endpoint.&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
Each response from the API will be in the following JSON format:&lt;br /&gt;
&lt;br /&gt;
  {&lt;br /&gt;
    &amp;quot;message&amp;quot;: &amp;quot;Successful&amp;quot;,&lt;br /&gt;
    &amp;quot;skip&amp;quot;: 0,&lt;br /&gt;
    &amp;quot;limit&amp;quot;: 10,&lt;br /&gt;
    &amp;quot;total&amp;quot;: 15,&lt;br /&gt;
    &amp;quot;data&amp;quot;: []&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
&amp;quot;message&amp;quot; will either be &amp;quot;Successful&amp;quot; or an error message. &amp;quot;skip&amp;quot; is how many records into the query we skipped, &amp;quot;limit&amp;quot; is how many objects we returned. &amp;quot;total&amp;quot; is the total amount of objects that are available. And &amp;quot;data&amp;quot; is an array of objects containing the results.&lt;br /&gt;
&lt;br /&gt;
==== Pagination ====&lt;br /&gt;
&lt;br /&gt;
By default, the results will be paginated in pages of 10 results. To change the amount of results per page (the limit) or the amount of records to skip (the skip) you would add additional URL parameters, beginning with a $ (or %24 when URL encoded)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$limit=2&amp;amp;$skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24limit=2&amp;amp;%24skip=6&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
This will grab two records starting on the 7th record.&lt;br /&gt;
&lt;br /&gt;
==== Sorting ====&lt;br /&gt;
&lt;br /&gt;
You can also sort the records by one of the field names by using the following format:&lt;br /&gt;
&lt;br /&gt;
$sort[CreatedOn]=asc (or when URL encoded: %24sort%5BCreatedOn%5D=asc)&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?$sort[CreatedOn]=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
or&lt;br /&gt;
&lt;br /&gt;
  &#039;&#039;&#039;curl -X GET -H &amp;quot;Content-Type: application/json&amp;quot; -H &amp;quot;authorization: &amp;lt;api_key&amp;gt;&amp;quot; &amp;quot;https://api.thedog.io/dictionary?%24sort%5BCreatedOn%5D=asc&amp;quot;&#039;&#039;&#039;&lt;br /&gt;
&lt;br /&gt;
You can either use &amp;quot;asc&amp;quot; or &amp;quot;desc&amp;quot; for the direction of the sort.&lt;/div&gt;</summary>
		<author><name>Dave</name></author>
	</entry>
</feed>