Data.Police.UK

Open data about crime and policing in England, Wales and Northern Ireland.

Integrate the Data.Police.UK API with the MongoDB API

Setup the Data.Police.UK API trigger to run a workflow which integrates with the MongoDB API. Pipedream's integration platform allows you to integrate Data.Police.UK and MongoDB remarkably fast. Free for developers.

Create New Document with MongoDB API on New Crime Reported from Data.Police.UK API
Data.Police.UK + MongoDB
 
Try it
Create New Document with MongoDB API on New Street Level Crime Updated from Data.Police.UK API
Data.Police.UK + MongoDB
 
Try it
Delete a Document with MongoDB API on New Crime Reported from Data.Police.UK API
Data.Police.UK + MongoDB
 
Try it
Delete a Document with MongoDB API on New Street Level Crime Updated from Data.Police.UK API
Data.Police.UK + MongoDB
 
Try it
Execute Aggregation with MongoDB API on New Crime Reported from Data.Police.UK API
Data.Police.UK + MongoDB
 
Try it
New Crime Reported from the Data.Police.UK API

Emit new event when a new crime is reported in a specific area.

 
Try it
New Street Level Crime Updated from the Data.Police.UK API

Emit new event when a specific street level crime is updated.

 
Try it
New Collection from the MongoDB API

Emit new an event when a new collection is added to a database

 
Try it
New Database from the MongoDB API

Emit new an event when a new database is added

 
Try it
New Document from the MongoDB API

Emit new an event when a new document is added to a collection

 
Try it
Fetch Forces with the Data.Police.UK API

Get a list of police forces and contact information within a particular area. See the docs here

 
Try it
Create New Document with the MongoDB API

Create a new document in a collection of your choice. See the docs here

 
Try it
Delete a Document with the MongoDB API

Delete a single document by ID. See the docs here

 
Try it
Execute Aggregation with the MongoDB API

Execute an aggregation pipeline on a MongoDB collection. See the documentation

 
Try it
Obtain Crime Outcomes with the Data.Police.UK API

Access the specific outcomes of reported crimes within a given location and date range. See the docs here

 
Try it

Overview of Data.Police.UK

The Data.Police.UK API provides access to a wide array of UK crime data, allowing users to query information about street-level crimes, outcomes, and the location of police stations. You can leverage this data within Pipedream to build automated workflows that react to new data, analyze crime trends, or integrate with other services to enhance public awareness and safety. With Pipedream, you can create serverless workflows that connect Data.Police.UK API with other apps to streamline tasks, generate reports, or trigger alerts based on crime data.

Connect Data.Police.UK

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    data_police_uk: {
      type: "app",
      app: "data_police_uk",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://data.police.uk/api/forces`,
    })
  },
})

Overview of MongoDB

The MongoDB API provides powerful capabilities to interact with a MongoDB database, allowing you to perform CRUD (Create, Read, Update, Delete) operations, manage databases, and execute sophisticated queries. With Pipedream, you can harness these abilities to automate tasks, sync data across various apps, and react to events in real-time. It’s a combo that’s particularly potent for managing data workflows, syncing application states, or triggering actions based on changes to your data.

Connect MongoDB

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import mongodb from 'mongodb'

export default defineComponent({
  props: {
    mongodb: {
      type: "app",
      app: "mongodb",
    },
    collection: {
      type: "string"
    },
    filter: {
      type: "object"
    }
  },
  async run({steps, $}) {
    const MongoClient = mongodb.MongoClient
    
    const {
      database,
      hostname,
      username,
      password,
    } = this.mongodb.$auth
    
    const url = `mongodb+srv://${username}:${password}@${hostname}/test?retryWrites=true&w=majority`
    const client = await MongoClient.connect(url, { 
      useNewUrlParser: true, 
      useUnifiedTopology: true 
    })
    
    const db = client.db(database)

    const results = await db.collection(this.collection).find(this.filter).toArray();
    $.export('results', results);
    
    await client.close()
  },
})