---
title: "QQ - How do I load JSON data into Datajet?"
slug: "qq-how-do-i-load-json-data-into-datajet"
updated: 2022-09-22T13:26:18Z
published: 2022-09-22T13:26:18Z
canonical: "docs.datajet.app/qq-how-do-i-load-json-data-into-datajet"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# QQ - How do I load JSON data into Datajet?

Use the CreateTableFromJSON method. Use primer to tell the method which data to load.

```json
{
  "method": "CreateTableFromJSON",
  "filename": "%DATAPATH%Demo_Modelling/BikeOverview/BikePoints.JSON",
  "fileIsArray": true,
  "table": "BikePoints",
  "primer": {
    "id": "BikePoints_254",
    "commonName": "Chadwell Street, Angel",
    "placeType": "BikePoint",
    "lat": 51.530515,
    "lon": -0.106408
  },
  "project": "Model1"
}
```

Sample Data:

```json
{
"$type":"Tfl.Api.Presentation.Entities.Place, Tfl.Api.Presentation.Entities",
"id":"BikePoints_254",
"url":"/Place/BikePoints_254",
"commonName":"Chadwell Street, Angel",
"placeType":"BikePoint",
"additionalProperties":[
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"TerminalName","sourceSystemKey":"BikePoints","value":"003471","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"Installed","sourceSystemKey":"BikePoints","value":"true","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"Locked","sourceSystemKey":"BikePoints","value":"false","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"InstallDate","sourceSystemKey":"BikePoints","value":"1279704540000","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"RemovalDate","sourceSystemKey":"BikePoints","value":"","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"Temporary","sourceSystemKey":"BikePoints","value":"false","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"NbBikes","sourceSystemKey":"BikePoints","value":"3","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"NbEmptyDocks","sourceSystemKey":"BikePoints","value":"15","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"NbDocks","sourceSystemKey":"BikePoints","value":"18","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"NbStandardBikes","sourceSystemKey":"BikePoints","value":"3","modified":"2022-09-21T11:42:02.45Z"},
{"$type":"Tfl.Api.Presentation.Entities.AdditionalProperties, Tfl.Api.Presentation.Entities","category":"Description","key":"NbEBikes","sourceSystemKey":"BikePoints","value":"0","modified":"2022-09-21T11:42:02.45Z"}
],
"children":[],
"childrenUrls":[],
"lat":51.530515,
"lon":-0.106408
},
```

Loaded Data:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1663853145370.png)