Hi There,
We recently got our Marketo Developer Sandbox account. When we describe the Leads table via this url: https://839-ewi-267.mktorest.com/rest/v1/leads/describe.json?access_token=[access_token]โ, the json output (pasted below) doesn't contain any 'SFDC' related fields (SFDCAccountId, SFDCLeadOwnerId, SFDCLeadId, SFDCType, SFDCContactId). Is this expected? The rest documentation here: Get Multiple Leads by Filter Type ยป Marketo Developers โ states that 'SFDC' fields can be used in the filter type.
Thanks in advance.
{"requestId":"10cba#151a320317b","result":[{"id":4,"displayName":"Company Name","dataType":"string","length":255,"rest":{"name":"company","readOnly":false},"soap":{"name":"Company","readOnly":false}},{"id":5,"displayName":"Site","dataType":"string","length":255,"rest":{"name":"site","readOnly":false},"soap":{"name":"Site","readOnly":false}},{"id":6,"displayName":"Billing Address","dataType":"text","rest":{"name":"billingStreet","readOnly":false},"soap":{"name":"BillingStreet","readOnly":false}},{"id":7,"displayName":"Billing City","dataType":"string","length":255,"rest":{"name":"billingCity","readOnly":false},"soap":{"name":"BillingCity","readOnly":false}},{"id":8,"displayName":"Billing State","dataType":"string","length":255,"rest":{"name":"billingState","readOnly":false},"soap":{"name":"BillingState","readOnly":false}},{"id":9,"displayName":"Billing Country","dataType":"string","length":255,"rest":{"name":"billingCountry","readOnly":false},"soap":{"name":"BillingCountry","readOnly":false}},{"id":10,"displayName":"Billing Postal Code","dataType":"string","length":255,"rest":{"name":"billingPostalCode","readOnly":false},"soap":{"name":"BillingPostalCode","readOnly":false}},{"id":11,"displayName":"Website","dataType":"url","length":255,"rest":{"name":"website","readOnly":false},"soap":{"name":"Website","readOnly":false}},{"id":12,"displayName":"Main Phone","dataType":"string","length":255,"rest":{"name":"mainPhone","readOnly":false},"soap":{"name":"MainPhone","readOnly":false}},{"id":15,"displayName":"Annual Revenue","dataType":"currency","rest":{"name":"annualRevenue","readOnly":false},"soap":{"name":"AnnualRevenue","readOnly":false}},{"id":16,"displayName":"Num Employees","dataType":"integer","rest":{"name":"numberOfEmployees","readOnly":false},"soap":{"name":"NumberOfEmployees","readOnly":false}},{"id":17,"displayName":"Industry","dataType":"string","length":255,"rest":{"name":"industry","readOnly":false},"soap":{"name":"Industry","readOnly":false}},{"id":18,"displayName":"SIC Code","dataType":"string","length":40,"rest":{"name":"sicCode","readOnly":false},"soap":{"name":"SICCode","readOnly":false}},{"id":41,"displayName":"External Company Id","dataType":"string","length":50,"rest":{"name":"externalCompanyId","readOnly":false}},{"id":44,"displayName":"Id","dataType":"integer","rest":{"name":"id","readOnly":false},"soap":{"name":"Id","readOnly":false}},{"id":45,"displayName":"Full Name","dataType":"string","length":255,"rest":{"name":"mktoName","readOnly":true}},{"id":46,"displayName":"Person Type","dataType":"string","length":50,"rest":{"name":"personType","readOnly":false},"soap":{"name":"PersonType","readOnly":false}},{"id":48,"displayName":"Is Partner","dataType":"boolean","rest":{"name":"mktoIsPartner","readOnly":false}},{"id":49,"displayName":"Is Lead","dataType":"boolean","rest":{"name":"isLead","readOnly":false},"soap":{"name":"IsLead","readOnly":false}},{"id":50,"displayName":"Is Customer","dataType":"boolean","rest":{"name":"mktoIsCustomer","readOnly":false}},{"id":51,"displayName":"Is Anonymous","dataType":"boolean","rest":{"name":"isAnonymous","readOnly":false}},{"id":52,"displayName":"Salutation","dataType":"string","length":255,"rest":{"name":"salutation","readOnly":false},"soap":{"name":"Salutation","readOnly":false}},{"id":53,"displayName":"First Name","dataType":"string","length":255,"rest":{"name":"firstName","readOnly":false},"soap":{"name":"FirstName","readOnly":false}},{"id":54,"displayName":"Middle Name","dataType":"string","length":255,"rest":{"name":"middleName","readOnly":false},"soap":{"name":"MiddleName","readOnly":false}},{"id":55,"displayName":"Last Name","dataType":"string","length":255,"rest":{"name":"lastName","readOnly":false},"soap":{"name":"LastName","readOnly":false}},{"id":56,"displayName":"Email Address","dataType":"email","length":255,"rest":{"name":"email","readOnly":false},"soap":{"name":"Email","readOnly":false}},{"id":57,"displayName":"Phone Number","dataType":"phone","length":255,"rest":{"name":"phone","readOnly":false},"soap":{"name":"Phone","readOnly":false}},{"id":58,"displayName":"Mobile Phone Number","dataType":"phone","length":255,"rest":{"name":"mobilePhone","readOnly":false},"soap":{"name":"MobilePhone","readOnly":false}},{"id":59,"displayName":"Fax Number","dataType":"phone","length":255,"rest":{"name":"fax","readOnly":false},"soap":{"name":"Fax","readOnly":false}},{"id":62,"displayName":"Job Title","dataType":"string","length":255,"rest":{"name":"title","readOnly":false},"soap":{"name":"Title","readOnly":false}},{"id":63,"displayName":"Contact Company","dataType":"reference","rest":{"name":"contactCompany","readOnly":false},"soap":{"name":"Contact Company","readOnly":false}},{"id":64,"displayName":"Date of Birth","dataType":"date","rest":{"name":"dateOfBirth","readOnly":false},"soap":{"name":"DateofBirth","readOnly":false}},{"id":65,"displayName":"Address","dataType":"text","rest":{"name":"address","readOnly":false},"soap":{"name":"Address","readOnly":false}},{"id":66,"displayName":"City","dataType":"string","length":255,"rest":{"name":"city","readOnly":false},"soap":{"name":"City","readOnly":false}},{"id":67,"displayName":"State","dataType":"string","length":255,"rest":{"name":"state","readOnly":false},"soap":{"name":"State","readOnly":false}},{"id":68,"displayName":"Country","dataType":"string","length":255,"rest":{"name":"country","readOnly":false},"soap":{"name":"Country","readOnly":false}},{"id":69,"displayName":"Postal Code","dataType":"string","length":255,"rest":{"name":"postalCode","readOnly":false},"soap":{"name":"PostalCode","readOnly":false}},{"id":71,"displayName":"Original Source Type","dataType":"string","length":255,"rest":{"name":"originalSourceType","readOnly":true},"soap":{"name":"OriginalSourceType","readOnly":false}},{"id":72,"displayName":"Original Source Info","dataType":"string","length":2000,"rest":{"name":"originalSourceInfo","readOnly":true},"soap":{"name":"OriginalSourceInfo","readOnly":false}},{"id":73,"displayName":"Registration Source Type","dataType":"string","length":255,"rest":{"name":"registrationSourceType","readOnly":false},"soap":{"name":"RegistrationSourceType","readOnly":false}},{"id":74,"displayName":"Registration Source Info","dataType":"string","length":2000,"rest":{"name":"registrationSourceInfo","readOnly":false},"soap":{"name":"RegistrationSourceInfo","readOnly":false}},{"id":75,"displayName":"Original Search Engine","dataType":"string","length":255,"rest":{"name":"originalSearchEngine","readOnly":true},"soap":{"name":"OriginalSearchEngine","readOnly":false}},{"id":76,"displayName":"Original Search Phrase","dataType":"string","length":255,"rest":{"name":"originalSearchPhrase","readOnly":true},"soap":{"name":"OriginalSearchPhrase","readOnly":false}},{"id":77,"displayName":"Original Referrer","dataType":"url","length":255,"rest":{"name":"originalReferrer","readOnly":true},"soap":{"name":"OriginalReferrer","readOnly":false}},{"id":78,"displayName":"Email Invalid","dataType":"boolean","rest":{"name":"emailInvalid","readOnly":false}},{"id":79,"displayName":"Email Invalid Cause","dataType":"string","length":255,"rest":{"name":"emailInvalidCause","readOnly":false}},{"id":80,"displayName":"Unsubscribed","dataType":"boolean","rest":{"name":"unsubscribed","readOnly":false},"soap":{"name":"Unsubscribed","readOnly":false}},{"id":82,"displayName":"Unsubscribed Reason","dataType":"string","length":2000,"rest":{"name":"unsubscribedReason","readOnly":false},"soap":{"name":"UnsubscribedReason","readOnly":false}},{"id":83,"displayName":"Do Not Call","dataType":"boolean","rest":{"name":"doNotCall","readOnly":false},"soap":{"name":"DoNotCall","readOnly":false}},{"id":84,"displayName":"Do Not Call Cause","dataType":"string","length":255,"rest":{"name":"mktoDoNotCallCause","readOnly":false}},{"id":85,"displayName":"Do Not Call Reason","dataType":"string","length":2000,"rest":{"name":"doNotCallReason","readOnly":false},"soap":{"name":"DoNotCallReason","readOnly":false}},{"id":104,"displayName":"Anonymous IP","dataType":"string","length":255,"rest":{"name":"anonymousIP","readOnly":false},"soap":{"name":"AnonymousIP","readOnly":false}},{"id":105,"displayName":"Inferred Company","dataType":"string","length":255,"rest":{"name":"inferredCompany","readOnly":true},"soap":{"name":"InferredCompany","readOnly":false}},{"id":106,"displayName":"Inferred Country","dataType":"string","length":255,"rest":{"name":"inferredCountry","readOnly":true},"soap":{"name":"InferredCountry","readOnly":false}},{"id":107,"displayName":"Inferred City","dataType":"string","length":255,"rest":{"name":"inferredCity","readOnly":true}},{"id":108,"displayName":"Inferred State Region","dataType":"string","length":255,"rest":{"name":"inferredStateRegion","readOnly":true}},{"id":109,"displayName":"Inferred Postal Code","dataType":"string","length":255,"rest":{"name":"inferredPostalCode","readOnly":true}},{"id":110,"displayName":"Inferred Metropolitan Area","dataType":"string","length":255,"rest":{"name":"inferredMetropolitanArea","readOnly":true}},{"id":111,"displayName":"Inferred Phone Area Code","dataType":"string","length":255,"rest":{"name":"inferredPhoneAreaCode","readOnly":true}},{"id":127,"displayName":"Department","dataType":"string","length":255,"rest":{"name":"department","readOnly":false},"soap":{"name":"Department","readOnly":false}},{"id":131,"displayName":"Created At","dataType":"datetime","rest":{"name":"createdAt","readOnly":true}},{"id":132,"displayName":"Updated At","dataType":"datetime","rest":{"name":"updatedAt","readOnly":true}},{"id":137,"displayName":"Cookies","dataType":"string","length":255,"rest":{"name":"cookies","readOnly":false}},{"id":138,"displayName":"External Sales Person Id","dataType":"string","length":50,"rest":{"name":"externalSalesPersonId","readOnly":false}},{"id":141,"displayName":"Lead Person","dataType":"reference","rest":{"name":"leadPerson","readOnly":false},"soap":{"name":"Lead Person","readOnly":false}},{"id":143,"displayName":"Role","dataType":"string","length":50,"rest":{"name":"leadRole","readOnly":false},"soap":{"name":"LeadRole","readOnly":false}},{"id":144,"displayName":"Lead Source","dataType":"string","length":255,"rest":{"name":"leadSource","readOnly":false},"soap":{"name":"LeadSource","readOnly":false}},{"id":145,"displayName":"Lead Status","dataType":"string","length":255,"rest":{"name":"leadStatus","readOnly":false},"soap":{"name":"LeadStatus","readOnly":false}},{"id":146,"displayName":"Lead Score","dataType":"integer","rest":{"name":"leadScore","readOnly":false},"soap":{"name":"LeadScore","readOnly":false}},{"id":147,"displayName":"Urgency","dataType":"float","rest":{"name":"urgency","readOnly":false}},{"id":148,"displayName":"Priority","dataType":"integer","rest":{"name":"priority","readOnly":false}},{"id":149,"displayName":"Relative Score","dataType":"integer","rest":{"name":"relativeScore","readOnly":false}},{"id":160,"displayName":"Lead Rating","dataType":"string","length":255,"rest":{"name":"rating","readOnly":false},"soap":{"name":"Rating","readOnly":false}},{"id":179,"displayName":"Primary Lead Interest","dataType":"reference","rest":{"name":"personPrimaryLeadInterest","readOnly":false},"soap":{"name":"Person Primary Lead Interest","readOnly":false}},{"id":450,"displayName":"Lead Partition","dataType":"reference","rest":{"name":"leadPartitionId","readOnly":false},"soap":{"name":"Lead Partition ID","readOnly":false}},{"id":456,"displayName":"Lead Revenue Cycle Model ID","dataType":"reference","rest":{"name":"leadRevenueCycleModelId","readOnly":false},"soap":{"name":"Lead Revenue Cycle Model ID","readOnly":false}},{"id":458,"displayName":"Lead Revenue Stage ID","dataType":"reference","rest":{"name":"leadRevenueStageId","readOnly":false},"soap":{"name":"Lead Revenue Stage ID","readOnly":false}},{"id":505,"displayName":"Marketo Social Gender","dataType":"string","length":255,"rest":{"name":"gender","readOnly":false},"soap":{"name":"MarketoSocialGender","readOnly":false}},{"id":506,"displayName":"Marketo Social Facebook Display Name","dataType":"string","length":255,"rest":{"name":"facebookDisplayName","readOnly":false},"soap":{"name":"MarketoSocialFacebookDisplayName","readOnly":false}},{"id":507,"displayName":"Marketo Social Twitter Display Name","dataType":"string","length":255,"rest":{"name":"twitterDisplayName","readOnly":false},"soap":{"name":"MarketoSocialTwitterDisplayName","readOnly":false}},{"id":508,"displayName":"Marketo Social LinkedIn Display Name","dataType":"string","length":255,"rest":{"name":"linkedInDisplayName","readOnly":false},"soap":{"name":"MarketoSocialLinkedInDisplayName","readOnly":false}},{"id":510,"displayName":"Marketo Social Facebook Profile URL","dataType":"string","length":2000,"rest":{"name":"facebookProfileURL","readOnly":false},"soap":{"name":"MarketoSocialFacebookProfileURL","readOnly":false}},{"id":511,"displayName":"Marketo Social Twitter Profile URL","dataType":"string","length":2000,"rest":{"name":"twitterProfileURL","readOnly":false},"soap":{"name":"MarketoSocialTwitterProfileURL","readOnly":false}},{"id":512,"displayName":"Marketo Social LinkedIn Profile URL","dataType":"string","length":2000,"rest":{"name":"linkedInProfileURL","readOnly":false},"soap":{"name":"MarketoSocialLinkedInProfileURL","readOnly":false}},{"id":514,"displayName":"Marketo Social Facebook Photo URL","dataType":"string","length":2000,"rest":{"name":"facebookPhotoURL","readOnly":false},"soap":{"name":"MarketoSocialFacebookPhotoURL","readOnly":false}},{"id":515,"displayName":"Marketo Social Twitter Photo URL","dataType":"string","length":2000,"rest":{"name":"twitterPhotoURL","readOnly":false},"soap":{"name":"MarketoSocialTwitterPhotoURL","readOnly":false}},{"id":516,"displayName":"Marketo Social LinkedIn Photo URL","dataType":"string","length":2000,"rest":{"name":"linkedInPhotoURL","readOnly":false},"soap":{"name":"MarketoSocialLinkedInPhotoURL","readOnly":false}},{"id":518,"displayName":"Marketo Social Facebook Reach","dataType":"integer","rest":{"name":"facebookReach","readOnly":false},"soap":{"name":"MarketoSocialFacebookReach","readOnly":false}},{"id":519,"displayName":"Marketo Social Twitter Reach","dataType":"integer","rest":{"name":"twitterReach","readOnly":false},"soap":{"name":"MarketoSocialTwitterReach","readOnly":false}},{"id":520,"displayName":"Marketo Social LinkedIn Reach","dataType":"integer","rest":{"name":"linkedInReach","readOnly":false},"soap":{"name":"MarketoSocialLinkedInReach","readOnly":false}},{"id":522,"displayName":"Marketo Social Facebook Referred Visits","dataType":"integer","rest":{"name":"facebookReferredVisits","readOnly":false},"soap":{"name":"MarketoSocialFacebookReferredVisits","readOnly":false}},{"id":523,"displayName":"Marketo Social Twitter Referred Visits","dataType":"integer","rest":{"name":"twitterReferredVisits","readOnly":false},"soap":{"name":"MarketoSocialTwitterReferredVisits","readOnly":false}},{"id":524,"displayName":"Marketo Social LinkedIn Referred Visits","dataType":"integer","rest":{"name":"linkedInReferredVisits","readOnly":false},"soap":{"name":"MarketoSocialLinkedInReferredVisits","readOnly":false}},{"id":526,"displayName":"Marketo Social Total Referred Visits","dataType":"integer","rest":{"name":"totalReferredVisits","readOnly":true},"soap":{"name":"MarketoSocialTotalReferredVisits","readOnly":true}},{"id":527,"displayName":"Marketo Social Facebook Referred Enrollments","dataType":"integer","rest":{"name":"facebookReferredEnrollments","readOnly":false},"soap":{"name":"MarketoSocialFacebookReferredEnrollments","readOnly":false}},{"id":528,"displayName":"Marketo Social Twitter Referred Enrollments","dataType":"integer","rest":{"name":"twitterReferredEnrollments","readOnly":false},"soap":{"name":"MarketoSocialTwitterReferredEnrollments","readOnly":false}},{"id":529,"displayName":"Marketo Social LinkedIn Referred Enrollments","dataType":"integer","rest":{"name":"linkedInReferredEnrollments","readOnly":false},"soap":{"name":"MarketoSocialLinkedInReferredEnrollments","readOnly":false}},{"id":531,"displayName":"Marketo Social Total Referred Enrollments","dataType":"integer","rest":{"name":"totalReferredEnrollments","readOnly":true},"soap":{"name":"MarketoSocialTotalReferredEnrollments","readOnly":true}},{"id":532,"displayName":"Marketo Social Last Referred Visit","dataType":"datetime","rest":{"name":"lastReferredVisit","readOnly":false},"soap":{"name":"MarketoSocialLastReferredVisit","readOnly":false}},{"id":533,"displayName":"Marketo Social Last Referred Enrollment","dataType":"datetime","rest":{"name":"lastReferredEnrollment","readOnly":false},"soap":{"name":"MarketoSocialLastReferredEnrollment","readOnly":false}},{"id":534,"displayName":"Marketo Social Syndication Id","dataType":"string","length":2000,"rest":{"name":"syndicationId","readOnly":false},"soap":{"name":"MarketoSocialSyndicationId","readOnly":false}},{"id":535,"displayName":"Marketo Social Facebook Id","dataType":"string","length":2000,"rest":{"name":"facebookId","readOnly":false},"soap":{"name":"MarketoSocialFacebookId","readOnly":false}},{"id":536,"displayName":"Marketo Social Twitter Id","dataType":"string","length":2000,"rest":{"name":"twitterId","readOnly":false},"soap":{"name":"MarketoSocialTwitterId","readOnly":false}},{"id":537,"displayName":"Marketo Social LinkedIn Id","dataType":"string","length":2000,"rest":{"name":"linkedInId","readOnly":false},"soap":{"name":"MarketoSocialLinkedInId","readOnly":false}},{"id":584,"displayName":"Acquisition Program","dataType":"reference","rest":{"name":"acquisitionProgramId","readOnly":false},"soap":{"name":"Acquisition Program ID","readOnly":false}}],"success":true}
did you connect this to your SFDC Sandbox?
You aren't telling us what you want to do.