act-execution-to-knack

Apify act for inserting crawler results into Knack database.

This act fetches all results from a specified Apifier crawler execution and inserts them into a view in Knack database.

INPUT

Input is a JSON object with the following properties:

1{ 
2    // crawler execution id
3    "_id": EXECUTION_ID,
4    
5    // knack connection credentials
6    "data": {
7        "view": KNACK_VIEW,
8        "scene": KNACK_SCENE,
9        "appId": KNACK_APP_ID,
10        "apiKey": KNACK_API_KEY,
11        "schema": TRANSFORM_SCHEMA  // optional
12    }
13}

The act can be run with a crawler finish webhook, in such case fill just the contents of data attribute into a crawler finish webhook data.

It is possible to transform the crawler column names into the Knack field names using a transform schema. This is what the optional schema attribute is for, it is a simple object with the following structure.

1{
2    // CRAWLER : KNACK
3    "col_name_1": "field_001",
4    "col_name_2": "field_002",
5    ...
6}