You can't use this until you register with us!




Description

Obtain data from ShipHero and load it into MySQL.


Purchasing Options



Available Actions

Load Data

Download data from ShipHero and store it in MySQL.


Variables

Source Parameters
shiphero_connection required

Credentials to use to connect to ShipHero.

query required

ShipHero GraphQL query that will return the desired data.

nested_paginated_items

Optional name of a nested item that needs to be queried with pagination using the Detail Query.

detailed_query

Query to execute to retrieve all of the data of the Nested Paginated Item via pagination.

user_params

Parameters to use in your GraphQL Query, if any. Refer to slide out help for more information.


Range Parameters
pointer

Datetime stamp indicating the starting point, based on creation datetime, of the data to download. Only data created after the datetime specified will be downloaded. This field will be automatically updated after each increment of data is downloaded. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

start_point_query

Optional. SQL Query to use to determine the start point of the data to process. If specified, Next Run Start Point will be ignored.

end_pointer

Optional. Datetime stamp indicating the stopping point, based on creation datetime, of the data to download. Only data created before the datetime specified will be downloaded. If blank, the current datetime will be used. Formatted as YYYY-MM-DDTHH:MM:SS in UTC timezone.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Destination Parameters
db required

MySQL database where the data will be stored.

target_table required

Name of the table, in schema.table format, where data will be stored.

create_table_if_dne required

If the specified table does not exist, enable to automatically create it.

table_config

If the table will be automatically generated, select a Shared Config with the column names and types.

skip_error required

Continue downloading subsequent data if an error occurs.

errors_table_name

Optional name of the table, in schema.table format, where errors will be stored.