Public Emarsys API Reference

The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the internal_ prefix in their names. Public API procedures do not have such prefix in their names.

All possible fields with their Ids were included, that you could manipulate with in SQL code in Data Virtuality Studio SQL editor.

Access to the administrator endpoints is restricted. If you need access, please contact Emarsys Support.

create view "emarsys_examples"."example_getInterfaceLanguages" as select
        *
    from
        ( call "emarsys_examples.getInterfaceLanguages" ( ) ) f
;;

create view "emarsys_connector_example"."example_getAccessLevels" as select
        *
    from
        ( call "emarsys_connector.getAccessLevels" ( ) ) f
;;

create view "emarsys_connector_example"."example_getAdministratorsList" as select
        *
    from
        ( call "emarsys_connector.getAdministratorsList" ( ) ) f
;;

create view "emarsys_examples"."example_getAvailableFieldChoices" as select
        *
    from
        ( call "emarsys.getAvailableFieldChoices" ( in_field_id => '6', in_lang => 'fr' ) ) f;;

exportDataDownload

Returns a CSV file once the export job is finished
Parameter
<in_Export_ID> (required): The identifier of the export job initiated at the Export Updated Contacts endpoint

create view "emarsys_connector_example"."example_ExportDataDownload" as select
        to_chars ( gg.response, 'UTF-8' ) as blobconverted
    from
        ( call "emarsys_connector.ExportDataDownload" ( "in_Export_ID" => 118559 ) ) gg

Exporting Changes

Export procedures include a sequence of api executed step by step to make the result returned as usual dataset.

Depending on the requested columns final dataset differs. 

To get the export_changes content you have to execute 2 procedures sequentially:

1. exportChanges_pre()
2. export_changes()

exportChanges_pre

As a result export_changes() procedure will be created, which includes all the fields except: 27 – avg. length of visit; 28 – avg. pages per day; 29 – last mail received; 32 – user status; 33 – contact source. Field's list is obtained by execution of getFields ( ).

export_changes

export_changes(string <in_start_date>, string <in_end_date>, string <in_lang>)

Parameters:

<in_start_date> (optional) - start date of a time range for request. The following date format is accepted here: YYYY-MM-DD. Please note that start date and end date must be different to have exported data. If value is not set day before current date is used.

<in_end_date> (optional) - end date of a time range for the request. The following date format is accepted here: YYYY-MM-DD. Please note that start date and end date must be different to have exported data. If value is not set current date is used.

<in_lang> (optional) - language, what is obtained by execution getLanguages ( ) . If nothing is set, default value is en.

CREATE VIEW "emarsys_connector_example"."example_export_changes" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.export_changes" ( "in_lang" => 'en' ) ) pp

Export Contact List

Export procedures include a sequence of api executed step by step to make the result returned as usual dataset.

Depending on the requested columns final dataset differs.  

To obtain export_changes content it's mandatory to execute 2 procedures sequentially:

1. exportContactList_pre()
2. export_contactlist()

exportContactList_pre

As a result export_contactlist() procedure will be created, which includes all the fields except: 27 – avg. length of visit; 28 – avg. pages per day; 29 – last mail received; 32 – user status; 33 – contact source. Field list is obtained by execution of getFields().

Creates procedure Export_ContactList
Parameter
<in2_lang> (optional): The language of the export

export_contactlist

Parameters:

<contactlist_ID> (required) - ID of a contact list to export the fields of the contacts from. It could be obtained by execution of getContactlists_names ().

<in_lang> (optional) - language from execution of getLanguages(). If nothing is set, default value is en.

CREATE VIEW "emarsys_connector_example"."example_export_contactlist" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.export_contactlist" ( "contactlist_ID" => 381180208, "in_lang" => 'en' ) ) pp

Export Contact Regs

Export procedures include a sequence of api executed step by step to make the result returned as usual dataset.

Depending on the requested columns final dataset differs.  

To obtain export_changes content it's mandatory to execute 2 procedures sequentially:

1. exportContactRegs_pre()

2. export_contact_regs()

exportContactRegs_pre

As a result export_contact_regs() procedure  will be created, which includes all the fields except: 27 – avg. length of visit; 28 – avg. pages per day; 29 – last mail received; 32 – user status; 33 – contact source. Field list is obtained by execution of getFields().

Creates procedure Export_Contact_Regs
Parameter
<in2_lang> (optional): The language of the export

export_contact_regs

