ArcGIS Online query related records workflow

Query related records.md

Query related records - ArcGIS Online workflow

Example service used: Best Practices_WFL1

Initial load

1. Query the Feature Service to get details (including layer names and IDs):

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer?f=json

2. Query layer 0 details (including relationships details)

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/0?f=json

For example, layer 0:

{
	"relationships": [{
		"id": 0,
		"name": "BP - Sites",
		"relatedTableId": 1,
		"cardinality": "esriRelCardinalityOneToOne",
		"role": "esriRelRoleOrigin",
		"keyField": "GPS_Latitude_D",
		"composite": false
	}]
}

3. Query how many records layer 0 has:

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/0/query?f=json&returnIdsOnly=true&returnCountOnly=true&where=1%3D1&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&cacheHint=true

4. Get all records from layer 0 (but in PBF; for perfomance):

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/0/query?f=html&where=1%3D1&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&orderByFields=OBJECTID%20ASC&resultOffset=0&resultRecordCount=50&cacheHint=true&quantizationParameters=%7B%22mode%22%3A%22edit%22%7D

5. Query the Feature Service (Layer 0) to find out how many related records using queryRelatedRecords. Each record have:

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/0/queryRelatedRecords?f=json&objectIds=1%2C2%2C3%2C4%2C5%2C6%2C7%2C8%2C9%2C10%2C11%2C12%2C13%2C14%2C15%2C16%2C17%2C18%2C19%2C20%2C21%2C22%2C23%2C24%2C25%2C26%2C27%2C28%2C29%2C30%2C31%2C32%2C33%2C34%2C35%2C36%2C37%2C38%2C39%2C40%2C41%2C42%2C43%2C44%2C45%2C46%2C47%2C48%2C49%2C50&outFields=*&returnGeometry=false&relationshipId=0&returnCountOnly=true

Click to show a related record

Note: in this example the record with Unique ID BP155 was clicked, it's properties are:

{
      "attributes" : {
        "OBJECTID" : 1, 
        "Unique_ID" : "BP155", 
        "Created_on" : 1557653940000, 
        "Created_by" : "Juhan Telgmaa", 
        "Title_of_the_best_practice" : "Envi educcation", 
        "Excerpt" : "Better availability of info related to different envi aspects of beach and surroundings.", 
        "Country" : "Estonia", 
        "Type_of_site" : "beach", 
        "Field" : "Environmental Education; Information", 
        "Blue_Flag_site" : "BF4940 Pirita", 
        "GPS_Longitude" : "24.828698", 
        "GPS_Latitude" : "59.469819", 
        "GPS_Longitude_D" : 24.828698, 
        "GPS_Latitude_D" : 59.469819, 
        "Management_Body" : "Pirita district government of City of Tallinn", 
        "Methodology" : "The pamphlets are made available by QR code for phones. No need to waste paper for printed work, no need to collect and recycling of garbage, more info available, easy to add or uptodate info.", 
        "Related_Website" : null, 
        "Title_Image__Hero_" : "Pirita buklett 1.PNG", 
        "Description_Images__Carrousel_" : "Pirita buklett 2.PNG", 
        "Contact_for_further_information" : "Pirita district government", 
        "This_best_practice_participates" : "6 Clean Water and sanitation; 11 Sustainable cities and communities; 12 Responsible consumption and production", 
        "Tags" : null
      }
    }

Note the value of the relationship keyfield GPS_Latitude" : "59.469819".

1. Start by getting details from layer 1:

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/1?f=json

2. Query again all record from layer 0: (not sure why)

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/0/query?f=html&where=1%3D1&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&orderByFields=OBJECTID%20ASC&resultOffset=0&resultRecordCount=50&cacheHint=true&quantizationParameters=%7B%22mode%22%3A%22edit%22%7D

3. Query the related record (query agains layer 1 by setting relationship keyfield value)

https://services9.arcgis.com/JAEHQgpk7zTHeZED/arcgis/rest/services/Best_Practices_WFL1/FeatureServer/1/query?f=html&outFields=*&returnGeometry=false&where=Latitude%3D%2759.469819%27

Note: "where" clause -> Latitude='59.469819'