{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"How to get data from our API","type":"text"}]},{"type":"paragraph","content":[{"text":"You have the possibility to get results from predefined elements (datasets or scripts) using our API which returns JSON data. In addition, you can also set custom filters on the requests. Right now our API has a limit of returning 1 million rows of data at a time when querying data.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Prerequisites","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SF user account to generate an API access token","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SF platform backend URL of your environment","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Id of the predefined element (dataset/script)","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"paragraph","content":[{"text":"First, you need an API access token, which can be generated by each user. This token is equivalent to your credentials so you will have the same permissions as the user who created this API access token. For information on how to generate such an API access token see ","type":"text"},{"text":"Get your access token","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/WD/pages/4137222207"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The second information you need is the backend URL of your environment. You can see this URL when your login screen is displayed. Here you require the first part of the URL which usually looks like ","type":"text"},{"text":"exampleapi.senseforce.io","type":"text","marks":[{"type":"strong"},{"type":"em"},{"type":"link","attrs":{"href":"http://exampleapi.senseforce.io"}}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":250,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":964,"type":"external","url":"https://manual.senseforce.io/~gitbook/image?url=https%3A%2F%2F1533098984-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-legacy-files%2Fo%2Fassets%252F-Lj6tqYfpNT_59dZ_Z3Z%252F-MLCPuQK2gSwTYNPb_5O%252F-MLCbZoh-cJ1ugKsAlgY%252Fimage.png%3Falt%3Dmedia%26token%3D06033ad0-ede4-4ef8-b369-e14c9eb3d3c2&width=768&dpr=4&quality=100&sign=9c2f981915290f823be8c270c58797e7f8ca97a7f3f305f454dafcee798dbd52","height":614}},{"type":"caption","content":[{"text":"SF platform backend URL","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The third and last thing you need for your API request is the ID of the element you want to request. For example, for a dataset, you can see this information when you open the desired dataset in the SF platform. The ID is the last part which is shown in the address bar (see example below).","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":732,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1229,"type":"external","url":"https://manual.senseforce.io/~gitbook/image?url=https%3A%2F%2F1533098984-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-legacy-files%2Fo%2Fassets%252F-Lj6tqYfpNT_59dZ_Z3Z%252F-MLCPuQK2gSwTYNPb_5O%252F-MLCdSTpnIJVLD__qA5s%252Fimage.png%3Falt%3Dmedia%26token%3D4178c660-64c6-45e2-89ca-f312462b9a99&width=768&dpr=4&quality=100&sign=d347488520b4a44dd59f666194b7d6fb88bc98e0fd194897709454876970ba9e","height":978}},{"type":"caption","content":[{"text":"Dataset ID","type":"text"}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Double-check the headers before making a request. When a request library (like 'requests' in Python) or Postman is used, some headers are auto-generated so we don't have to manually set them, but this is not always true especially for 'Host' or 'Content-Type'.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":250,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":900,"id":"5a225acc-fb37-4a7c-a7fc-9b5cc491655b","collection":"contentId-4136894537","type":"file","height":319}}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"How to construct the API request","type":"text"}]},{"type":"paragraph","content":[{"text":"Below you can find information about endpoints structure and required parameters.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Execute a dataset through Senseforce API","type":"text"}]},{"type":"paragraph","content":[{"text":"POST","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":"https:///api/dataset/execute/","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"The URL you have to send your POST request to has to have the structure as shown above. This API endpoint can contain extra two optional parameters: ","type":"text"},{"text":"limit","type":"text","marks":[{"type":"strong"}]},{"text":" and ","type":"text"},{"text":"offset","type":"text","marks":[{"type":"strong"}]},{"text":". After inserting your parameters the request looks like ","type":"text"},{"text":"https://exampleapi.senseforce.io/api/dataset/execute/d9d6gDg7fGmd3mI","type":"text","marks":[{"type":"strong"},{"type":"em"},{"type":"link","attrs":{"href":"https://exampleapi.senseforce.io/api/dataset/execute/d9d6gDg7fGmd3mI"}}]},{"text":"?","type":"text","marks":[{"type":"em"}]},{"text":"offset","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"=0&","type":"text","marks":[{"type":"em"}]},{"text":"limit","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"=100","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","content":[{"text":"For how to get the backend URL and/or dataset id see the section above. Within the body of your request, you can add filter clauses which are additional filters applied to the original dataset. For more information about additional filters see the sections below. The body itself is optional. So it can be an empty array or an array of filter objects, but for each filter object the parameters mentioned in \"Body parameters\" are mandatory.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Query Parameters","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"10193625-c289-44b6-ba34-24bed959812d"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"The dataset id has to","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"offset","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Number of rows to skip","type":"text","marks":[{"type":"em"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"limit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Number of rows to return","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Headers","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"d8c35525-fd4e-456e-9002-71e654edf79c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"Content-Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Set to \"application/json\"","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Set to \"Bearer \"","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Request Body","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"f95c2ba5-03db-4cd8-ba33-0b43501deb3f"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"clause","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"object","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Filter clause object. Each additional filter is defined by such a ","type":"text"},{"text":"clause ","type":"text","marks":[{"type":"em"}]},{"text":"object","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Can be \"timestamp\" or \"string\" (for all other column datatypes)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"operator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Id of the filter operator used to define the filter condition","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"parameters","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Filter arguments","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"columnName","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name of the dataset column the filter should be applied to","type":"text"}]}]}]}]},{"type":"paragraph"},{"type":"codeBlock","content":[{"text":"200 Cake successfully retrieved. 404 Could not find a cake matching this query.\n{ \"name\": \"Cake's name\", \"recipe\": \"Cake's recipe name\", \"cake\": \"Binary cake\"}","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Requesting original dataset","type":"text"}]},{"type":"paragraph","content":[{"text":"When you want to get all data from the dataset you can send requests with an empty array as a body. Below you can find a sample Python script to do so.","type":"text"}]},{"type":"codeBlock","content":[{"text":"import requests\nimport json\nfrom pandas import DataFrame\n\nurl = \"https:///api/dataset/execute/\"\nheaders = {'Content-Type': 'application/json', 'Authorization': 'Bearer '}\nfilters = []\n\nresponse = requests.post(url, headers=headers, json=filters)\ndata = response.text\nparsed_data = json.loads(data)\ndf = DataFrame(parsed_data)","type":"text"}]},{"type":"paragraph","content":[{"text":"Requesting dataset with original labels","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"By default, all response element property names (dataset column labels) are converted to first letter lower case.","type":"text"}]},{"type":"paragraph","content":[{"text":"To avoid this behavior, and to keep the original label letter case, use an additional parameter in the request ","type":"text"},{"text":"useOriginalLabels ","type":"text","marks":[{"type":"code"}]},{"text":"and set it to ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text"},{"text":"(/api/dataset/execute/?useOriginalLabels=true)","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"To use converted column labels, you can explicitly set ","type":"text"},{"text":"useOriginalLabels ","type":"text","marks":[{"type":"code"}]},{"text":"to ","type":"text"},{"text":"false","type":"text","marks":[{"type":"code"}]},{"text":", or simply omit the parameter.","type":"text"}]},{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":768,"alt":"image-20240426-105615.png","id":"9a480ff5-34fe-4f30-82b0-ec09dd22f217","collection":"contentId-4136894537","type":"file","height":292}},{"type":"caption","content":[{"text":"Example of ","type":"text"},{"text":"useOriginalLabels ","type":"text","marks":[{"type":"em"}]},{"text":"parameter usage.","type":"text"}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":4},"content":[{"text":"Requesting dataset with additional filters","type":"text"}]},{"type":"paragraph","content":[{"text":"All filters defined in the dataset will be applied anyway, but you can also apply additional filters to it. To define a filter you have to create a structure like the one shown in the example below.","type":"text"}]},{"type":"paragraph","content":[{"text":"In the example below a filter for the column named \"device\" is applied so that it only contains values equal to \"vienna-prater-ferris-wheel-motor1\".","type":"text"}]},{"type":"codeBlock","content":[{"text":"[{\n\t\t\"clause\": {\n\t\t\t\"type\": \"string\",\n\t\t\t\"operator\": 7,\n\t\t\t\"parameters\": [{\n\t\t\t\t\t\"value\": \"vienna-prater-ferris-wheel-motor1\"\n\t\t\t\t}\n\t\t\t]\n\t\t},\n\t\t\"columnName\": \"device\"\n\t}\n]","type":"text"}]},{"type":"paragraph","content":[{"text":"Within these clause objects (filter definitions) all operators which are also available on the SF Platform can be used. But some restrictions have to be considered. Not each operator can be applied to each column, because of their datatype. And not all of these filters have the same number of parameters. Most of them have only one, but some of them have none (e.g. IsEmpty, IsNotEmpty) and some have two (e.g. Between).","type":"text"}]},{"type":"paragraph","content":[{"text":"A summary of all available filter \"operator\" and their restrictions are given in the table below:","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Filter Operators Table","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"9b7e33f1-50f2-4f5d-981b-9d6c4ae68b10"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Operator id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"# param","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Required parameter datatype","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Required column datatype","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LessThan","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"GreaterThan","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"LessThanOrEqualTo","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"3","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"GreaterThanOrEqualTo","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"4","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Equal","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"5","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double | string","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NotEqual","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"6","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double | string","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Like","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"7","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"RegExpMatch","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"8","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NotRegExpMatch","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"9","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Between","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"10","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer | long | double | timestamp","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":"11","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1...n","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"each datatype allowed","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"IsEmpty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"12","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"each datatype allowed","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"IsNotEmpty","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"13","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"each datatype allowed","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomToday","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"14","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomThisWeek","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"15","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomThisMonth","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"16","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastThreeMonths","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"17","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastXMinutes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"18","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomDay","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"19","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NotLike","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"20","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomYesterday","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"21","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastXDays","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"22","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastXWeeks","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"23","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastXMonths","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"24","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastWeek","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"25","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomLastMonth","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"26","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"-","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"CustomRelativeBetween","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"27","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"integer","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"timestamp","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"NotIn","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"28","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"1...n","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"same as column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"each datatype allowed","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"NOTE: \"timestamps\" are integer values representing the Unix timestamp in milliseconds (!!!).","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Below you can find an extended version of the example Python script where also additional filters are applied.","type":"text"}]},{"type":"codeBlock","content":[{"text":"import requests\nimport json\nfrom pandas import DataFrame\n\nclass operator:\n LessThan = 1\n GreaterThan = 2\n LessThanOrEqualTo = 3\n GreaterThanOrEqualTo = 4\n Equal = 5\n NotEqual = 6\n Like = 7\n RegExpMatch = 8\n NotRegExprMatch = 9\n Between = 10\n In = 11\n IsEmpty = 12\n IsNotEmpty = 13\n CustomToday = 14\n CustomThisWeek = 15\n CustomThisMonth = 16\n CustomLastThreeMonths = 17\n CustomLastXMinutes = 18\n CustomDay = 19\n NotLike = 20\n CustomYesterday = 21\n CustomLastXDays = 22\n CustomLastXWeeks = 23\n CustomLastXMonths = 24\n CustomLastWeek = 25\n CustomLastMonth = 26\n CustomRelativeBetween = 27\n NotIn = 28\n\nclass datatype:\n timestamp = \"timestamp\"\n string = \"string\"\n\nurl = \"https:///api/dataset/execute/\"\nheaders = {'Content-Type': 'application/json', 'Authorization': 'Bearer '}\nfilters = [{\n \t\t\"clause\": {\n \t\t\t\"type\": datatype.string,\n \t\t\t\"operator\": operator.GreaterThan,\n \t\t\t\"parameters\": [{\t\t\n \"value\": 2000\n \t\t\t\t}\n \t\t\t]\n \t\t},\n \t\t\"columnName\": \"compressed size\"\n \t},\n {\n \t\t\"clause\": {\n \t\t\t\"type\": datatype.string,\n \t\t\t\"operator\": operator.NotEqual,\n \t\t\t\"parameters\": [{\n \"value\": \"Thing XY\"\n \t\t\t\t}\n \t\t\t]\n \t\t},\n \t\t\"columnName\": \"(sf-messages) Thing\"\n \t},\n {\n \"clause\": {\n \t\t\t\"type\": datatype.timestamp,\n \t\t\t\"operator\": operator.Between,\n \t\t\t\"parameters\": [{\t\t\n \"value\": 1604043829000\n \t\t\t\t},\n {\t\t\n \"value\": 1604053829000\n \t\t\t\t}\n \t\t\t]\n \t\t},\n \t\t\"columnName\": \"(sf-messages) Timestamp\"\n }]\n\nresponse = requests.post(url, headers=headers, json=filters)\ndata = response.text\nparsed_data = json.loads(data)\ndf = DataFrame(parsed_data)","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Execute a script through Senseforce API","type":"text"}]},{"type":"paragraph","content":[{"text":"POST","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":"https:///api/script/execute/{scriptId}","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"The URL request has to have the structure as shown above. This API endpoint can contain extra two optional parameters: ","type":"text"},{"text":"limit","type":"text","marks":[{"type":"strong"}]},{"text":" and ","type":"text"},{"text":"offset","type":"text","marks":[{"type":"strong"}]},{"text":". After inserting the parameters, the request may look like this: ","type":"text"},{"text":"https://exampleapi.senseforce.io/api/script/execute/","type":"text","marks":[{"type":"em"},{"type":"link","attrs":{"href":"https://exampleapi.senseforce.io/api/script/execute/"}}]},{"text":"807a0c12-35e9-4b7f-b695-837c2cf5fb41","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"?","type":"text","marks":[{"type":"em"}]},{"text":"offset","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"=0&","type":"text","marks":[{"type":"em"}]},{"text":"limit","type":"text","marks":[{"type":"strong"},{"type":"em"}]},{"text":"=100","type":"text","marks":[{"type":"em"}]},{"text":" Within the body of the request, you can add script filters and dataset filters. Dataset filters are additional filters applied to the original dataset. For more information about the script filters and dataset, filters see the sections below. The body can be an empty object or can contain filter objects.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Path Parameters","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"6ef83632-cd85-4718-bbd5-3d62b4a2296c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"scriptId","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Query Parameters","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"98c1a7f1-e6de-4c8d-91ff-9cedba1dc70f"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"offset","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Number of rows to skip","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"limit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Number of rows to return","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Headers","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"7066c904-c9b4-4857-9838-ad85672a6840"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"Authorization","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Set to \"Bearer \"","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Content-Type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Set to \"application/json\"","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Request Body","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"d1954d14-fbae-49c3-af79-03ccb89c180e"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","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":"ScriptFilters","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"array","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"List of script filters","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"DatasetFilters","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"array","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"List of dataset filters","type":"text"}]}]}]}]},{"type":"paragraph"},{"type":"codeBlock","content":[{"text":"200","type":"text"}]},{"type":"paragraph","content":[{"text":"The Body Parameters (\"ScriptFilters\" and \"DatasetFilters\") contain the same filter object structure in their list. See the filter object structure in the section below. The Body Parameter \"DatasetFilters\" can contain filter objects associated with a column of a dataset. These filters can target columns from multiple datasets as well (a script can work with one or multiple datasets).","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":708,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":884,"type":"external","url":"https://manual.senseforce.io/~gitbook/image?url=https%3A%2F%2F1533098984-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-legacy-files%2Fo%2Fassets%252F-Lj6tqYfpNT_59dZ_Z3Z%252F-Ma2DabGWmRJoHrajKf2%252F-Ma2EPoQ65K5LtvavitX%252Fimage.png%3Falt%3Dmedia%26token%3D6ada6afb-5ae3-45c8-8bcb-d44c43c26ea8&width=768&dpr=4&quality=100&sign=a60fdd7e67151c9d93240cbf28c6c451686f3410bf2c825152722875e5b5efc5","height":400}},{"type":"caption","content":[{"text":"Filter object structure","type":"text"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Executing a script","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's use a demo script and see how this script can be executed via Senseforce API. The following script has a \"value\" variable and it outputs this variable as result.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1555,"type":"external","url":"https://manual.senseforce.io/~gitbook/image?url=https%3A%2F%2F1533098984-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-legacy-files%2Fo%2Fassets%252F-Lj6tqYfpNT_59dZ_Z3Z%252F-Ma2PFd5BML9tzdgsR_z%252F-Ma2QAjDK69tWn5HHVEJ%252Fimage.png%3Falt%3Dmedia%26token%3D18c85b10-f9df-44d5-9cf6-63b0fa207196&width=768&dpr=4&quality=100&sign=4595d4c7ea026a9ce28903e9efa03b4401abc7012ead1486688ebfc157281f64","height":718},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Let's execute this script via Senseforce API. When you want to execute a script without any filters you can send requests with an empty object as a body. Below you can find a C# request sample:","type":"text"}]},{"type":"codeBlock","content":[{"text":"var client = new RestClient(\"https:///api/script/execute/7157b7c7-dd56-46ee-93e2-2955cd91cfdc\");\n\nvar request = new RestRequest(Method.POST);\nrequest.AddHeader(\"Authorization\", \"Bearer \");\nrequest.AddHeader(\"Content-Type\", \"application/json\");\nrequest.AddParameter(\"application/json\", \"{}\", ParameterType.RequestBody);\nIRestResponse response = client.Execute(request);\n\nConsole.WriteLine(response.Content);","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Executing a script with script filters","type":"text"}]},{"type":"paragraph","content":[{"text":"In the example below a script filter for the column named \"value\" is applied so that it only contains values equal to \"hello from script\". The Request Body will be like:","type":"text"}]},{"type":"codeBlock","content":[{"text":"request.AddParameter(\"application/json\", \n\"{\n \"scriptFilters\": [\n {\n\t\t \"clause\": {\n\t\t\t \"type\": \"string\",\n\t\t\t \"operator\": 7,\n\t\t\t \"parameters\": [{ \"value\": \"hello from script\" }]\n\t\t },\n\t\t \"columnName\": \"value\"\n\t \t}\n\t\t]\n}\", ParameterType.RequestBody);","type":"text"}]},{"type":"paragraph","content":[{"text":"A summary of all available filter \"operator\" and their restrictions are given in the above \"Filter Operators\" table","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Executing a script with dataset filters","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's use a demo script that uses two datasets so you can see how the dataset filters can be applied.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":726,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1875,"type":"external","url":"https://manual.senseforce.io/~gitbook/image?url=https%3A%2F%2F1533098984-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-legacy-files%2Fo%2Fassets%252F-Lj6tqYfpNT_59dZ_Z3Z%252F-Ma2mQ4b502okjZLDETp%252F-Ma2mUo5tp8pGeW-hKB6%252Fimage.png%3Falt%3Dmedia%26token%3Db5e615cf-8b37-4994-83ab-919793f5df95&width=768&dpr=4&quality=100&sign=499f11be8875b7ff397eda2ef062214144a7304dd6f1fc4efc18f398c3ae3165","height":780}}]},{"type":"paragraph","content":[{"text":"In the example below, two dataset filters are set, which target different datasets. The Request Body will be like:","type":"text"}]},{"type":"codeBlock","content":[{"text":"request.AddParameter(\"application/json\", \n\"{\n \"datasetFilters\": [\n {\n \"clause\": {\n \"type\": \"string\",\n \"operator\": 7,\n \"parameters\": [{ \"value\": \"virtual_event\" }]\n },\n \"columnName\": \"(another_test) Thing\"\n\t },\n {\n \"clause\": {\n \"type\": \"string\",\n \"operator\": 7,\n \"parameters\": [{ \"value\": \"virtual_event\" }]\n },\n \"columnName\": \"(test) Thing\"\n\t }\n ]\n}\", ParameterType.RequestBody);\n","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Executing a script with script and dataset filters","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's use a demo script which uses two datasets so you can see how the dataset filters and script filters can be applied.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":740,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1894,"type":"external","url":"https://manual.senseforce.io/~gitbook/image?url=https%3A%2F%2F1533098984-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-legacy-files%2Fo%2Fassets%252F-Lj6tqYfpNT_59dZ_Z3Z%252F-Ma2oRLxCTEbuCQfaAx-%252F-Ma2yy-ffqctymvUuE4o%252Fimage.png%3Falt%3Dmedia%26token%3Dab4304f1-5511-488c-8da4-06b4747303be&width=768&dpr=4&quality=100&sign=272061ff64c54d131b6f9f71974b163543f138395e49761c4b0155fc19a4bf92","height":771},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"In the example below, one script filter and two dataset filters are set. The Request Body will be like:","type":"text"}]},{"type":"codeBlock","content":[{"text":"request.AddParameter(\"application/json\", \n\"{\n \"scriptFilters\": [\n {\n \"clause\": {\n \"type\": \"number\",\n \"operator\": 5,\n \"parameters\": [{ \"value\": \"285\" }]\n },\n \"columnName\": \"size\"\n\t }\n ],\n \"datasetFilters\": [\n {\n \"clause\": {\n \"type\": \"string\",\n \"operator\": 7,\n \"parameters\": [{ \"value\": \"virtual_event\" }]\n },\n \"columnName\": \"(another_test) Thing\"\n\t },\n {\n \"clause\": {\n \"type\": \"string\",\n \"operator\": 7,\n \"parameters\": [{ \"value\": \"virtual_event\" }]\n },\n \"columnName\": \"(test) Thing\"\n\t }\n ]\n}\", ParameterType.RequestBody);\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Dataset filters are first considered and then at the end, the script filter is applied.","type":"text"}]}],"version":1}