• jimmykoh

    (@jimmykoh)


    Hi,

    I’m trying to map my multi-select field on CF7 to my Pardot Salesforce multi-picklist. However, the remote post data is passing as a string array i.e, Singapore, Hong Kong, Malaysia, for countries field which is a multi-select that saves in Pardot as a single string but results in an error when syncing in Salesforce. Salesforce needs the data in

    • Singapore
    • Hong Kong
    • Malaysia

    I have tested with delimiter using a semi-colon ; based on what Pardot support said but it’s not working as well. How can I post the data of the form in a HTTP post request format as opposed to using remote post function?

    I’m only having issues with multi-select else the rest are working perfectly fine. What I’m looking to achieve is to past the “Countries” array that Pardot recognizes in the above UL LI format or instead of remote post, do a HTTP post with multi-select value delimiter as a ; instead.

    Thanks!

    *** Service ***
    [name] => Pardot
    [url] => https://marketing.boardroomlimited.com/l/846413/2020-02-03/mdsrtq
    [method] => post
    [forms] => Array (
    [0] => cf7_5098
    )
    [success] =>
    [failure] =>
    [timeout] => 10
    [delim] => |
    [mapping] => Array (
    [0] => Array (
    [lbl] => Name
    [src] => last-name
    [3rd] => last-name
    )
    [1] => Array (
    [lbl] => Email Address
    [src] => your-email
    [3rd] => your-email
    )
    [2] => Array (
    [lbl] => The Company
    [src] => company
    [3rd] => company
    )
    [3] => Array (
    [lbl] => Phone Number
    [src] => phone-number
    [3rd] => phone-number
    )
    [4] => Array (
    [lbl] => Job Title
    [src] => job-title
    [3rd] => job-title
    )
    [5] => Array (
    [lbl] => Industry
    [src] => industry
    [3rd] => industry
    )
    [6] => Array (
    [lbl] => Countries That Require Services
    [src] => countries
    [3rd] => countries
    )
    [7] => Array (
    [lbl] => Total Head Count
    [src] => head-count
    [3rd] => head-count
    )
    [8] => Array (
    [lbl] => Your Message
    [src] => your-message
    [3rd] => your-message
    )
    [9] => Array (
    [lbl] => Region (Hidden)
    [src] => region
    [3rd] => region
    )
    [10] => Array (
    [lbl] => Office (Hidden)
    [src] => office
    [3rd] => office
    )
    [11] => Array (
    [lbl] => Currency (Hidden)
    [src] => currency
    [3rd] => currency
    )
    [12] => Array (
    [lbl] => Key Service Category
    [src] => key_service_category
    [3rd] => key_service_category
    )
    [13] => Array (
    [lbl] => Secondary Lead Source (Hidden)
    [src] => secondary_source
    [3rd] => secondary_source
    )
    [14] => Array (
    [lbl] => Lead Status
    [src] => lead_status
    [3rd] => lead_status
    )
    [15] => Array (
    [lbl] => Lead Source
    [src] => lead_source
    [3rd] => lead_source
    )
    )

    *** Post (Form) ***
    https://ignitepayroll.boardroomlimited.com/wp-json/contact-form-7/v1/contact-forms/5098/feedback
    [_wpcf7] => 5098
    [_wpcf7_version] => 5.1.6
    [_wpcf7_locale] => en_US
    [_wpcf7_unit_tag] => wpcf7-f5098-p4563-o1
    [_wpcf7_container_post] => 4563
    [g-recaptcha-response] => 03AERD8XoU44aqLrd5Tw44bquSO2FKvwUgZsZE5pYVQJpicR4u0iiN2MqC58jMM55aJFcXW1cgcTeFEf7SBNGdLICZdTV-r0Z6pcXO4iqaVC6hTA4UCtcpLQFCGUwebGh190IFRmtAODhv-FcDcocTXP751whidYDQFhUx6l4nstEGoR3eojLkniEwVaH4k-AIaNlibQ…
    [last-name] => jimmy
    [company] => boardroom
    [your-email] => jimmy@***.com.sg
    [phone-number] => 11111111
    [job-title] => Manager
    [industry] => Financial Services
    [countries] => Array (
    [0] => Afghanistan
    [1] => Albania
    [2] => Algeria
    [3] => Singapore
    )
    [head-count] => 50
    [your-message] => test
    [acceptance-731] => 1
    [lead_source] => Website
    [secondary_source] => Ignite
    [key_service_category] => Regional Payroll
    [company_type] => Private Companies – Non-Listed
    [region] => Singapore
    [currency] => SGD
    [lead_status] => Open
    [office] => Main Office
    [utm_campaign] =>
    [utm_source] =>
    [utm_medium] =>
    [utm_term] =>
    [utm_content] =>
    [gclid] =>

    *** Post (to Service) ***
    [timeout] => 10
    [body] => Array (
    [last-name] => jimmy
    [your-email] => [email protected]
    [company] => boardroom
    [phone-number] => 11111111
    [job-title] => Manager
    [industry] => Financial Services
    [countries] => Afghanistan;Albania;Algeria;Singapore
    [head-count] => 50
    [your-message] => test
    [region] => Singapore
    [office] => Main Office
    [currency] => SGD
    [key_service_category] => Regional Payroll
    [secondary_source] => Ignite
    [lead_status] => Open
    [lead_source] => Website
    )

    *** Response ***
    [

  • The topic ‘Pardot Multi select picklist’ is closed to new replies.