Usage
/get/{table}
This call will allow you to request data from a database table using a generalised set of commands in the form of a query string.
By default, each successful call will provide pagination information, a http status code, a result count and a table count.
GET /get/user
{
"page": 1,
"total_pages": 5,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?page=2",
"created_at": "March 10 2026 15:13:34",
"status": 200,
"result_count": 100,
"table_count": 100,
"results": [
{
"id": "1",
"first_name": "Les",
"last_name": "Atheis",
"email": "latheis0@ovh.net",
"gender": "Male",
"ip_address": "30.86.221.73"
},
{
"id": "2",
"first_name": "Darrel",
"last_name": "Limbourne",
"email": "dlimbourne1@godaddy.com",
"gender": "Male",
"ip_address": "195.68.24.124"
},
{
"id": "3",
"first_name": "Lonnie",
"last_name": "Kincey",
"email": "lkincey2@timesonline.co.uk",
"gender": "Male",
"ip_address": "139.96.122.90"
},
{
"id": "4",
"first_name": "Shauna",
"last_name": "Rosencrantz",
"email": "srosencrantz3@zimbio.com",
"gender": "Female",
"ip_address": "77.78.106.52"
},
{
"id": "5",
"first_name": "Dita",
"last_name": "Skene",
"email": "dskene4@army.mil",
"gender": "Female",
"ip_address": "30.226.150.139"
},
{
"id": "6",
"first_name": "Reyna",
"last_name": "De Ferraris",
"email": "rdeferraris5@cloudflare.com",
"gender": "Female",
"ip_address": "255.98.225.92"
},
{
"id": "7",
"first_name": "Gaspard",
"last_name": "Donavan",
"email": "gdonavan6@parallels.com",
"gender": "Male",
"ip_address": "143.20.78.224"
},
{
"id": "8",
"first_name": "Daryl",
"last_name": "Lydster",
"email": "dlydster7@nasa.gov",
"gender": "Male",
"ip_address": "38.184.159.113"
},
{
"id": "9",
"first_name": "Leia",
"last_name": "Colcomb",
"email": "lcolcomb8@sbwire.com",
"gender": "Female",
"ip_address": "42.242.226.33"
},
{
"id": "10",
"first_name": "Redd",
"last_name": "O'Sirin",
"email": "rosirin9@squidoo.com",
"gender": "Male",
"ip_address": "28.60.230.46"
},
{
"id": "11",
"first_name": "Francesco",
"last_name": "Ronan",
"email": "fronana@theguardian.com",
"gender": "Male",
"ip_address": "72.198.82.93"
},
{
"id": "12",
"first_name": "Claudetta",
"last_name": "MacConnal",
"email": "cmacconnalb@soup.io",
"gender": "Female",
"ip_address": "126.220.110.65"
},
{
"id": "13",
"first_name": "Prissie",
"last_name": "Sotworth",
"email": "psotworthc@dell.com",
"gender": "Female",
"ip_address": "45.176.141.90"
},
{
"id": "14",
"first_name": "Elly",
"last_name": "Lillico",
"email": "elillicod@prweb.com",
"gender": "Female",
"ip_address": "233.114.255.29"
},
{
"id": "15",
"first_name": "Hephzibah",
"last_name": "Todaro",
"email": "htodaroe@ow.ly",
"gender": "Female",
"ip_address": "120.6.4.75"
},
{
"id": "16",
"first_name": "Waldemar",
"last_name": "Friman",
"email": "wfrimanf@google.com",
"gender": "Male",
"ip_address": "93.38.252.61"
},
{
"id": "17",
"first_name": "Corina",
"last_name": "Devonald",
"email": "cdevonaldg@cdbaby.com",
"gender": "Female",
"ip_address": "188.68.136.79"
},
{
"id": "18",
"first_name": "Corby",
"last_name": "Sancias",
"email": "csanciash@sohu.com",
"gender": "Male",
"ip_address": "190.134.147.144"
},
{
"id": "19",
"first_name": "Devy",
"last_name": "Peele",
"email": "dpeelei@is.gd",
"gender": "Male",
"ip_address": "227.246.79.218"
},
{
"id": "20",
"first_name": "Glenn",
"last_name": "Kleinholz",
"email": "gkleinholzj@bigcartel.com",
"gender": "Female",
"ip_address": "16.207.254.118"
}
]
}
The result count tells you how many total results the specific API query returns, whereas table count tells you the total number of records in the table:
GET /get/user?gender=male
{
"page": 1,
"total_pages": 3,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?gender=male&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?gender=male&page=2",
"created_at": "March 10 2026 15:13:36",
"status": 200,
"result_count": 56,
"table_count": 100,
"results": [
{
"id": "1",
"first_name": "Les",
"last_name": "Atheis",
"email": "latheis0@ovh.net",
"gender": "Male",
"ip_address": "30.86.221.73"
},
{
"id": "2",
"first_name": "Darrel",
"last_name": "Limbourne",
"email": "dlimbourne1@godaddy.com",
"gender": "Male",
"ip_address": "195.68.24.124"
},
{
"id": "3",
"first_name": "Lonnie",
"last_name": "Kincey",
"email": "lkincey2@timesonline.co.uk",
"gender": "Male",
"ip_address": "139.96.122.90"
},
{
"id": "7",
"first_name": "Gaspard",
"last_name": "Donavan",
"email": "gdonavan6@parallels.com",
"gender": "Male",
"ip_address": "143.20.78.224"
},
{
"id": "8",
"first_name": "Daryl",
"last_name": "Lydster",
"email": "dlydster7@nasa.gov",
"gender": "Male",
"ip_address": "38.184.159.113"
},
{
"id": "10",
"first_name": "Redd",
"last_name": "O'Sirin",
"email": "rosirin9@squidoo.com",
"gender": "Male",
"ip_address": "28.60.230.46"
},
{
"id": "11",
"first_name": "Francesco",
"last_name": "Ronan",
"email": "fronana@theguardian.com",
"gender": "Male",
"ip_address": "72.198.82.93"
},
{
"id": "16",
"first_name": "Waldemar",
"last_name": "Friman",
"email": "wfrimanf@google.com",
"gender": "Male",
"ip_address": "93.38.252.61"
},
{
"id": "18",
"first_name": "Corby",
"last_name": "Sancias",
"email": "csanciash@sohu.com",
"gender": "Male",
"ip_address": "190.134.147.144"
},
{
"id": "19",
"first_name": "Devy",
"last_name": "Peele",
"email": "dpeelei@is.gd",
"gender": "Male",
"ip_address": "227.246.79.218"
},
{
"id": "22",
"first_name": "Theo",
"last_name": "Medlin",
"email": "tmedlinl@hugedomains.com",
"gender": "Male",
"ip_address": "171.105.228.41"
},
{
"id": "23",
"first_name": "Phil",
"last_name": "Elland",
"email": "pellandm@wikia.com",
"gender": "Male",
"ip_address": "151.239.95.29"
},
{
"id": "24",
"first_name": "Gordie",
"last_name": "Sandcroft",
"email": "gsandcroftn@altervista.org",
"gender": "Male",
"ip_address": "25.158.30.48"
},
{
"id": "26",
"first_name": "Paton",
"last_name": "Longstaffe",
"email": "plongstaffep@army.mil",
"gender": "Male",
"ip_address": "218.74.165.246"
},
{
"id": "28",
"first_name": "Willy",
"last_name": "Moultrie",
"email": "wmoultrier@hud.gov",
"gender": "Male",
"ip_address": "12.188.52.59"
},
{
"id": "30",
"first_name": "Brantley",
"last_name": "Bleasdille",
"email": "bbleasdillet@wikipedia.org",
"gender": "Male",
"ip_address": "180.129.154.83"
},
{
"id": "31",
"first_name": "Rafi",
"last_name": "Stirzaker",
"email": "rstirzakeru@imageshack.us",
"gender": "Male",
"ip_address": "147.27.139.97"
},
{
"id": "32",
"first_name": "Beauregard",
"last_name": "McCarney",
"email": "bmccarneyv@answers.com",
"gender": "Male",
"ip_address": "242.205.128.86"
},
{
"id": "33",
"first_name": "Benito",
"last_name": "Seckom",
"email": "bseckomw@scribd.com",
"gender": "Male",
"ip_address": "237.107.212.189"
},
{
"id": "38",
"first_name": "Jules",
"last_name": "Archbald",
"email": "jarchbald11@elegantthemes.com",
"gender": "Male",
"ip_address": "76.176.17.235"
}
]
}
Tables can be excluded from this call, and some built-in tables are excluded by default. This can be configured by administrators.
Searching Fields
One or multiple records can be returned by specifying the field name and the value:
GET /get/car?colour=blue&year=2000
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/car?colour=blue&year=2000&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/car?colour=blue&year=2000&page=1",
"created_at": "March 10 2026 15:13:36",
"status": 200,
"result_count": 2,
"table_count": 750,
"results": [
{
"id": "4",
"make": "Volkswagen",
"model": "Jetta",
"year": "2000",
"colour": "Blue",
"money": "£5378.54"
},
{
"id": "344",
"make": "Chrysler",
"model": "Town & Country",
"year": "2000",
"colour": "Blue",
"money": "£1876.76"
}
]
}
GET /get/car?id=20
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/car?id=20&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/car?id=20&page=1",
"created_at": "March 10 2026 15:13:37",
"status": 200,
"result_count": 1,
"table_count": 750,
"results": [
{
"id": "20",
"make": "Mazda",
"model": "Tribute",
"year": "2002",
"colour": "Crimson",
"money": "£10191.00"
}
]
}
Values in searches are case-insensitive by default, so blue, BLUE and bLuE will return the same results.
Selected Fields
Which fields are returned can be set via the fields parameter. This can be a single field name or a comma-separated list of field names.
GET /get/user?fields=email
{
"page": 1,
"total_pages": 5,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?fields=email&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?fields=email&page=2",
"created_at": "March 10 2026 15:13:37",
"status": 200,
"result_count": 100,
"table_count": 100,
"results": [
{
"email": "latheis0@ovh.net"
},
{
"email": "dlimbourne1@godaddy.com"
},
{
"email": "lkincey2@timesonline.co.uk"
},
{
"email": "srosencrantz3@zimbio.com"
},
{
"email": "dskene4@army.mil"
},
{
"email": "rdeferraris5@cloudflare.com"
},
{
"email": "gdonavan6@parallels.com"
},
{
"email": "dlydster7@nasa.gov"
},
{
"email": "lcolcomb8@sbwire.com"
},
{
"email": "rosirin9@squidoo.com"
},
{
"email": "fronana@theguardian.com"
},
{
"email": "cmacconnalb@soup.io"
},
{
"email": "psotworthc@dell.com"
},
{
"email": "elillicod@prweb.com"
},
{
"email": "htodaroe@ow.ly"
},
{
"email": "wfrimanf@google.com"
},
{
"email": "cdevonaldg@cdbaby.com"
},
{
"email": "csanciash@sohu.com"
},
{
"email": "dpeelei@is.gd"
},
{
"email": "gkleinholzj@bigcartel.com"
}
]
}
GET /get/user?fields=first_name,last_name
{
"page": 1,
"total_pages": 5,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?fields=first_name,last_name&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?fields=first_name,last_name&page=2",
"created_at": "March 10 2026 15:13:38",
"status": 200,
"result_count": 100,
"table_count": 100,
"results": [
{
"first_name": "Les",
"last_name": "Atheis"
},
{
"first_name": "Darrel",
"last_name": "Limbourne"
},
{
"first_name": "Lonnie",
"last_name": "Kincey"
},
{
"first_name": "Shauna",
"last_name": "Rosencrantz"
},
{
"first_name": "Dita",
"last_name": "Skene"
},
{
"first_name": "Reyna",
"last_name": "De Ferraris"
},
{
"first_name": "Gaspard",
"last_name": "Donavan"
},
{
"first_name": "Daryl",
"last_name": "Lydster"
},
{
"first_name": "Leia",
"last_name": "Colcomb"
},
{
"first_name": "Redd",
"last_name": "O'Sirin"
},
{
"first_name": "Francesco",
"last_name": "Ronan"
},
{
"first_name": "Claudetta",
"last_name": "MacConnal"
},
{
"first_name": "Prissie",
"last_name": "Sotworth"
},
{
"first_name": "Elly",
"last_name": "Lillico"
},
{
"first_name": "Hephzibah",
"last_name": "Todaro"
},
{
"first_name": "Waldemar",
"last_name": "Friman"
},
{
"first_name": "Corina",
"last_name": "Devonald"
},
{
"first_name": "Corby",
"last_name": "Sancias"
},
{
"first_name": "Devy",
"last_name": "Peele"
},
{
"first_name": "Glenn",
"last_name": "Kleinholz"
}
]
}
Pagination
Pages can be navigated by adjusting the page parameter. Each get call returns pagination information to facilitate navigation. prev_page and next_page return urls to the previous and next page, and will retain the url parameters from the previous query.
GET /get/car?year=2002&page=2
{
"page": 2,
"total_pages": 2,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/car?year=2002&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/car?year=2002&page=2",
"created_at": "March 10 2026 15:13:38",
"status": 200,
"result_count": 39,
"table_count": 750,
"results": [
{
"id": "381",
"make": "Subaru",
"model": "Legacy",
"year": "2002",
"colour": "Red",
"money": "£5013.18"
},
{
"id": "385",
"make": "Mazda",
"model": "Millenia",
"year": "2002",
"colour": "Indigo",
"money": "£4254.73"
},
{
"id": "431",
"make": "Acura",
"model": "CL",
"year": "2002",
"colour": "Fuscia",
"money": "£8004.63"
},
{
"id": "479",
"make": "Toyota",
"model": "Tacoma Xtra",
"year": "2002",
"colour": "Purple",
"money": "£19215.18"
},
{
"id": "485",
"make": "Cadillac",
"model": "Escalade",
"year": "2002",
"colour": "Orange",
"money": "£905.77"
},
{
"id": "491",
"make": "Audi",
"model": "TT",
"year": "2002",
"colour": "Green",
"money": "£2233.82"
},
{
"id": "492",
"make": "Dodge",
"model": "Intrepid",
"year": "2002",
"colour": "Blue",
"money": "£4467.83"
},
{
"id": "498",
"make": "Chevrolet",
"model": "Prizm",
"year": "2002",
"colour": "Purple",
"money": "£13167.52"
},
{
"id": "520",
"make": "Chevrolet",
"model": "Express 3500",
"year": "2002",
"colour": "Red",
"money": "£14669.60"
},
{
"id": "573",
"make": "Honda",
"model": "Civic",
"year": "2002",
"colour": "Maroon",
"money": "£11779.54"
},
{
"id": "589",
"make": "Ford",
"model": "Explorer Sport Trac",
"year": "2002",
"colour": "Red",
"money": "£11140.36"
},
{
"id": "593",
"make": "Dodge",
"model": "Neon",
"year": "2002",
"colour": "Fuscia",
"money": "£393.00"
},
{
"id": "618",
"make": "Acura",
"model": "CL",
"year": "2002",
"colour": "Fuscia",
"money": "£15452.95"
},
{
"id": "634",
"make": "Toyota",
"model": "Camry",
"year": "2002",
"colour": "Red",
"money": "£755.93"
},
{
"id": "672",
"make": "Volkswagen",
"model": "rio",
"year": "2002",
"colour": "Green",
"money": "£575.04"
},
{
"id": "685",
"make": "Chevrolet",
"model": "Astro",
"year": "2002",
"colour": "Fuscia",
"money": "£17963.32"
},
{
"id": "688",
"make": "GMC",
"model": "Sonoma",
"year": "2002",
"colour": "Green",
"money": "£11798.31"
},
{
"id": "698",
"make": "GMC",
"model": "Savana 3500",
"year": "2002",
"colour": "Purple",
"money": "£15388.49"
},
{
"id": "731",
"make": "Lincoln",
"model": "Navigator",
"year": "2002",
"colour": "Pink",
"money": "£9627.95"
}
]
}
Attempting to access a page beyond the maximum number of available pages will result in the last page being returned. Similarly, attempting to access any page number less than 1 will always return the first page.
It is recommended to use the page and total_pages result values to facilitate auto-navigation or API crawling.
By default the API will return a maximum of 20 items per page, however this is configurable by administrators.
Sorting
Results can be sorted by one or multiple fields using the sort parameter. - sorts results in descending order and + sorts in ascending order.
If neither prefix is provided, records will be sorted ascending by default.
GET /get/user?sort=+first_name,-gender
{
"page": 1,
"total_pages": 5,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?sort=+first_name,-gender&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?sort=+first_name,-gender&page=2",
"created_at": "March 10 2026 15:13:39",
"status": 200,
"result_count": 100,
"table_count": 100,
"results": [
{
"id": "57",
"first_name": "Alard",
"last_name": "Loxly",
"email": "aloxly1k@pbs.org",
"gender": "Male",
"ip_address": "30.209.119.140"
},
{
"id": "90",
"first_name": "Albie",
"last_name": "Highton",
"email": "ahighton2h@nytimes.com",
"gender": "Male",
"ip_address": "122.221.216.81"
},
{
"id": "100",
"first_name": "Aleta",
"last_name": "McCray",
"email": "amccray2r@hubpages.com",
"gender": "Female",
"ip_address": "194.98.45.205"
},
{
"id": "88",
"first_name": "Alexei",
"last_name": "Lidgerton",
"email": "alidgerton2f@php.net",
"gender": "Male",
"ip_address": "3.115.118.87"
},
{
"id": "69",
"first_name": "Antoni",
"last_name": "Feenan",
"email": "afeenan1w@w3.org",
"gender": "Male",
"ip_address": "211.158.88.72"
},
{
"id": "76",
"first_name": "Ashlan",
"last_name": "O'Brien",
"email": "aobrien23@dion.ne.jp",
"gender": "Female",
"ip_address": "237.42.206.217"
},
{
"id": "32",
"first_name": "Beauregard",
"last_name": "McCarney",
"email": "bmccarneyv@answers.com",
"gender": "Male",
"ip_address": "242.205.128.86"
},
{
"id": "33",
"first_name": "Benito",
"last_name": "Seckom",
"email": "bseckomw@scribd.com",
"gender": "Male",
"ip_address": "237.107.212.189"
},
{
"id": "61",
"first_name": "Benn",
"last_name": "Tarpey",
"email": "btarpey1o@earthlink.net",
"gender": "Male",
"ip_address": "183.132.46.77"
},
{
"id": "30",
"first_name": "Brantley",
"last_name": "Bleasdille",
"email": "bbleasdillet@wikipedia.org",
"gender": "Male",
"ip_address": "180.129.154.83"
},
{
"id": "25",
"first_name": "Celestina",
"last_name": "Mathiasen",
"email": "cmathiaseno@miibeian.gov.cn",
"gender": "Female",
"ip_address": "4.135.27.124"
},
{
"id": "46",
"first_name": "Chadd",
"last_name": "Bertot",
"email": "cbertot19@printfriendly.com",
"gender": "Male",
"ip_address": "79.10.167.78"
},
{
"id": "27",
"first_name": "Chere",
"last_name": "Belford",
"email": "cbelfordq@constantcontact.com",
"gender": "Female",
"ip_address": "7.227.94.149"
},
{
"id": "34",
"first_name": "Christian",
"last_name": "Sex",
"email": "csexx@devhub.com",
"gender": "Female",
"ip_address": "135.238.9.116"
},
{
"id": "12",
"first_name": "Claudetta",
"last_name": "MacConnal",
"email": "cmacconnalb@soup.io",
"gender": "Female",
"ip_address": "126.220.110.65"
},
{
"id": "18",
"first_name": "Corby",
"last_name": "Sancias",
"email": "csanciash@sohu.com",
"gender": "Male",
"ip_address": "190.134.147.144"
},
{
"id": "17",
"first_name": "Corina",
"last_name": "Devonald",
"email": "cdevonaldg@cdbaby.com",
"gender": "Female",
"ip_address": "188.68.136.79"
},
{
"id": "2",
"first_name": "Darrel",
"last_name": "Limbourne",
"email": "dlimbourne1@godaddy.com",
"gender": "Male",
"ip_address": "195.68.24.124"
},
{
"id": "8",
"first_name": "Daryl",
"last_name": "Lydster",
"email": "dlydster7@nasa.gov",
"gender": "Male",
"ip_address": "38.184.159.113"
},
{
"id": "99",
"first_name": "Dayna",
"last_name": "Corbridge",
"email": "dcorbridge2q@51.la",
"gender": "Female",
"ip_address": "47.143.138.247"
}
]
}
Wildcard Searches
More fine-tuned searches are possible via the use of wildcards.
Searches are performed by setting the like parameter to one or multiple fields in a comma-seperated list in the following format: fieldname:expression.
The * wild card means "zero or more characters":
GET /get/user?like=first_name:*ul*,gender:ma*
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?like=first_name:%2Aul%2A,gender:ma%2A&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?like=first_name:%2Aul%2A,gender:ma%2A&page=1",
"created_at": "March 10 2026 15:13:39",
"status": 200,
"result_count": 2,
"table_count": 100,
"results": [
{
"id": "38",
"first_name": "Jules",
"last_name": "Archbald",
"email": "jarchbald11@elegantthemes.com",
"gender": "Male",
"ip_address": "76.176.17.235"
},
{
"id": "42",
"first_name": "Hercule",
"last_name": "Gait",
"email": "hgait15@examiner.com",
"gender": "Male",
"ip_address": "37.144.144.235"
}
]
}
GET /get/user?like=email:*co.uk
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?like=email:%2Aco.uk&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?like=email:%2Aco.uk&page=1",
"created_at": "March 10 2026 15:13:40",
"status": 200,
"result_count": 2,
"table_count": 100,
"results": [
{
"id": "3",
"first_name": "Lonnie",
"last_name": "Kincey",
"email": "lkincey2@timesonline.co.uk",
"gender": "Male",
"ip_address": "139.96.122.90"
},
{
"id": "98",
"first_name": "Jeana",
"last_name": "Lailey",
"email": "jlailey2p@ebay.co.uk",
"gender": "Female",
"ip_address": "33.180.115.239"
}
]
}
Wildcard searches can be used in conjunction with normal field searches, however if the same field is referenced twice, the normal field search will be ignored.
The _ wildcard can be used to mean "any single character":
GET /get/user?like=first_name:a_____
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?like=first_name:a_____&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?like=first_name:a_____&page=1",
"created_at": "March 10 2026 15:13:40",
"status": 200,
"result_count": 3,
"table_count": 100,
"results": [
{
"id": "69",
"first_name": "Antoni",
"last_name": "Feenan",
"email": "afeenan1w@w3.org",
"gender": "Male",
"ip_address": "211.158.88.72"
},
{
"id": "76",
"first_name": "Ashlan",
"last_name": "O'Brien",
"email": "aobrien23@dion.ne.jp",
"gender": "Female",
"ip_address": "237.42.206.217"
},
{
"id": "88",
"first_name": "Alexei",
"last_name": "Lidgerton",
"email": "alidgerton2f@php.net",
"gender": "Male",
"ip_address": "3.115.118.87"
}
]
}
Regular Expression Searches
Regular Expression searches provide the most complex level of searching within the API.
Searches are performed by setting the regexp parameter to one or multiple fields in a comma-separated list in the following format: fieldname:expression.
Please see relevant documentation on regular expressions for more information.
This call returns cars with the years 2006, 2007, 2008 and 2009, and any car with the colour 'yellow' or 'blue'.
GET /get/car?regexp=year:^200[678],colour:yellow|blue
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/car?regexp=year:%5E200%5B678%5D,colour:yellow%7Cblue&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/car?regexp=year:%5E200%5B678%5D,colour:yellow%7Cblue&page=1",
"created_at": "March 10 2026 15:13:41",
"status": 200,
"result_count": 21,
"table_count": 750,
"results": [
{
"id": "2",
"make": "Volkswagen",
"model": "Touareg 2",
"year": "2008",
"colour": "Yellow",
"money": "£7779.01"
},
{
"id": "33",
"make": "Audi",
"model": "S4",
"year": "2008",
"colour": "Blue",
"money": "£9425.88"
},
{
"id": "76",
"make": "Dodge",
"model": "Avenger",
"year": "2008",
"colour": "Yellow",
"money": "£4123.66"
},
{
"id": "85",
"make": "Mercury",
"model": "Grand Marquis",
"year": "2008",
"colour": "Yellow",
"money": "£10107.45"
},
{
"id": "99",
"make": "Aston Martin",
"model": "DB9",
"year": "2008",
"colour": "Blue",
"money": "£13103.50"
},
{
"id": "196",
"make": "Mercedes-Benz",
"model": "R-Class",
"year": "2007",
"colour": "Yellow",
"money": "£17112.71"
},
{
"id": "201",
"make": "Hyundai",
"model": "Tucson",
"year": "2006",
"colour": "Yellow",
"money": "£16877.03"
},
{
"id": "227",
"make": "Chevrolet",
"model": "Express",
"year": "2008",
"colour": "Yellow",
"money": "£16472.66"
},
{
"id": "233",
"make": "GMC",
"model": "Yukon Denali",
"year": "2006",
"colour": "Yellow",
"money": "£595.27"
},
{
"id": "284",
"make": "Volkswagen",
"model": "New Beetle",
"year": "2007",
"colour": "Blue",
"money": "£12033.92"
},
{
"id": "286",
"make": "Mercedes-Benz",
"model": "R-Class",
"year": "2008",
"colour": "Yellow",
"money": "£19941.15"
},
{
"id": "299",
"make": "Chrysler",
"model": "PT Cruiser",
"year": "2006",
"colour": "Yellow",
"money": "£17926.74"
},
{
"id": "322",
"make": "Audi",
"model": "S6",
"year": "2007",
"colour": "Blue",
"money": "£2531.41"
},
{
"id": "360",
"make": "Mitsubishi",
"model": "Outlander",
"year": "2007",
"colour": "Yellow",
"money": "£10738.95"
},
{
"id": "414",
"make": "Ford",
"model": "Explorer",
"year": "2008",
"colour": "Blue",
"money": "£19911.60"
},
{
"id": "426",
"make": "Scion",
"model": "tC",
"year": "2007",
"colour": "Blue",
"money": "£19569.44"
},
{
"id": "466",
"make": "Maserati",
"model": "Quattroporte",
"year": "2008",
"colour": "Yellow",
"money": "£5127.56"
},
{
"id": "505",
"make": "Ford",
"model": "Crown Victoria",
"year": "2008",
"colour": "Yellow",
"money": "£2775.59"
},
{
"id": "565",
"make": "Cadillac",
"model": "Escalade",
"year": "2006",
"colour": "Yellow",
"money": "£4656.33"
},
{
"id": "683",
"make": "Nissan",
"model": "Maxima",
"year": "2008",
"colour": "Blue",
"money": "£10539.95"
}
]
}
This call returns all users with a first name beginning with 'al'
GET /get/user?regexp=first_name:^al.*
{
"page": 1,
"total_pages": 1,
"per_page": 20,
"prev_page": "https://api7.projectfolder.dev/api/get/user?regexp=first_name:%5Eal.%2A&page=1",
"next_page": "https://api7.projectfolder.dev/api/get/user?regexp=first_name:%5Eal.%2A&page=1",
"created_at": "March 10 2026 15:13:42",
"status": 200,
"result_count": 4,
"table_count": 100,
"results": [
{
"id": "57",
"first_name": "Alard",
"last_name": "Loxly",
"email": "aloxly1k@pbs.org",
"gender": "Male",
"ip_address": "30.209.119.140"
},
{
"id": "88",
"first_name": "Alexei",
"last_name": "Lidgerton",
"email": "alidgerton2f@php.net",
"gender": "Male",
"ip_address": "3.115.118.87"
},
{
"id": "90",
"first_name": "Albie",
"last_name": "Highton",
"email": "ahighton2h@nytimes.com",
"gender": "Male",
"ip_address": "122.221.216.81"
},
{
"id": "100",
"first_name": "Aleta",
"last_name": "McCray",
"email": "amccray2r@hubpages.com",
"gender": "Female",
"ip_address": "194.98.45.205"
}
]
}
/tables
To see what tables are available in the API, you can call /tables:
GET /tables
{
"created_at": "March 10 2026 15:13:42",
"status": 200,
"results": [
{
"animal": "https://api7.projectfolder.dev/api/get/animal",
"car": "https://api7.projectfolder.dev/api/get/car",
"user": "https://api7.projectfolder.dev/api/get/user"
}
]
}
Tables can be excluded from this call, and some built-in tables are excluded by default. This can be configured by administrators.
/fields/{table}
Calling /fields/{table} table with an existing database table will return all the fields of that table.
GET /fields/user
{
"created_at": "March 10 2026 15:13:43",
"status": 200,
"results": [
[
"id",
"first_name",
"last_name",
"email",
"gender",
"ip_address"
]
]
}
Tables can be excluded from this call, and some built-in tables are excluded by default. This can be configured by administrators.
/limits
Calling /limits will return information regarding an end-client's specific usage limit. Please see the section on Rate limiting for more details.
GET /limits
{
"created_at": "March 10 2026 15:13:43",
"status": 200,
"results": {
"allowance": 40,
"requests": 1,
"remaining": 39,
"ttl": 3600,
"allowance_reset": "47 minutes"
}
}
'created_at'
The 'created_at' value of an API response will tell you when the result was generated. If caching is disabled, this will be the time of the request, otherwise it will be the time that the particular query was cached.
Please see the section on Caching for more details.
Response Format
By default all API calls will be returned as JSON, however XML is also supported:
GET /fields/car?format=xml
<?xml version="1.0" ?>
<root>
<created_at>March 10 2026 15:13:44</created_at>
<status>200</status>
<results>
<item>
<value>id</value>
<value>make</value>
<value>model</value>
<value>year</value>
<value>colour</value>
<value>money</value>
</item>
</results>
</root>
GET /get/car?format=xml
<?xml version="1.0" ?>
<root>
<page>1</page>
<total_pages>38</total_pages>
<per_page>20</per_page>
<prev_page>https://api7.projectfolder.dev/api/get/car?format=xml&page=1</prev_page>
<next_page>https://api7.projectfolder.dev/api/get/car?format=xml&page=2</next_page>
<created_at>March 10 2026 15:13:44</created_at>
<status>200</status>
<result_count>750</result_count>
<table_count>750</table_count>
<results>
<item>
<id>1</id>
<make>Hummer</make>
<model>H2</model>
<year>2003</year>
<colour>Fuscia</colour>
<money>£7955.01</money>
</item>
<item>
<id>2</id>
<make>Volkswagen</make>
<model>Touareg 2</model>
<year>2008</year>
<colour>Yellow</colour>
<money>£7779.01</money>
</item>
<item>
<id>3</id>
<make>GMC</make>
<model>Safari</model>
<year>2004</year>
<colour>Maroon</colour>
<money>£3423.46</money>
</item>
<item>
<id>4</id>
<make>Volkswagen</make>
<model>Jetta</model>
<year>2000</year>
<colour>Blue</colour>
<money>£5378.54</money>
</item>
<item>
<id>5</id>
<make>Hyundai</make>
<model>Sonata</model>
<year>2009</year>
<colour>Maroon</colour>
<money>£3619.37</money>
</item>
<item>
<id>6</id>
<make>Dodge</make>
<model>Ram 2500</model>
<year>2003</year>
<colour>Khaki</colour>
<money>£14147.46</money>
</item>
<item>
<id>7</id>
<make>Ford</make>
<model>Bronco II</model>
<year>1990</year>
<colour>Crimson</colour>
<money>£13272.68</money>
</item>
<item>
<id>8</id>
<make>Hyundai</make>
<model>Sonata</model>
<year>1996</year>
<colour>Khaki</colour>
<money>£4388.28</money>
</item>
<item>
<id>9</id>
<make>Bentley</make>
<model>Continental Super</model>
<year>2011</year>
<colour>Indigo</colour>
<money>£18401.46</money>
</item>
<item>
<id>10</id>
<make>Chevrolet</make>
<model>Lumina</model>
<year>1992</year>
<colour>Red</colour>
<money>£10965.42</money>
</item>
<item>
<id>11</id>
<make>Pontiac</make>
<model>Grand Prix</model>
<year>1970</year>
<colour>Blue</colour>
<money>£13963.02</money>
</item>
<item>
<id>12</id>
<make>Toyota</make>
<model>Prius</model>
<year>2011</year>
<colour>Green</colour>
<money>£5765.01</money>
</item>
<item>
<id>13</id>
<make>Mercedes-Benz</make>
<model>S-Class</model>
<year>2007</year>
<colour>Goldenrod</colour>
<money>£3564.03</money>
</item>
<item>
<id>14</id>
<make>Jeep</make>
<model>Grand Cherokee</model>
<year>2009</year>
<colour>Yellow</colour>
<money>£4535.48</money>
</item>
<item>
<id>15</id>
<make>Lamborghini</make>
<model>Gallardo</model>
<year>2005</year>
<colour>Teal</colour>
<money>£10502.26</money>
</item>
<item>
<id>16</id>
<make>Mitsubishi</make>
<model>Lancer Evolution</model>
<year>2008</year>
<colour>Khaki</colour>
<money>£6627.44</money>
</item>
<item>
<id>17</id>
<make>Mercedes-Benz</make>
<model>S-Class</model>
<year>2012</year>
<colour>Green</colour>
<money>£207.24</money>
</item>
<item>
<id>18</id>
<make>Mazda</make>
<model>B2000</model>
<year>1985</year>
<colour>Orange</colour>
<money>£8320.62</money>
</item>
<item>
<id>19</id>
<make>Suzuki</make>
<model>Daewoo Lacetti</model>
<year>2004</year>
<colour>Mauv</colour>
<money>£9744.97</money>
</item>
<item>
<id>20</id>
<make>Mazda</make>
<model>Tribute</model>
<year>2002</year>
<colour>Crimson</colour>
<money>£10191.00</money>
</item>
</results>
</root>
GET /get/car?id=test&format=xml
<?xml version="1.0" ?>
<root>
<error>resource 'car' with supplied search parameters does not exist</error>
<status>400</status>
</root>
Errors
Errors will return an 'error' and a 'status' code:
GET /get/fruit
{
"error": "resource 'fruit' does not exist",
"status": 400
}
GET /find
{
"error": "Not found.",
"status": 404
}
GET /get/user?id=test
{
"error": "resource 'user' with supplied search parameters does not exist",
"status": 400
}