{"type":"doc","content":[{"type":"paragraph","content":[{"text":"This document provides reference materials for using the dRofus REST API for data from a given database. For the database management REST API, se this: ","type":"text"},{"text":"Admin system REST API","type":"text","marks":[{"type":"link","attrs":{"href":"https://drofus.atlassian.net/wiki/spaces/DV/pages/1319502622"}}]}]},{"type":"paragraph","content":[{"text":"This API is providing an ","type":"text"},{"text":"Open API specification","type":"text","marks":[{"type":"link","attrs":{"href":"https://en.wikipedia.org/wiki/OpenAPI_Specification"}}]},{"text":" describing the API. We also have an interactive GUI that lets you explore this API and try it out in the browser. Since we expose and document how to get database/project specific properties we require you to login to see the documentation. See Authentication below.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Provide feedback","type":"text"}]},{"type":"paragraph","content":[{"text":"Do not hesitate to contact us and provide feedback on what use cases you would like to use the API for.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"URLS","type":"text"}]},{"type":"paragraph","content":[{"text":"The API is currently deployed to the following locations. More will follow. The API documentation will expose project specific properties so you need to log in to see it. Please see ","type":"text"},{"text":"dRofus REST API#Authentication","type":"text","marks":[{"type":"link","attrs":{"href":"https://drofus.atlassian.net/wiki/pages/resumedraft.action?draftId=1353155957#dRofusRESTAPI-Authentication"}}]},{"text":" section below for how to connect with your dRofus username and password.","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"af3d2055-d7dd-4a03-9d4b-182ffd756b45"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"URL","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Swagger Gui","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Swagger JSON","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"https://api-no.drofus.com","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"API documentation and test it in web GUI","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-no.drofus.com/swagger"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Open API Specification","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-no.drofus.com/swagger/v1/swagger.json"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"use for db2.nosyko.no projects","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"https://api-eu.drofus.com","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"API documentation and test it in web GUI","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-eu.drofus.com/swagger"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Open API Specification","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-eu.drofus.com/swagger/v1/swagger.json"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"https://api-ca.drofus.com","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"API documentation and test it in web GUI","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-ca.drofus.com/swagger"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Open API Specification","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-ca.drofus.com/swagger/v1/swagger.json"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"https://api-us.drofus.com","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"API documentation and test it in web GUI","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-us.drofus.com/swagger"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Open API Specification","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-us.drofus.com/swagger/v1/swagger.json"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"https://api-au.drofus.com/","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"API documentation and test it in web GUI","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-au.drofus.com/swagger"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Open API Specification","type":"text","marks":[{"type":"link","attrs":{"href":"https://api-au.drofus.com/swagger/v1/swagger.json"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Authentication","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Bearer","type":"text"}]},{"type":"paragraph","content":[{"text":"API generally supports OAauth2 standard Bearer tokens. Registration process of OAuth2 client is currently manual, please reach out to ","type":"text"},{"text":"support@drofus.com","type":"text","marks":[{"type":"link","attrs":{"href":"mailto:support@drofus.com"}}]},{"text":" and we can provide needed information. Please send us the desired redirect_uri(s) (and if desired, post_logout_redirect_uri(s)).","type":"text"}]},{"type":"paragraph","content":[{"text":"For testing purpose, ","type":"text"},{"text":"HTTP Basic authentication","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Authorization#basic"}}]},{"text":" can also be used. However, it should be avoided for production applications. ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"API-key","type":"text"}]},{"type":"paragraph","content":[{"text":"API supports reading data using \"API-key\". This access mode intended to be used by a person for reading ad-hoc data and/or recurring API-calls such as dashboards, PowerQuery (Excel, PoweBI), etc.","type":"text"}]},{"type":"paragraph","content":[{"text":"Keys can be generated as described here: ","type":"text"},{"text":"Power Query#3.-Credentials/Login","type":"text","marks":[{"type":"link","attrs":{"href":"https://drofus.atlassian.net/wiki/spaces/DV/pages/1363771950#PowerQuery-3.-Credentials%2FLogin"}}]},{"text":" A generated key will reflect the logged in user and the project","type":"text"}]},{"type":"paragraph","content":[{"text":"Remarks using API-key","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"It only supports reading operations","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"An API-key is valid for a single project. A user may generate multiple API-keys for accessing different project. Generating API-Key twice for the same project will result in same key.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"API-keys belong to a single user and are confidential, thus should not be shared","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"API-key does not intended to be used for machine-to-machine communication and should not be used as such","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Technical description","type":"text"}]},{"type":"paragraph","content":[{"text":"One should send API-key with each HTTP request as standard Authorization header with ","type":"text"},{"text":"Reference","type":"text","marks":[{"type":"code"}]},{"text":" scheme","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Authorization: Reference ","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"Note that many clients does not allow setting Authorization headers (for example Excel or pasting URL into browser's address bar), but will prompt for inputting username and password when server sends \"Unauthorized\" respond. Such prompt will result sending request with Authorization header with Basic scheme. So as a fallback, the application also accepting API-key encoded as Authorization header with Basic scheme, where username is a constant ","type":"text"},{"text":"apikey","type":"text","marks":[{"type":"code"}]},{"text":" and password is the API-key. The wire format will thus look like the following:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Authorization: Basic base64urlencode(apikey:)","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}]},{"type":"paragraph","content":[{"text":"This is just an illustration, we recommend using Reference scheme whenever possible. Using API-key encoded in Basic scheme is unnecessary if clients have full control over request headers.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Providing database and projectId","type":"text"}]},{"type":"paragraph","content":[{"text":"All API endpoints should provide database and project number as part of the URL path, for example https://api-host/api/","type":"text"},{"text":"database/projectId/","type":"text","marks":[{"type":"strong"}]},{"text":"resources","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Queries","type":"text"}]},{"type":"paragraph","content":[{"text":"We model our query-syntax on the ","type":"text"},{"text":"OData","type":"text","marks":[{"type":"link","attrs":{"href":"https://www.odata.org"}}]},{"text":" standard, but currently only support a small subset of it. ","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1629.5796,"localId":"2ce9512f-496d-4e64-9662-6908fb92cbe2"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.11]},"content":[{"type":"paragraph","content":[{"text":"Argument","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1251.31]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.68]},"content":[{"type":"paragraph","content":[{"text":"Sample","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.11]},"content":[{"type":"paragraph","content":[{"text":"$select","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1251.31]},"content":[{"type":"paragraph","content":[{"text":"A comma-separated list of columns to return. 'id' will always be returned","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.68]},"content":[{"type":"paragraph","content":[{"text":"$select=name,architect_no","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.11]},"content":[{"type":"paragraph","content":[{"text":"$orderby","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1251.31]},"content":[{"type":"paragraph","content":[{"text":"A comma-separated list of columns to sort by. Sorting direction can be specified using ","type":"text"},{"text":"asc ","type":"text","marks":[{"type":"strong"}]},{"text":"or ","type":"text"},{"text":"desc","type":"text","marks":[{"type":"strong"}]},{"text":". Default is ","type":"text"},{"text":"asc","type":"text","marks":[{"type":"strong"}]},{"text":". If no orderby is specified, the result is sorted by id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.68]},"content":[{"type":"paragraph","content":[{"text":"$orderby=name,architect_no desc, ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.11]},"content":[{"type":"paragraph","content":[{"text":"$filter","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1251.31]},"content":[{"type":"paragraph","content":[{"text":"Used to restrict which rows are returned. A column can have a criteria to filter by. The value for filter can be quoted to handle embedded spaces and strings. Currently only 'and' can be used to combine multiple filters. ","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Operators:","type":"text"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"nested-table","text":"","parameters":{"cxhtml":"

Operator	Description
Eq	Equals
Ne	Not equal
Lt	Less than
Gt	Greater than
Le	Less than or equal
Ge	Greater than or equal
In	Is a member of
Contains	String contains a sub-string

","nestedContent":{"type":"doc","content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Eq","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Equals","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Ne","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Not equal","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Lt","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Less than","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Gt","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Greater than","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Le","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Less than or equal","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Ge","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Greater than or equal","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"In","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Is a member of","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Contains","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"String contains a sub-string","type":"text"}]}]}]}]}],"version":1},"adf":"{\"type\":\"doc\",\"content\":[{\"type\":\"table\",\"content\":[{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableHeader\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Operator\",\"type\":\"text\"}]}]},{\"type\":\"tableHeader\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Description\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Eq\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Equals\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Ne\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Not equal\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Lt\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Less than\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Gt\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Greater than\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Le\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Less than or equal\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Ge\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Greater than or equal\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"In\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Is a member of\",\"type\":\"text\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"Contains\",\"type\":\"text\"}]}]},{\"type\":\"tableCell\",\"attrs\":{\"colspan\":1,\"rowspan\":1},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"String contains a sub-string\",\"type\":\"text\"}]}]}]}]}],\"version\":1}","reason":"A table in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.68]},"content":[{"type":"paragraph","content":[{"text":"$filter=created gt '2019-1-1'","type":"text"}]},{"type":"paragraph","content":[{"text":"$filter=name in ('kitchen', 'office')","type":"text"}]},{"type":"paragraph","content":[{"text":"$filter=id in (1001, 1003, 1005)","type":"text"}]},{"type":"paragraph","content":[{"text":"$filter=contains(name,'kitch')","type":"text"}]},{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.11]},"content":[{"type":"paragraph","content":[{"text":"$top","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1251.31]},"content":[{"type":"paragraph","content":[{"text":"Max number of rows to return. Default is 10000. If more data is available than is returned, the result will contain a ","type":"text"},{"text":"RFC5988","type":"text","marks":[{"type":"link","attrs":{"href":"https://tools.ietf.org/html/rfc5988"}}]},{"text":" header value","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.68]},"content":[{"type":"paragraph","content":[{"text":"$top=123","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.11]},"content":[{"type":"paragraph","content":[{"text":"$skip","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1251.31]},"content":[{"type":"paragraph","content":[{"text":"How many rows to skip on result-set. Default is 0. Can be combined with $top to implement paging","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[295.68]},"content":[{"type":"paragraph","content":[{"text":"$skip=100","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Full API documentation","type":"text"}]},{"type":"paragraph","content":[{"text":"The Api is described in a standard format, called Open API (formerly known as Swagger)","type":"text"}]},{"type":"paragraph","content":[{"text":"The basic general documentation for our API will be found under 'swagger/default/swagger.json'. But since our database is highly confiburable, a version with all database-specific files in the schemas are available under 'swagger/v1/swagger.json', but requires logon. ","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"RFC5988","type":"text"}]},{"type":"paragraph","content":[{"text":"Rfc5988 is an internet standard for navigating between pages in result-sets. Essentially it looks like this, and contains the full link for additonal data in the response headers: ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"; rel=\\\"next\\\">","type":"text"}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Examples","type":"text"}]},{"type":"paragraph","content":[{"text":"Examples of how to use the API:","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://drofus.atlassian.net/wiki/spaces/DV/pages/1353156079"}},{"text":" ","type":"text"},{"type":"hardBreak"},{"type":"inlineCard","attrs":{"url":"https://drofus.atlassian.net/wiki/spaces/DV/pages/1353156149"}},{"text":" ","type":"text"}]}],"version":1}

Browser not supported