export_contact_regs(string <in_start_date>, string <in_end_date>, string <in_lang>)

Parameters: 

<in_start_date> (optional) - start date of a time range for request. The following date formats is accepted here: YYYY-MM-DD HH:mm:SS, YYYY-MM-DD HH:mm, YYYY-MM-DD. Please note that start date and end date must be different to have exported data. If value is not set day before current date is used.

<in_end_date> (optional) - end date of a time range for request. The following date format is accepted here: YYYY-MM-DD HH:mm:SS, YYYY-MM-DD HH:mm, YYYY-MM-DD. Please note that start date and end date must be different to have exported data. If value is not set current date is used.

<in_lang> (optional) - language from execution of getLanguages(). If nothing is set, default value is en.

Export_Responses

Export procedures include a sequence of api executed step by step to make the result returned as usual dataset.

Depending on the requested columns final dataset differs. 

To obtain export_changes content it's mandatory to execute 2 procedures sequentially:

1. exportResponses_pre()
2. Export_Responses()

exportResponses_pre

As a result Export_responses() procedure will be created, which includes all the fields except: 27 – avg. length of visit; 28 – avg. pages per day; 29 – last mail received; 32 – user status; 33 – contact source. Field's list is obtained by execution of getFields().

Creates procedure export_Responses
Parameter
<in2_lang> (required): The language of the export
<in2_analysis_fields_responses> (required): The contact behaviors to analyse based on specific field types of the email campaign
<in2_contacts_fields_responses> (required): The field identifiers to include in the export

Attribute	Type	Description
state	boolean	State

create view "emarsys_connector_example"."example_exportResponses_pre" as select
f.state
from
( call "emarsys_connector.exportResponses_pre"(
"in2_lang" => 'en',
"in2_analysis_fields_responses" => '"5", "8", "15"',
"in2_contacts_fields_responses" => '"1", "3", "5"'
)) f

export_responses

export_responses(string <in_start_date>, string <in_end_date>, string <in_lang>)

Parameters:

<in_start_date> (optional) - start date of a time range for request. The following date formats is accepted here: YYYY-MM-DD HH:mm:SS, YYYY-MM-DD HH:mm, YYYY-MM-DD. If value is not set the day before current date is used.

<in_end_date> (optional) - end date of a time range for request. The following date format is accepted here: YYYY-MM-DD HH:mm:SS, YYYY-MM-DD HH:mm, YYYY-MM-DD.  If value is not set the day before current date is used.

<in_lang> (optional) - language from execution of getLanguages(). If nothing is set, default value is en.

CREATE VIEW "emarsys_connector_example"."example_export_responses" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.export_responses" ( "in_lang" => 'en' ) ) ss 

Export_segment

Export procedures include a sequence of api executed step by step to make the result returned as usual dataset.

Depending on the requested columns final dataset differs.

To obtain export_changes content it's mandatory to execute 2 procedures sequentially:

1. exportSegment_pre()
2. export_segment()

exportSegment_pre

As a result export_segment() procedure  will be created, which includes all the fields except: 27 – avg. length of visit; 28 – avg. pages per day; 29 – last mail received; 32 – user status; 33 – contact source. Field's list is obtained by execution of getFields().

Creates procedure Export_Changes
Parameter
<in2_lang> (required): The language of the export

CREATE VIEW "emarsys_connector_example"."example_exportSegment_pre" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.exportSegment_pre" ( ) ) f

export_segment

export_segment(integer <in_filter_id>, string <in_lang>) 

Parameters:

<in_filter_id>  (required) - segmentID to export the desired field content from contacts of it. Possible values are obtained by execution of getSegmentsList(). 

<in_lang> (optional) - language from execution of getLanguages(). If nothing is set, default value is en.

CREATE VIEW "emarsys_connector_example"."example_export_segment" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.export_segment" ( "in_filter_id" => 280021, "in_lang" => 'de' ) ) pp

do_query_export_status

Fetches the status data of the export by the ID returned by the export procedures.

do_query_export_status(integer <Export_ID>)

Parameter:

<Export_ID> (required) - an ID returned by the above export procedures.

CREATE VIEW "emarsys_connector_example"."example_query_export_status" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.do_query_export_status"(
    "Export_ID" => 27278
)) AS sta

Contact Fields

CREATE VIEW "emarsys_connector_example"."example_createField" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.createField" ( in_name => 'First Name', in_application_type => 'shorttext' ) ) f
;;

CREATE VIEW emarsys_connector_example.example_getFields AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getFields" ()) a

Contact Sources

getSource

Contact sources
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

CREATE VIEW emarsys_connector_example.example_getSource AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getSource" ()) a;;

createSource

New source
Parameter
<in_name> (required): The source name

CREATE VIEW "emarsys_connector_example"."example_createSource" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.createSource" ( in_name => 'source name' ) ) f
;;

create view "emarsys_connector_example"."example_deleteSource" as select
 *
 from
 ( call "emarsys_connector.deleteSource" ( in_source_id => 1234567 ) ) f
;;

deleteSource(integer <in_source_id>)

CREATE VIEW "emarsys_connector_example"."example_deleteSource" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteSource" ( in_source_id => 1234567 ) ) f
;;

checkSegmentContact

Is contact in segment
Parameter
<in_segment_id> (required): Segment Id
<in_contact_id> (required): Contact Id

CREATE VIEW "emarsys_connector_example"."example_checkSegmentContact" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.checkSegmentContact" ( in_segment_id => 199084, in_contact_id => 984966565 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_createCombinedSegment" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.createCombinedSegment" ( in_name => 'combined_6', in_include_relation => 'OR', in_include_segment_ids => '100011869' , in_exclude_relation => 'OR',in_exclude_segment_ids => '100017571, 100017572'  ) ) f         
;;

CREATE VIEW "emarsys_connector_example"."example_updateCombinedSegment" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.updateCombinedSegment" ( in_name => 'combined_6', in_include_relation => 'OR', in_include_segment_ids => '100011869' , in_exclude_relation => 'OR',in_exclude_segment_ids => '100017571, 100017572'  ) ) f         
;;

create view "emarsys_examples"."example_w_updateSegmentContactCriteria" as select
        *
    from
        ( call "emarsys.updateSegmentContactCriteria" ( in_segment_id => 1234567, in_contact_criteria => '{ "type": "and", "children": [{ "type": "criteria", "field": "gender", "operator": "equals", "value": "female" }, { "type": "criteria", "field": "age", "operator": "greater_or_equal", "value": "22" }]}' ) ) f;;

create view "emarsys_examples"."example_getCombinedSegment" as select
        *
    from
        ( call "emarsys.getCombinedSegment" ( in_combined_segment_id => 123123123 ) ) f;;

CREATE VIEW "emarsys_connector_example"."example_getCombinedSegmentsList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getCombinedSegmentsList" ( ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getConditions" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getConditions" ( ) ) f
;;

create view "emarsys_connector_example"."example_createContact" as select
*
from
( call "emarsys_connector.createContact" ( in_source_table => 'emarsys_connector.contacts' ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_createMultipleContacts" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.createMultipleContacts" ( in_source_table => 'emarsys_connector.contacts' ) ) f
;;

CREATE VIEW emarsys_connector_example.example_getContacts_emails AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getContacts_emails" (
                "in_limit" => null
                ,"in_excludeempty" => null
            )
        )a

CREATE VIEW "emarsys_connector_example"."example_getContactCriteria" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getContactCriteria" ( in_segment_id => 199084 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getContactInternalID" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getContactInternalID" ( in_key_field_id => '3', in_key_field_value => 'user@example.com' ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getContactEmailHistory" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getContactEmailHistory" ( in_contacts => '176415518, 749678081', in_start_date => '2014-11-05', in_end_date => '2014-11-05' ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteContact" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteContact" ( in_key_id => '3', in_key_value => 'user@example.com' ) ) f
;;

create view "emarsys_examples"."example_w_updateContact" as select
*
from
( call "emarsys.updateContact" ( in_source_table => 'emarsys.contacts' ) ) f;;

create view "emarsys_examples"."example_w_updateMultipleContacts" as select
*
from
( call "emarsys.updateMultipleContacts" ( in_source_table => 'emarsys.contacts' ) ) f;;

CREATE VIEW "emarsys_connector_example"."example_checkContactlistContact" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.checkContactlistContact" ( in_list_id => 381180208, in_contact_id => 381002129 ) ) f
;;

create view "emarsys_examples"."example_getContactlistContacts" as select
        *
    from
        ( call "emarsys.getContactlistContacts" ( in_list_id => 217410714 ) ) f;;

CREATE VIEW emarsys_connector_example.example_getContactlists_names AS SELECT
        *
    FROM
        ( CALL emarsys_connector.getContactlists_names ( ) ) a
;;

CREATE VIEW "emarsys_connector_example"."example_createContactList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.createContactList" ( in_source_table => 'source_table', in_name => 'new name' ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_addContactsToContactList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.addContactsToContactList" ( in_source_table => 'source_table', in_list_id => 381180208 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteContactsFromContactList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteContactsFromContactList" ( in_source_table => 'source_table', in_list_id => 381180208 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_renameContactList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.renameContactList" ( in_list_id => 381180208, in_name => 'new name' ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_replaceContactList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.replaceContactList" ( in_source_table => 'source_table', in_list_id => 381180208 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteContactList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteContactList" ( in_list_id => 381180208 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getCustomerFormsList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getCustomerFormsList" ( ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getCustomerSettings" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getCustomerSettings" ( ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_createEmailCampaign" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.createEmailCampaign" ( in_name => 'test_camp_6', in_language => 'en', in_fromemail => 'malekith@example.com', in_fromname => 'Malekith', in_subject => 'convergence', in_email_category => '111111111', in_html_source => 'Hello First Name...', in_text_source => 'Hello First Name...', in_browse => 0, in_text_only => 1, in_unsubscribe => 1, in_filter => '222222222'
        	 ) ) f
;; 

CREATE VIEW "emarsys_connector_example"."example_copyEmailCampaign" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.copyEmailCampaign" ( in_email_id => 255244 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteEmailCampaign" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteEmailCampaign" ( in_email_id => 255244 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_finalizeEmailCampaign" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.finalizeEmailCampaign" ( in_email_id => 255244 ) ) f
;;

create view "emarsys_examples"."example_getEmailCampaignCategories" as select
        *
    from
        ( call "emarsys_connector.getEmailCampaignCategories" ( ) ) f
;;

create view "emarsys_examples"."example_getEmailCampaignsList" as select
        *
    from
        ( call "emarsys.getEmailCampaignsList" ( showdeleted => 0 ) ) f;;

CREATE VIEW emarsys_connector_example.example_getLanguages AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getLanguages" ()) a
;;

CREATE VIEW "emarsys_connector_example"."example_updateEmailCampaign" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.updateEmailCampaign" ( in_email_id => 255244, in_name => 'test_camp_6', in_language => 'en', in_fromemail => 'malekith@example.com', in_fromname => 'Malekith', in_subject => 'convergence' ) ) f
;; 

create view "emarsys_connector_example"."example_updateEmailCampaignRecipientSource" as select
f.*
from
( call "emarsys_connector.updateEmailCampaignRecipientSource" ( in_email_id => 255244, in_filter_id => 0 ) ) f
;;

Sections

createEmailSection

CREATE VIEW "emarsys_connector_example"."example_createEmailSection" as select
        *
    from
        ( call "emarsys_connector.createEmailSection" ( in_email_id => 243551, in_section_id => 1, in_order => 2, in_group_id => 111111111, in_hide_on_mobile => true, in_header_source => 'example', in_header_align  => 'left', in_body_source => 'The section content goes here.', in_image_url => 'https://example.com/image_placeholder.php?a', in_image_align => 'right', in_image_width => 100, in_image_height => 100, in_image_hide_on_mobile => false, in_link_title => 'Link to more', in_is_image_linked => true, in_is_header_linked  => true, in_form_id => 0, in_target_audience => 'segment', in_use_social_network => 0, in_enable_network_sharing => false, in_target_audience_segment_id =>  111111111 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteEmailSection" as select
        *
    from
        ( call "emarsys_connector.deleteEmailSection" ( in_email_id => 239368, in_section_id => 1) ) f
;;

getEmailSection

CREATE VIEW "emarsys_connector_example"."example_getEmailSection" as select
        *
    from
        ( call "emarsys_connector.getEmailSection" ( in_email_id => 292386, in_section_id => 1 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getEmailSectionsList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getEmailSectionsList" ( in_email_id => 292386 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_updateEmailSection" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.updateEmailSection" ( in_email_id => 243551, in_section_id => 1, in_order => 2, in_group_id => 111111111, in_hide_on_mobile => true, in_header_source => 'example', in_header_align  => 'left', in_body_source => 'The section content goes here.', in_image_url => 'https://example.com/image_placeholder.php?a', in_image_align => 'right', in_image_width => 100, in_image_height => 100, in_image_hide_on_mobile => false, in_link_title => 'Link to more', in_is_image_linked => true, in_is_header_linked  => true, in_form_id => 0, in_target_audience => 'segment', in_use_social_network => 0, in_enable_network_sharing => false, in_target_audience_segment_id =>  111111111 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getEmailTemplate" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getEmailTemplate" ( in_template_id => 188846871 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getEmailTemplatesList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getEmailTemplatesList" ( ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteFile" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteFile" ( in_file_id => 173096 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_createFolder" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.createFolder" ( in_name => 'TEST_SUB_FOLDER', in_parent => 13659 ) ) f         
;; 

create view "emarsys_connector_example"."example_getFilesList" as select
*
from
( call "emarsys_connector.getFilesList" ( in_folder => 251029 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getFoldersList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getFoldersList" ( ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_uploadFile" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.uploadFile" ( in_filename => 'p.jpg', in_folder => 16025, in_preserve_filename => 1 ) ) f         
;;

create view "emarsys_connector_example"."example_сreateTrackedLink" as select
*
from
( call "emarsys_connector.сreateTrackedLink" (in_email_id => 239368, in_section_id => 1, in_url => 'http://example.com') ) f
;;

create view "emarsys_connector_example"."example_deleteAllTrackedLinks" as select
*
from
( call "emarsys_connector.deleteAllTrackedLinks" ( in_email_id => 239368 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_deleteTrackedLink" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.deleteTrackedLink" ( in_email_id => 239368, in_link_id => 1 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getEmailTrackedLink" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getEmailTrackedLink" ( in_email_id => 213110, in_link_id => 2 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getEmailTrackedLinksList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getEmailTrackedLinksList" ( in_email_id => 213110 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getLinkCategoriesList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getLinkCategoriesList" ( ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_updateTrackedLink" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.updateTrackedLink" (in_email_id => 239368, in_link_id => 1, in_url => 'http://example.com') ) f
;;

CREATE VIEW "emarsys_connector_example"."example_launchEmailCampaign" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.launchEmailCampaign" ( in_email_id => 255244 ) ) f
;; 

CREATE VIEW "emarsys_connector_example"."example_listEmailCampaignLaunches" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.listEmailCampaignLaunches" ( in_email_id => 239368 ) ) f
;; 

CREATE VIEW "emarsys_connector_example"."example_getDeliveryStatus" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.getDeliveryStatus" ( in_email_id => 239368 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getEmailCampaignContentURL" AS SELECT
        f.*
    FROM
        ( CALL "emarsys_connector.getEmailCampaignContentURL" ( in_email_id => 239368, in_key_id => '3', in_key_value => 'clint.barton@example.com' ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getResponseSummary" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getResponseSummary" ( in_email_id => 213110 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getResponsesResult" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getResponsesResult" ( in_type => 'bounced' ) ) f
;;

create view "emarsys_examples"."example_previewEmailCampaignContents" as select
f.*
from
( call "emarsys.previewEmailCampaignContents" ( in_email_id => 239368, in_version => 'html' ) ) f;;

create view "emarsys_connector_example"."example_sendTestEmail" as select
f.*
from
( call "emarsys_connector.sendTestEmail" ( in_email_id => 239368 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_unsubscribeEmailCampaignContact" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.unsubscribeEmailCampaignContact" ( in_email_id => 239368, in_launch_list_id => 1, in_contact_uid => '123123123') ) f         
;;

CREATE VIEW "emarsys_connector_example"."example_getSegmentContactsCount" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getSegmentContactsCount" ( in_segment_id => 199084 ) ) f
;;

getSegmentContactsList(integer <in_segment_id>)

CREATE VIEW "emarsys_connector_example"."example_getSegmentContactsList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getSegmentContactsList" ( in_segment_id => 199084 ) ) f
;;

CREATE VIEW "emarsys_connector_example"."example_getSegmentsList" AS SELECT
        *
    FROM
        ( CALL "emarsys_connector.getSegmentsList" ( ) ) s
;;

Start program
Parameter
<in_node_type> (required): The node type
<in_resource_id> (required): The identifier of the resource
<in_contact_list_id> (optional): The identifier of the contact list
<in_contact_id> (optional): The identifier of the contact
<in_data> (optional): Data

create view "emarsys_examples"."example_w_startProgram" as select
*
from
( call "emarsys.startProgram" ( in_node_type => 'example-event', in_resource_id => 42 ) ) f;;