Web Services

[dblake]

I'm having some luck calling one of my Caspio tables through Web Services. But I'd like to use the MySQL query in web services to select records for just the current date.

MySQL wants dates formated yyyy-mm-dd, but Caspio has them mm/dd/yyyy and when I try to use DATE_FORMAT(CURDATE(), '%m/%d/%Y') it get back a soap fault ... Fault: faultcode: soap:Client, faultstring: {SQL Server error: 'CURDATE' is not a recognized built-in function name.}

Any ideas?

Thanks

[Override]

getdate()

http://msdn.microsoft.com/en-us/library/ms188383.aspx

http://msdn.microsoft.com/en-us/library/ms186724.aspx

[Kurumi]

Hi - Just wanted to update everyone that beginning on October 3, 2022, Caspio will deprecate SOAP API Web Services and this option will be removed from API profile creation screen. Existing SOAP applications will continue to function until June 3, 2024. After this date, the Caspio SOAP API will no longer execute. We strongly recommend that you start migrating any existing SOAP calls to Caspio’s REST API to avoid interruption of your applications and benefit from modern API technology. To know more, you can check it here: https://howto.caspio.com/deprecations/deprecation-of-soap-web-service/

[Aether]

Hello - If you also want to check the other feature deprecation and the date it was deprecated then check it here :
https://howto.caspio.com/deprecations/deprecations/

[ParkLoey]

Hi, all! Just wanted to inform this thread that Caspio's recent release (48) states that SOAP API will officially retire this December 1st. If any of you are still using SOAP API in your Caspio app, it's best to sort it out as soon as you can 

https://howto.caspio.com/release-notes/caspio-49-0/#:~:text=Caspio Webhooks.-,Deprecations,-Deprecation of SOAP