SOAP API update DateTime Field | Community
Skip to main content
August 6, 2014
Question

SOAP API update DateTime Field

  • August 6, 2014
  • 2 replies
  • 1007 views
I am using a php program to use the API to communicate to marketo. I would like to set a datetime to be null.
 
I have tried sending a blank and no value. There doesn't seem to be a way to set the field to blank,
 

<?xml version="1.0" encoding="UTF-8"?>

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns1="marketo.com/mktows/"><SOAP-ENV:Header><ns1:AuthenticationHeader><mktowsUserId>completesolar1_70493473515C4EE90C2019</mktowsUserId><requestSignature>cfcbe2135f3c49caf96e8af3dccc65b4031256ae</requestSignature><requestTimestamp>2014-08-06T14:25:53-04:00</requestTimestamp></ns1:AuthenticationHeader></SOAP-ENV:Header><SOAP-ENV:Body><ns1:paramsSyncMultipleLeads><leadRecordList><leadRecord><Id>1060045</Id><Email>c926f676-1f57-3f9f-fa83-52a8eaa340d1@none.com</Email><ForeignSysPersonId xsi:nil="true"/><ForeignSysType xsi:nil="true"/><leadAttributeList><attribute><attrName>next_meeting_c</attrName><attrType></attrType><attrValue></attrValue></attribute></leadAttributeList></leadRecord></leadRecordList><dedupEnabled xsi:nil="true"/></ns1:paramsSyncMultipleLeads></SOAP-ENV:Body></SOAP-ENV:Envelope>


What does the attrValue need to be set to blank out the data?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

August 7, 2014

Unfortunately, we can not do that. Even if it's a single space, we would set the it to be current timestamp instead of empty value. The single space only worked for string values.

Can you help me understand what you are trying to achieve by setting the datetime value to null?

Kenny_Elkington
Adobe Employee
Adobe Employee
August 8, 2014
Hey Jeff,

You can pass the string 'NULL' and it should blank the field.