Location: C:\Users\pinizzot\Documents\Easymorph\CityBikes\CityBikes_00.morph
The project doesn't have embedded connectors.
The project uses the following shared connectors:
1. CityBikes (Web Location)
| Setting | Value |
|---|---|
| Base URL | http://api.citybik.es/v2/networks |
| Authentication type | None |
| Request timeout | 100 seconds |
| Use throttling (per project) | No |
| Handle HTTP 429 (too many requests) automatically | No |
| Use proxy | No |
Request headers to set in every request:
| Header name | Value |
|---|---|
| Retry-After | 15 |
The project consists of 1 module.
The module requires 1 source of data:
It exports data to 1 destination:
The module creates 1 table that is later transformed using 8 actions.
The module doesn't have parameters.
Step 1: Send an HTTP GET request to shared Web Location connector CityBikes. Parse automatically the JSON or XML response into a tabular dataset.
Step 2: Keep 1 column:
Step 3: Remove all duplicating rows looking at values in columns listed below:
Step 4: Sort table
| Column | Order |
|---|---|
| [networks{*}.id] | Ascending |
Step 5: Remove rows above the first row where the following condition is met:
isempty([networks{*}.id])=true()
Remove the first matching row too.
Step 6: "CityBikes_05.morph" once per every line in this table and assign its parameters as follows:
| Parameter in "CityBikes_05.morph" | Assigned value |
|---|---|
| Network-id | Column [networks{*}.id] |
Return from every run of the external project its table "Case station.uid in" and concatenate all results into one table.
When an iteration fails, collect errors and continue.
Step 7: Export into Excel file. Create "citybikes_01.xlsx" with sheet "Sheet1". Additionally, create named range "Citybikes01". If a file with such name already exists, overwrite it.
Step 8 (Disabled): Remove rows with the following values in column [Iteration errors]: