18 December 2013
Read this tutorial and gain a skill how to use our cloud integration platform to create a simple report from the www.leankit.com data. Leankit is a visual project management tool and we at Cooperation534 are making a fare use of it.
Here's how your target report's structure would look like:
Prerequisites to pass this tutorial:
1. Active account at Cooperation534.
2. Active account at LeanKit.
3. Web browser :)
Remember to fill out necessary information before pasting configuration settings (places in UPPER CASES).
Go to processes list and add a new process. Name it e.g. "Get the data from LeanKit board". This process will pull the LeanKit board data using it's API and put it into Google BigQuery database.
You can read more on LeanKit API Basics.
A. Set input interface as "REST" and paste this configuration settings:
LEANKIT_BOARD_ID - you can find it in your LeanKit board URL.
B. Set output interface as "K534 Reports" and copy-paste this configuration:
BIGQUERY_TABLEID - unique table name.
Click "OK" to save changes.
C. From operations available to this process choose "Check mapping syntax" and copy-paste this configuration:
Click "Save and exit".
D. From operations available to this process choose "Run this process once".
Add a new process and name it e.g. "Get data from Google BigQuery". This process pulls the data from Google BigQuery table so you could display them in a report.
A. Set input interface as "K534 Reports" and copy-paste this configuration:
B. Set output interface as "DATABOX, v1.1" and paste this configuration settings:
Click "OK" to save changes.
C. From operations available to this process choose "Change the rules of process execution" and set a schedule as "Active". Click "OK" to save changes.
And that's it!
You've just created a simple report using our SaaS integration platform.
If you have any questions or ran into some unforeseen issues contact us at our contact form!
Here's how your target report's structure would look like:
1. Active account at Cooperation534.
2. Active account at LeanKit.
3. Web browser :)
Remember to fill out necessary information before pasting configuration settings (places in UPPER CASES).
STEP 1
Go to processes list and add a new process. Name it e.g. "Get the data from LeanKit board". This process will pull the LeanKit board data using it's API and put it into Google BigQuery database.
You can read more on LeanKit API Basics.
A. Set input interface as "REST" and paste this configuration settings:
{"url":"https://LEANKIT_ACCOUNT_NAME.leankit.com/
Kanban/Api/Boards/LEANKIT_BOARD_ID",
"error_codes":[100, 401, 500, 501, 502, 503, 800, 900, 902, 1000],
"url_params":{},
"user": {"username":"LEANKIT_USERNAME", "password":"LEANKIT_USER_PASSWORD" }}LEANKIT_BOARD_ID - you can find it in your LeanKit board URL.
B. Set output interface as "K534 Reports" and copy-paste this configuration:
{"auditType":"suffix",
"tableId":"BIGQUERY_TABLEID",
"schema":{
"fields":[
{ "type":"STRING",
"name":"card_title"},
{ "type":"STRING",
"name":"card_assigned_username"},
{ "type":"INTEGER",
"name":"card_size"},
{ "type":"STRING",
"name":"card_last_mod_date"}]}}
BIGQUERY_TABLEID - unique table name.
Click "OK" to save changes.
C. From operations available to this process choose "Check mapping syntax" and copy-paste this configuration:
lanes = in_dict['ReplyData'][0]['Lanes']
cards_list = []
for lane in lanes:
cards = lane['Cards']
for card in cards:
card_data = {
'card_title': card['Title'],
'card_assigned_username': card['AssignedUsers'][0]['AssignedUserName'],
'card_size': card['Size'],
'card_last_mod_date': card['LastActivity']
}
card_id = card['Id']
cards_list.append(card_data)
out_dict['data'] = cards_listClick "Save and exit".
D. From operations available to this process choose "Run this process once".
STEP 2
Add a new process and name it e.g. "Get data from Google BigQuery". This process pulls the data from Google BigQuery table so you could display them in a report.
A. Set input interface as "K534 Reports" and copy-paste this configuration:
{ "timeoutMs":0,
"query":"select card_title, card_assigned_username, card_size, card_last_mod_date from YOUR_LEANKIT_BOARD_ID;" }
B. Set output interface as "DATABOX, v1.1" and paste this configuration settings:
{ "tag_source":"task",
"tag":"leankit-report" }Click "OK" to save changes.
C. From operations available to this process choose "Change the rules of process execution" and set a schedule as "Active". Click "OK" to save changes.
STEP 3
Now it's the time to create a report.
A. Download two files needed to render a proper report: HTML file - report's structure and Angular script file. These files are just an example how a report could look like.
B. Go to reports list and add a new report. Name it e.g. "LeanKit report".
C. Add previously downloaded files to a report. Make sure that radio button is checked for a html file. It's an indication which one of the files is a start-up file. Click "Save".
D. Click "View" and wait a few seconds to see your report. Here's how your report should look like:
A. Download two files needed to render a proper report: HTML file - report's structure and Angular script file. These files are just an example how a report could look like.
B. Go to reports list and add a new report. Name it e.g. "LeanKit report".
C. Add previously downloaded files to a report. Make sure that radio button is checked for a html file. It's an indication which one of the files is a start-up file. Click "Save".
D. Click "View" and wait a few seconds to see your report. Here's how your report should look like:
You've just created a simple report using our SaaS integration platform.
If you have any questions or ran into some unforeseen issues contact us at our contact form!
