exampleQueries.graphql

mutation 
{ 

populateCartoDataResources (
        resources:[
                {   
                        type: "cartodb"
                        resourceHandle: "byServiceName"
                        url: "https://phl.carto.com/api/v2/sql"
                        q: "?q=SELECT service_name, COUNT(cartodb_id) FROM public_cases_fc WHERE service_name NOT IN ('Information Request') GROUP BY service_name ORDER BY count DESC"
                }   
        ],  
        dataFields: [
                {   
                        resourceHandle: "byServiceName"
                        field: "service_name"
                        type: "STRING"
                },  
                {   
                        resourceHandle: "byServiceName"
                        field: "count"
                        type: "INTEGER"
                }   
        ]   
)
        {   
                type
        }  
}

{ 
getComponents (
  	components: [
      {
        type: "Nvd3Chart", resourceHandle: "byServiceName", dataFields: [
    			{field: "service_name", resourceHandle: "byServiceName", fieldHandle: "x", type: "STRING"},
    			{field: "count", resourceHandle: "byServiceName", fieldHandle: "y", type: "INTEGER"},
        ],
        where: "{\"count\": {\"$lte\": 10}}",
        order: "[[\"count\",\"DESC\"]]" 
  		}
		] 
	) 
  {
  	type
    data {
      JSONResponse
      total_rows
      time
      fields {
        field
        type
      }
    }
	}
}