Tune Endpoint Parameter Relevant to Delta Load

 Posted on 2022-02-05  |  3 minutes  |  434 words  |  Kazuhiko Takata

Until last post Setup Dependent Endpoint in Extractor Builder, I prepared endpoints of both Planio Issues and their journals. Today I would like to tackle final setup of extractor to deal with Delta Load option. Referring to the Planio Documentation, updated_on column exists for filtering Issues. This timestamp column is updated when creating and updating relevant issue, so it is appropriate column for Delta Load. Open Celonis Extractor builder then go to 4 Define Endpoints. [Read More]
Data Integration  Extractor Builder 

Setup Dependent Endpoint in Extractor Builder

 Posted on 2022-01-29  |  2 minutes  |  372 words  |  Kazuhiko Takata

In the last post Configure Endpoint for Suitable Extraction, I configured Endpoint in Extractor Builder to suit my business requirements, and still there are points to extract change history of issues, and to extract data by Delta Load option. Today I would like to setup regarding change history using Dependent Endpoint in Extractor Builder. At first how do I extract change history of Planio Issue ? Again I looked at Planio Documentation and found I can get single issue with journals (meaning change history in Planio). [Read More]
Data Integration  Extractor Builder 

Configure Endpoint for Suitable Extraction

 Posted on 2022-01-22  |  3 minutes  |  468 words  |  Kazuhiko Takata

In the last post Connect to Source System via REST API, I shared how to set up Extractor Builder and extracted Issue from Planio. It was shortest path to be avaiable for extraction job, so it is not enough for production job. Today I would like to configure Endpoint in Extractor Builder to resolve problems I experienced. First problem I faced is upper limit of extraction data. Some day I found that I could not get issue record until 25. [Read More]
Data Integration  Extractor Builder 

Connect to Source System via REST API

 Posted on 2022-01-15  |  3 minutes  |  506 words  |  Kazuhiko Takata

At previous post Prepare Source System to Generate Event Log, I prepared Planio as source system for this blog, and entered few events (create Issue, update Issue Status) to it. Now it is time to extract event log from Planio. As other SaaS solution do, Planio also has REST API to extract data from outside. Currently Celonis EMS has ability to extract from arbitrary system that has REST API, Extractor Builder. [Read More]
Data Integration  Extractor Builder