CSV

get all csv

get

Authorizations

Query parameters

orderbystringOptional

Sorting parameter Available values : entity fields Default value : id

Example: id

orderstringOptional

Sorting parameter Available values : [ASC,DESC] Default value : ASC

Example: Desc

limitinteger · int32Optional

Paging parameter Default value : null

Example: 2

offsetinteger · int32Optional

Paging parameter Default value : 0

Example: 3

columnsstringOptional

Filter parameter check the columns value

Example: col1,col2

maps_tointeger · int32Optional

Filter parameter check the maps_to value

Example: 2

fixedinteger · int32Optional

Filter parameter check the fixed value

Example: 1

filenamestringOptional

Filter parameter check the filename value

Example: file.csv

Responses

200

OK

application/json

401

Unauthorized

application/json

get

HTTPcURLJavaScriptPython

GET /api/v3/csv HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "count": 1,
  "results": [
    {
      "id": 1,
      "url": "http://localhost:8000/api/v3/csv/1",
      "columns": [
        "col1,col2"
      ],
      "filename": "file.csv",
      "mime": "csv",
      "size": 200,
      "created": "1970-01-01T00:00:00+00:00",
      "allowed_privileges": [
        "read",
        "create",
        "update",
        "delete",
        "search"
      ]
    }
  ],
  "offset": 0,
  "order": "asc",
  "orderby": "id",
  "curr": "http://localhost:8000/api/v3/csv?orderby=id&order=asc&offset=0",
  "next": "http://localhost:8000/api/v3/csv?orderby=id&order=asc&offset=0",
  "prev": "http://localhost:8000/api/v3/csv?orderby=id&order=asc&offset=0",
  "total_count": 1
}

add csv

POST https://ushahididocs.api.ushahidi.io/api/v3/csv

Request Body

Name	Type	Description
file	String	CSV file
size	String	CSV file size

200: OK

{
    "id": 1,
    "url": "http://localhost:8000/api/v3/csv/1",
    "columns": [
        "col1,col2"
    ],
    "maps_to": null,
    "fixed": null,
    "filename": "file.csv",
    "mime": "csv",
    "size": 22,
    "created": "1970-01-01T00:00:00+00:00",
    "updated": "2022-11-03T23:14:31+00:00",
    "completed": null,
    "status": null,
    "errors": null,
    "processed": null,
    "collection_id": null,
    "allowed_privileges": [
        "read",
        "create",
        "update",
        "delete",
        "search"
    ]
}

add csv

PUT https://ushahididocs.api.ushahidi.io/api/v3/csv/1

Request Body

Name	Type	Description
file	String	CSV file
size	String	CSV file size

200: OK

{
    "id": 1,
    "url": "http://localhost:8000/api/v3/csv/1",
    "columns": [
        "col1,col2"
    ],
    "maps_to": null,
    "fixed": null,
    "filename": "file.csv",
    "mime": "csv",
    "size": 22,
    "created": "1970-01-01T00:00:00+00:00",
    "updated": "2022-11-03T23:14:31+00:00",
    "completed": null,
    "status": null,
    "errors": null,
    "processed": null,
    "collection_id": null,
    "allowed_privileges": [
        "read",
        "create",
        "update",
        "delete",
        "search"
    ]
}

get csv

get

Authorizations

Responses

200

OK

application/json

401

Unauthorized

application/json

404

Not Found

application/json

get

HTTPcURLJavaScriptPython

GET /api/v3/csv/20 HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "id": 2,
  "url": "http://localhost:8000/api/v3/csv/2",
  "columns": [
    "col3,col4"
  ],
  "filename": "file.csv",
  "mime": "csv",
  "size": 100,
  "created": "1970-01-01T00:00:00+00:00",
  "allowed_privileges": [
    "read",
    "create",
    "update",
    "delete",
    "search"
  ]
}

deletecsv

delete

Authorizations

Responses

200

OK

application/json

401

Unauthorized

application/json

404

Not Found

application/json

delete

HTTPcURLJavaScriptPython

DELETE /api/v3/csv/1 HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "id": 2,
  "url": "http://localhost:8000/api/v3/csv/2",
  "columns": [
    "col3,col4"
  ],
  "filename": "file.csv",
  "mime": "csv",
  "size": 100,
  "created": "1970-01-01T00:00:00+00:00",
  "allowed_privileges": [
    "read",
    "create",
    "update",
    "delete",
    "search"
  ]
}

import csv

post

Authorizations

Responses

200Success

post

HTTPcURLJavaScriptPython

POST /api/v3/csv/2/import HTTP/1.1
Host: ushahididocs.api.ushahidi.io
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

200Success

No content