Help, I have a problem! Last night (NZ local time 12/10/2018 20:00) I had a version of my app working well. I made some changes this morningโฆNow I canโt seem to restore a working version. It doesnโt help that the timestamp on the version history doesnโt seem to be local timeโฆ Can any one suggest anything? I had just got my webhook API working and since making my changes it has stopped working, and restoring older versions hasnโt worked yetโฆ I have made a bit of a mess of version history in trying to restore. Thanks
Getting this Rest API error: Error: Value โโ in field โDateโ in table โRentReceivedโ cannot be converted to type โDateโ.",
Hi @William_Stewart have a look below at @Fabian post maybe it is the same error?
@Philip_Garrett_Appsh This part of it is working well! always more to refine though. Thanks for your input
See if passing the date in US date format (i.e. mm/dd/yyyy) fixes the problem.
I suspect that there is no problem with your app. The day just changed in NZ. If you are passing 13 and it is showing up in the month field, the date wonโt parse.
@Philip_Garrett_Appsh I was wondering that but I had changed the sheets format to us date thinking it would resolve it. Can I instead change the locale in the Json body to en-UK? I tried Australia but that didnโt seem to work.
What is the format of the date you are including in the JSON body? Is it โDD/MM/YYYYโ or "โMM/DD/YYYYโ?
@Philip_Garrett_Appsh the date it is copying is dd/mm/yyyy and locale of sheets and appsheet set to Australia. In Json it is set to US as it wouldnโt accept australia
And is that working? By that I mean, is the update performed correctly?
If not, please provide: 1. Your account id 2. The app name 3. The exact error message. 4. The exact steps to reproduce the problem.
I think you are probably right, that yesterday I got lucky with the date being 12 (i.e. highest month possible) and so it updated great. I subsequently made several changes, and then went to test to discover it no longer worked. I assumed it was because of all my changesโฆNow I have made a mess of records trying to recover a working app, not realising that the date format was likely the culprit. 1. 708906 2. Property Management App 3. {
โOperationโ: โREST API invokeโ,
โAppIdโ: โf30c709c-224b-43f2-90ff-2fcd917618f2โ,
โTableNameโ: โRentReceivedโ,
โActionโ: โAddโ,
โRestActionTypeโ: 1,
โDataActionโ: โApp: add a new row (not a row-level action)โ,
โlocaleโ: โen-USโ,
โlocationโ: โโ,
โrunAsUserEmailโ: โโ,
โtimezoneโ: โNew Zealand Standard Timeโ,
โtzOffsetโ: โ-780โ,
โuserIdโ: 708906,
โRowsโ: 1,
โPerformanceโ: โ{โVersionโ:1,โTimeโ:โ00:00:00.0616918โ,โPerformanceTimingRootโ:{โMidโ:317,โTimerโ:{โTimeโ:โ00:00:00.0616918โ},โChildrenโ:[{โMidโ:62,โTimerโ:{โTimeโ:โ00:00:00.0551892โ}}]}}โ,
โResultโ: โFailureโ,
โResultErrorโ: โError: Value โโ in field โDateโ in table โRentReceivedโ cannot be converted to type โDateโ.โ,
โRecordTypeโ: โStopโ } 4. Invoking bulk action Rent Received or Rent Not Received
@Philip_Garrett_Appsh Trial and error as there is no list of accepted Locale descriptions. I changed Locale to en-AU. Now working correctly again
Glad to hear that issue is resolved. Is everything working as you intended now?
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |