Daylight Saving Time Issue Updating Custom Date Field via XML-RPC Using Infusionsoft SDK

API Q&A
1

Hello Keap Team,

We are using the Infusionsoft SDK to update a custom date field (_LMILastLogin) via XML-RPC, but we are encountering the following error:

Error: Failed to invoke method load in class com.infusionsoft.api.xmlrpc.XmlRpcContactService: java.sql.SQLException: HOUR_OF_DAY: 2 → 3

The SDK handles the XML formatting, so we have no control over how the date is structured in the payload. If the SDK does not modify the format, how should we proceed?

Is this issue related to time zone handling or daylight saving time (DST) in Keap’s backend? Any insights or solutions would be appreciated.

Thank you!

2

@Fady_khateeb try passing the date to the API using the following format:

Ymd\TH:i:s

The result should look something like this:
20250412T09:05:00

It’s possible that the format of the date you’re passing into the API isn’t being parsed correctly, and throwing the error.