Project "CityBikes_00"

Location: C:\Users\pinizzot\Documents\Easymorph\CityBikes\CityBikes_00.morph

Embedded Connectors

The project doesn't have embedded connectors.

Shared Connectors

The project uses the following shared connectors:

1. CityBikes (Web Location)

SettingValue
Base URLhttp://api.citybik.es/v2/networks
Authentication typeNone
Request timeout100 seconds
Use throttling (per project)No
Handle HTTP 429 (too many requests) automaticallyNo
Use proxyNo

Request headers to set in every request:

Header nameValue
Retry-After15

Modules

The project consists of 1 module.

Module: Main

The module requires 1 source of data:

  1. Undocumented data source

It exports data to 1 destination:

  1. Excel file "citybikes_01.xlsx"

The module creates 1 table that is later transformed using 8 actions.

Parameters

The module doesn't have parameters.

Table: "Data from API"

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:

  • networks{*}.id

Step 3: Remove all duplicating rows looking at values in columns listed below:

  • networks{*}.id

Step 4: Sort table

ColumnOrder
[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-idColumn [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]:

  • <empty>