The NGPVAN:Import Event Signups templated script allows users to import event signups and store them in a Platform table. You can use it for both NGP and VAN events by inputting the respective credential (NGP or VAN) in the NGPVAN Credential parameter. (Click here for credential creation info).
You can create your script using this link, or in Platform you can navigate to Code → Scripts → More Script Templates and searching for “NGPVAN Get and Store Event Signups" or “36683”. If you are not shared on this template, please email support@civisanalytics.com.
Parameters
- Cluster (required): Name of the destination cluster for imported data.
- Database Credential (required): A valid database credential for the cluster.
- Output Table (required): Name of table to store event signup results
- Output Table Setting (required): Drop or append existing rows in output table
- VAN Event ID (required): Unique ID of NGPVAN event
- NGP VAN Credential (required): A custom Civis credential with a username and password for NGP or VAN.
Output Table Fields
|
Column Name |
Type |
|
end_time_override |
varchar(1024) |
|
event_id |
integer |
|
event_name |
varchar(1024) |
|
event_signup_id |
integer |
|
location_id |
integer |
|
location_name |
varchar(1024) |
|
role_id |
integer |
|
role_name |
varchar(1024) |
|
shift_id |
integer |
|
shift_name |
varchar(1024) |
|
start_time_override |
varchar(1024) |
|
status_id |
integer |
|
status_name |
varchar(1024) |
|
van_id |
integer |
Comments
0 comments
Article is closed for comments.