JSON data from api

I’d like to be able to pick out each school name and save to fields in the database identified as “elementary” "middle " and “high”. Each school will be associated with a property. Stumped as to how to achieve this. Here is an example of the raw data:

        "schools": [
        {
            "assigned": null,
            "distance": 0.8,
            "grades": "K-5",
            "isAssigned": true,
            "level": "Elementary",
            "link": "https://www.greatschools.org/school?id=17072&state=CA",
            "name": "San Elijo Elementary School",
            "rating": 8,
            "size": 1053,
            "studentsPerTeacher": 24,
            "totalCount": 1,
            "type": "Public"
        },
        {
            "assigned": null,
            "distance": 0.6,
            "grades": "6-8",
            "isAssigned": true,
            "level": "Middle",
            "link": "https://www.greatschools.org/school?id=13780&state=CA",
            "name": "San Elijo Middle School",
            "rating": 8,
            "size": 1838,
            "studentsPerTeacher": 28,
            "totalCount": 1,
            "type": "Public"
        },
        {
            "assigned": null,
            "distance": 2,
            "grades": "9-12",
            "isAssigned": true,
            "level": "High",
            "link": "https://www.greatschools.org/school?id=06266&state=CA",
            "name": "San Marcos High School",
            "rating": 7,
            "size": 3439,
            "studentsPerTeacher": 37,
            "totalCount": 1,
            "type": "Public"
        }
    ],
  1. Get the data via the API.
  2. Loop the list using “Schedule workflow over list”.
  3. Setup the workflow in the Backend workflows.
  4. Call the action “Create a new things” and save the data into db

Ankur@ Nocodetalks
Looking for a Bubble Coach? Check out here