CreateProgramMembersExportJob
Create a program members export job based on the given filters.
Execute
Sample EXECUTE CreateProgramMembersExportJob ProgramId='6117'
EXECUTE CreateProgramMembersExportJob ProgramId='6117,6182'
EXECUTE CreateProgramMembersExportJob ProgramId='6117', Columns='acquiredBy=acqBy,*'
EXECUTE CreateProgramMembersExportJob ProgramId='6117,6182', UpdatedAtStartAt='2024-01-01', UpdatedAtEndAt='2024-01-30', IsExhausted='false', NurtureCadence='paus', StatusNames='Not in Program'
Input
| Name | Type | Required | Description |
| Format | String | False | Format of export file to be generated. Available values are: CSV, TSV, SSV
使用できる値は次のとおりです。CSV, TSV, SSV デフォルト値はCSVです。 |
| Columns | String | False | Comma separated list of columns that will be retrieved. Defaults to * (all columns). Different header names can be specified for each column using this syntax: columnName=csvHeaderName i.e.:leadRole=Role,marketingSuspendedCause=SuspendedCause,*
デフォルト値は*です。 |
| UseAPINames | Boolean | False | If set to true, you must specify fields in the columns input based on their name in the Marketo API. Defaults to false, meaning you can provided column names based on the drivers metadata (sys_tablecolumns).
デフォルト値はfalseです。 |
| UpdatedAtStartAt | Datetime | False | Inclusive lower bound filter for the lead update datetime. |
| UpdatedAtEndAt | Datetime | False | Inclusive upper bound filter for the lead update datetime. |
| ProgramId | String | True | Comma separated list of up to 10 program ids for which program members will be retrieved. |
| IsExhausted | Boolean | False | Boolean used to filter program membership records for people who have exhausted content. |
| NurtureCadence | String | False | Used to filter program membership records for a given nurture cadence.
使用できる値は次のとおりです。paus, norm |
| StatusNames | String | False | Comma separated list of program member status names to filter by. |
Result Set Columns
| Name | Type | Description |
| Id | String | The Id of the export job. |
| Format | String | The format of the export job. |
| CreatedAt | Datetime | The date when the export job was created. |
| Status | String | The status of the export process. |
| Success | Boolean | Boolean indicating if the procedure was executed successfully. If false, the output parameter 'Details' will contain the failure details. |
| Details | String | Details of execution failure. NULL if success=true. |