Hi,
We recently opened registrations for an upcoming event. We hired a company to build the website and registration form. We are using REST API to sync registrations to Marketo for a confirmation email. We found that some registrations are not syncing to Marketo because of the error code 1003. There is one field we ask for a personal url. I set up a custom field for that and the field type is URL. For some reasons, people who entered a link to that field will fail to sync to Marketo. Only entering the value "yes" or "no" will sync the information to Makreto. I am really confused because it's a URL field type. Why would that happen? I checked with the web developer, he said the API is set up correctly and they are just passing the data. It's on Marketo. Does anyone have any similar experience? Anything I can try to troubleshoot?
Please provide the output of the Describe Lead API endpoint and the exact JSON request you're sending to the Submit Form endpoint.
(I suspect in the process of assembling that info you'll discover that you were putting data in the wrong field.)
I posted the same question to the developer and below was what he sent me. I don't think this is what you're look for, right? I don't see any issue from below example. In this example, he removed the URL question from passing to Marketo. However, that question is still affecting the integration.
{
"input":[
{
"email":"test@ekkomedia.com",
"firstName":"Giannis",
"lastName":"Georgousis",
"discordUserID":"ExtraLife4Kids#1234",
"Hospital":"Alberta Children's Hospital Foundation",
"amongUs01":false,
"amongUs02":true,
"amongUs03":false,
"amongUs04":false,
"amongUs05":false,
"fallGuys":false,
"chess":false,
"magictheGathering":false,
"minecraft":false,
"rocketLeague":false,
"discordCommunity":true,
"LeadSource":"Web - CHW2021",
"eLU2021":"TRUE",
"cHWEventID":"321",
"cHWRegistrationStatus":"registered"
}
]
}
Would need to see the output of the Describe Lead API endpoint, which shows the instance's field names and types, alongside that JSON payload.
What do you mean by "still affecting" if it's not being passed?
Because we couldn't figure out what the issue was, we decided to remove that url field from passing to Marketo. That field is still in the form, but we are not sending that data to Marketo. However, this didn't fix the issue. People still need to enter "Yes" or "No" in that field to successfully sync their registration info to Marketo in order to receive the confirmation email. If they put a url in that field or any other words, it will not work.
This doesn't make sense.
They must have their field mapping wrong, there's no such thing as a required custom field. Guarantee they're sending data to/from the wrong fields, that's the only way that seemingly removing it from the payload wouldn't help.
Yes, this is very strange and it's really hard to troubleshoot when we don't have access to their server and look at what they've set up.
Here is the output from that endpoint.
{
"requestId": "14f7e#178611a13f9",
"result": [
{
"id": 2,
"displayName": "Company Name",
"dataType": "string",
"length": 255,
"rest": {
"name": "company",
"readOnly": false
},
"soap": {
"name": "Company",
"readOnly": false
}
},
{
"id": 3,
"displayName": "Site",
"dataType": "string",
"length": 255,
"rest": {
"name": "site",
"readOnly": false
},
"soap": {
"name": "Site",
"readOnly": false
}
},
{
"id": 4,
"displayName": "Billing Address",
"dataType": "text",
"rest": {
"name": "billingStreet",
"readOnly": false
},
"soap": {
"name": "BillingStreet",
"readOnly": false
}
},
{
"id": 5,
"displayName": "Billing City",
"dataType": "string",
"length": 255,
"rest": {
"name": "billingCity",
"readOnly": false
},
"soap": {
"name": "BillingCity",
"readOnly": false
}
},
{
"id": 6,
"displayName": "Billing State",
"dataType": "string",
"length": 255,
"rest": {
"name": "billingState",
"readOnly": false
},
"soap": {
"name": "BillingState",
"readOnly": false
}
},
{
"id": 7,
"displayName": "Billing Country",
"dataType": "string",
"length": 255,
"rest": {
"name": "billingCountry",
"readOnly": false
},
"soap": {
"name": "BillingCountry",
"readOnly": false
}
},
{
"id": 8,
"displayName": "Billing Postal Code",
"dataType": "string",
"length": 255,
"rest": {
"name": "billingPostalCode",
"readOnly": false
},
"soap": {
"name": "BillingPostalCode",
"readOnly": false
}
},
{
"id": 9,
"displayName": "Website",
"dataType": "url",
"length": 255,
"rest": {
"name": "website",
"readOnly": false
},
"soap": {
"name": "Website",
"readOnly": false
}
},
{
"id": 10,
"displayName": "Main Phone",
"dataType": "string",
"length": 255,
"rest": {
"name": "mainPhone",
"readOnly": false
},
"soap": {
"name": "MainPhone",
"readOnly": false
}
},
{
"id": 13,
"displayName": "Annual Revenue",
"dataType": "currency",
"rest": {
"name": "annualRevenue",
"readOnly": false
},
"soap": {
"name": "AnnualRevenue",
"readOnly": false
}
},
{
"id": 14,
"displayName": "Num Employees",
"dataType": "integer",
"rest": {
"name": "numberOfEmployees",
"readOnly": false
},
"soap": {
"name": "NumberOfEmployees",
"readOnly": false
}
},
{
"id": 15,
"displayName": "Industry",
"dataType": "string",
"length": 255,
"rest": {
"name": "industry",
"readOnly": false
},
"soap": {
"name": "Industry",
"readOnly": false
}
},
{
"id": 16,
"displayName": "SIC Code",
"dataType": "string",
"length": 40,
"rest": {
"name": "sicCode",
"readOnly": false
},
"soap": {
"name": "SICCode",
"readOnly": false
}
},
{
"id": 18,
"displayName": "Company Notes",
"dataType": "text",
"rest": {
"name": "mktoCompanyNotes",
"readOnly": false
},
"soap": {
"name": "MktoCompanyNotes",
"readOnly": false
}
},
{
"id": 29,
"displayName": "SFDC Account Id",
"dataType": "string",
"length": 50,
"rest": {
"name": "sfdcAccountId",
"readOnly": true
}
},
{
"id": 32,
"displayName": "Marketo Data.com Id",
"dataType": "string",
"length": 50,
"soap": {
"name": "Marketo Jigsaw Company Id",
"readOnly": false
}
},
{
"id": 33,
"displayName": "Marketo Data.com Status",
"dataType": "string",
"length": 50,
"soap": {
"name": "Marketo Jigsaw Company Status",
"readOnly": false
}
},
{
"id": 39,
"displayName": "Id",
"dataType": "integer",
"rest": {
"name": "id",
"readOnly": false
},
"soap": {
"name": "Id",
"readOnly": false
}
},
{
"id": 40,
"displayName": "Full Name",
"dataType": "string",
"length": 255,
"rest": {
"name": "mktoName",
"readOnly": true
}
},
{
"id": 41,
"displayName": "Person Type",
"dataType": "string",
"length": 50,
"rest": {
"name": "personType",
"readOnly": false
},
"soap": {
"name": "PersonType",
"readOnly": false
}
},
{
"id": 43,
"displayName": "Is Partner",
"dataType": "boolean",
"rest": {
"name": "mktoIsPartner",
"readOnly": false
}
},
{
"id": 44,
"displayName": "Is Lead",
"dataType": "boolean",
"rest": {
"name": "isLead",
"readOnly": false
},
"soap": {
"name": "IsLead",
"readOnly": false
}
},
{
"id": 45,
"displayName": "Is Customer",
"dataType": "boolean",
"rest": {
"name": "mktoIsCustomer",
"readOnly": false
}
},
{
"id": 46,
"displayName": "Is Anonymous",
"dataType": "boolean",
"rest": {
"name": "isAnonymous",
"readOnly": false
}
},
{
"id": 47,
"displayName": "Salutation",
"dataType": "string",
"length": 255,
"rest": {
"name": "salutation",
"readOnly": false
},
"soap": {
"name": "Salutation",
"readOnly": false
}
},
{
"id": 48,
"displayName": "First Name",
"dataType": "string",
"length": 255,
"rest": {
"name": "firstName",
"readOnly": false
},
"soap": {
"name": "FirstName",
"readOnly": false
}
},
{
"id": 49,
"displayName": "Middle Name",
"dataType": "string",
"length": 255,
"rest": {
"name": "middleName",
"readOnly": false
},
"soap": {
"name": "MiddleName",
"readOnly": false
}
},
{
"id": 50,
"displayName": "Last Name",
"dataType": "string",
"length": 255,
"rest": {
"name": "lastName",
"readOnly": false
},
"soap": {
"name": "LastName",
"readOnly": false
}
},
{
"id": 51,
"displayName": "Email Address",
"dataType": "email",
"length": 255,
"rest": {
"name": "email",
"readOnly": false
},
"soap": {
"name": "Email",
"readOnly": false
}
},
{
"id": 52,
"displayName": "Phone Number",
"dataType": "phone",
"length": 255,
"rest": {
"name": "phone",
"readOnly": false
},
"soap": {
"name": "Phone",
"readOnly": false
}
},
{
"id": 53,
"displayName": "Mobile Phone Number",
"dataType": "phone",
"length": 255,
"rest": {
"name": "mobilePhone",
"readOnly": false
},
"soap": {
"name": "MobilePhone",
"readOnly": false
}
},
{
"id": 54,
"displayName": "Fax Number",
"dataType": "phone",
"length": 255,
"rest": {
"name": "fax",
"readOnly": false
},
"soap": {
"name": "Fax",
"readOnly": false
}
},
{
"id": 57,
"displayName": "Job Title",
"dataType": "string",
"length": 255,
"rest": {
"name": "title",
"readOnly": false
},
"soap": {
"name": "Title",
"readOnly": false
}
},
{
"id": 58,
"displayName": "Contact Company",
"dataType": "reference",