Microsoft SQL Server Insert avatar
Microsoft SQL Server Insert
Try for free

No credit card required

View all Actors
Microsoft SQL Server Insert

Microsoft SQL Server Insert

petr_cermak/mssql-insert
Try for free

No credit card required

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

act-mssql-insert

Apify act for inserting crawler results into a remote MSSQL table.

This act fetches all results from a specified Apifier crawler execution and inserts them into a table in a remote MSSQL database.

The act does not store its state, i.e. if it crashes it restarts fetching all the results. Therefore you should only use it for executions with low number of results.

INPUT

Input is a JSON object with the following properties:

1{
2    "_id": "YOUR_EXECUTION_ID",
3    "data": {
4        "connection": "MSSQL_CONNECTION_STRING",
5        "table": "DB_TABLE_NAME"
6    }
7}

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.

Additionally to crawler results, it is also possible to specify a dataset id, to fetch the result from a dataset.

1{
2    // id of dataset to fetch rows from
3    "datasetId": "dataset_id",
4
5    // MSSQL connection credentials
6    "data": "connection_credentials"
7}

Alternatively you can directly specify the rows to be inserted (i.e. not fetching them from crawler execution).

1{
2    // rows to be inserted
3    "rows": [
4        {"column_1": "value_1", "column_2": "value_2"},
5        {"column_1": "value_3", "column_2": "value_4"},
6        ...
7    ],
8
9    // MSSQL connection credentials
10    "data": "connection_credentials"
11}
Developer
Maintained by Community
Actor metrics
  • 1 monthly user
  • 0 stars
  • Created in Jul 2017
  • Modified about 3 years ago
Categories