-
Kill Dataset refresh job via API
hi, I am performing bulk data profiling on datasets using API automation where my steps are as below list all datasets to be data profiled in a csv file process csv for each row trigger dataset refresh and capture job id wait for job to get completed or for max 30 mins. if time elapsed is more than 30 mins then skip next…
-
Aperture REST API calls as Datasets within Aperture
Data is available from Aperture via the REST API that is not available in Aperture. Full details of Spaces, User Groups, Users, Jobs, Datasets etc. We would like to use Aperture to manage Aperture. For example: An automated workflow which checks for long running jobs and notifies us of issues; a regular review of user…
-
ℹ️ Importing your Datasets into Excel or Tableau using OData
You can easily get your data from Data Studio into Excel or Tableau using OData. OData (odata.org) is “an open protocol that allows the consumption of data via a simple and standard RESTful API”. If you choose to turn on OData in Data Studio (v2.2.3), you will be able to link your datasets (including snapshots) to any BI…
-
Use REST APIs to automate processes
Data Studio now has over 100 REST APIs that allow information to be extracted or actions taken programmatically allowing processes run automatically with little intervention. APIs also enable integration with third party applications to make Aperture part of your broader business operations. Besides the additional APIs…
-
Experian REST API for Dataset Creation
Hi, Can someone please help me with the JSON request to create a dataset using SQL query? Below are my dataset requirements a. Type : JDBC(SQL Server 6.0) b. Allow Refresh : True c. AllowBatchDeletion : False
-
Experian API call to Execute Workflow
hi, Can someone help me with the JSON request to invoke a workflow through REST API? Below are my workflow specification a. Workflow accepts workflow parameters b Workflow accepts source at execution and its mandatory to give source information.
-
Error while invoking REST API from Experian Studio VM
Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private CA is added to the trust store under E:\ApertureDataStudio\certificates\cacerts API Key genrerated with 365 days validity and able to invoke API via Swagger Issue While trying to invoke the CURL command from command prompt…
-
Experian Aperture Data Studio REST API error
Hi, I am planning to automate dataset creation using Data studio REST API, however I am getting 401 Authorization Error. Background Experian data Studio version - 2.14.14 SSL setup done on the data studio url and private CA is added to the trust store under E:\ApertureDataStudio\certificates\cacerts Please see the steps…
-
Connecting to the ServiceNow REST API using OAuth2
The Autonomous REST Connector JDBC driver allows you to load (and refresh) the results returned from REST API calls as Data Studio Datasets, by translating SQL statements to REST API requests. In this article I'll show how to call ServiceNow's REST API (using OAuth2 authentication) to bring response data into Data Studio.…
-
👩💻 The HTTP Request (REST API) step
This post is to raise awareness of an additional workflow step, that is increasingly being used to provide value in many different Aperture Data Studio deployments. This step allows workflows to call a REST API in a flexible yet well-controlled manner. What do you mean additional workflow step? When you install Data…
-
SNOW Connection - OAUTH2.0 in Aperture
@henry_ @Henry Simms @Josh Boxer We are trying to Build the External System connection through API in Aperture, the authentication method is OAuth 2.0 I am able to get the response in Postman and also able to Download the JSON file and then process the Same in Aperture, then i can see the Table and also the records. But…
-
SNOW Connection - OAUTH2.0 in Aperture
@henry_ @Henry Simms @Josh Boxer We are trying to Build the External System connection through API in Aperture, the authentication method is OAuth 2.0 I am able to get the response in Postman and also able to Download the JSON file and then process the Same in Aperture, then i can see the Table and also the records. But…
-
Add additional List object APIs such as Views
End point for View is required currently we have only for datasets Exporatble objects end point only provides Space specific output, it would be helpful if we can get output for all spaces. We have 40+ spaces its very difficult to create 40+ rest files to get this.
-
User Information in Dataset get API
Is it possible to get the User Information, ex, who used or created the dataset that Information or Last User Information from the Dataset Get API. I can see that when I am manually doing Get More information the Dataset but not getting that as an output column when I fetch the metadata from API @KatriM
-
401error when using AutoRest connection as external system for Zendesk API
Good Afternoon, I've created an Autonomous Rest connection and I'm able to access the tables, however when moving to the define settings step inside of the add dataset functionality, I'm getting the following error message. [ApertureDataStudio][AutoREST JDBC Driver][AutoREST]REST Status 401 Unauthorized returned for GET…
-
Function details through the API?
Is it possible to get a list of functions via the API, similar to how the List Datasets call works (or even space-by space if an environment wide option is not possible)? Unless I'm misunderstanding the documentation, only the sharing details are exposed? Thanks Mike
-
Workflow Names along with Space Name
Is it Possible to get the list of the WFs in all Spaces. Through the Aperture API?
-
autoColumnMapping function in Workflow api
Hi, Have you consider having a flag in your api to execute Workflows to use the auto Mapping columns we can have in Studio ? This will be great to avoid case sensitive headers in DataSet for instance. Regards,
-
Want to pass certain input from API to the workflow
i am trying to call an API from an external website my agenda is to pass some IDs that will be taken as input in the workflow and the workflow will run for those IDs only and finally if i could export the result in some kind of file (csv,excel,xml)
-
Error while connecting to Embedded Duplicate Store
Hi, I am getting error as below when I am trying to connect to the Embedded Duplicate store in my Data studio server(2.10.10). Please let me know if you have faced similar issue and help me with the steps to resolve this. PS: We do have a remote duplicate store(3.8.15) which is working fine and we have secured the Data…
-
Exportable Object Endpoint via REST API for Change Tracking and Audit
As part of our ongoing efforts to manage Aperture using Aperture, we would like to use the Aperture API to audit the workflow objects in each of our spaces. This will allow us to spot new workflow build & validate that against build plans and data governance records. Currently our view of workflows is limited to fully…
-
Dataset Update through API
We have a requirement to Update the Dataset with API. Currently we are manuall placing the .csv file to the dropzone and then updating the Dataset. But as we want to automate this we want to call the API from the other server and update the dataset in aperture. Is the below api we can use to update the Dataset or it only…
-
API to Get Scheduled Jobs Information
There is One API to get the information about the scheduled Datasets. But in that we have to Pass the Space Names to get the info and Response is specific to that Space Alone. Is there any API where we can get the Scheduled Dataset Information across all the available spaces? I am using below API but it gives response for…
-
how to find Dataset & External Systems dependency
I tried with API to get the list where I can find the list of the Datasets along with the external systems it belongs to. But in the Dependon part I am only getting the List of the external systems on which any datasets are depending in the specific SPACE but not getting the info which Datasets are depending on those…
-
Importing data form a cloud-based MDM solution
Hi, We need to import data into Aperture Data Studio from Boomi’s Master Data Hub module. As a cloud-based MDM solution, Boomi does not allow direct access to their databases. Therefore, we would ideally want to develop an integration using web services in one of two ways: Aperture is configured to import data via Boomi’s…
-
APIs to get the details regarding Data set and wf schedules
How do I get Information about all the datasets refresh which have been scheduled and timing of those (whole system including all the environments and spaces)? I was trying the below API What is execution ID? Also Daily Information about scheduled runs of the datasets refreshes including the information about how long the…
-
REST API: get dataset list and their information
Hello, We are looking to identify all datasets (of all spaces) that are in autorefresh. When we use the REST API: datasets and getApiKeyInfo, we get datasets lists with many information but we don't have : Attached is an example of getApiKeyInfo api response regarding the table AUSP Is there any REST API which allows to…
-
Scheduling workflows using the Data Studio REST API in version 2
In v2.0 of Data Studio, the REST API has changed from v1, so this original post has been updated for those changes. Aperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Scheduler, Cron or even triggered from workflows within other applications. The method for doing this is to use…
-
Scheduling workflows using the Data Studio REST API
Aperture Data Studio is intended to be invoked from third party schedulers , like Windows Task Scheduler, Cron or even triggered from workflows within other applications. The method for doing this is to use the Aperture Data Studio REST API to execute a workflow from within a script, and trigger that script from the…
