JSON Response Not Working

jerrydiaz11 · 2018-08-20 13:37:34 UTC

1) Give a description of the problem
Two queries to the same site produce different results.

2) What is the expected behavior?
Return Holiday info on respective Web request

3) What is happening/not happening?
The Workday query is correct and returns a value. Although testing the exact URL manually in a browser works correctly, in WebCoRE, it returns a Null

4) Post a Green Snapshot of the piston

5) Attach any logs (From ST IDE and by turning logging level to Full)
0f3ad38d-3925-4a09-8b33-f51e517e6396 9:36:29 AM: trace ║║ Executed virtual command setVariable (3ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: trace ║║ Executed virtual command httpRequest (527ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: trace ║╔ Execution stage complete. (1217ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: debug ║║ Calculating (string) https://kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date= + (string) 20-08-2018 &gt;&gt; (string) https://kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date=20-08-2018

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: debug ║║ Calculating (string) https://kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date=20-08-2018&amp;country=usa&amp;amp; + (string) region=ny &gt;&gt; (string) https://kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date=20-08-2018&amp;country=usa&amp;amp;region=ny

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: debug ║║ Sending external web request to: kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date=20-08-2018&amp;country=usa&amp;amp;region=ny

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: info ╔ Event processed successfully (1339ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: debug ║║ Sending external web request to: kayaposoft.com/enrico/json/v2.0/?action=getHolidaysForDateRange&amp;fromDate=25-12-2018&amp;toDate=25-12-2018&amp;country=usa&amp;amp;region=ny&amp;holidayType=public_holiday

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: debug ║║ Calculating (string) https://kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date=20-08-2018 + (string) &amp;country=usa&amp;amp; &gt;&gt; (string) https://kayaposoft.com/enrico/json/v2.0/?action=isWorkDay&amp;date=20-08-2018&amp;country=usa&amp;amp;

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: trace ║║ Executed virtual command httpRequest (620ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:29 AM: trace ║║ Executed virtual command setVariable (3ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: debug ║║ Calculating (string) https://kayaposoft.com/enrico/json/v2.0/?action=getHolidaysForDateRange&amp;fromDate=25-12-2018&amp;toDate=25-12-2018 + (string) &amp;country=usa&amp;amp; &gt;&gt; (string) https://kayaposoft.com/enrico/json/v2.0/?action=getHolidaysForDateRange&amp;fromDate=25-12-2018&amp;toDate=25-12-2018&amp;country=usa&amp;amp;

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: debug ║║ Calculating (string) https://kayaposoft.com/enrico/json/v2.0/?action=getHolidaysForDateRange&amp;fromDate=25-12-2018&amp;toDate=25-12-2018&amp;country=usa&amp;amp; + (string) region=ny&amp;holidayType=public_holiday &gt;&gt; (string) https://kayaposoft.com/enrico/json/v2.0/?action=getHolidaysForDateRange&amp;fromDate=25-12-2018&amp;toDate=25-12-2018&amp;country=usa&amp;amp;region=ny&amp;holidayType=public_holiday

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: trace ║╚ Execution stage started

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: trace ║ Runtime (40844 bytes) successfully initialized in 58ms (v0.3.107.20180806) (117ms)

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: debug ║║ Cancelling statement #1's schedules...

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: debug ║ RunTime Analysis CS &gt; 21ms &gt; PS &gt; 58ms &gt; PE &gt; 38ms &gt; CE

[0f3ad38d-3925-4a09-8b33-f51e517e6396](https://graph-na02-useast1.api.smartthings.com/ide/logs#0f3ad38d-3925-4a09-8b33-f51e517e6396) 9:36:28 AM: info ╚ Received event [Home].execute = 74.102.90.198 with a delay of 55ms

Thanks

eibyer · 2018-08-20 15:09:00 UTC

I tried doing the web request and got the proper response… I did modify your piston a bit though.

jerrydiaz11 · 2018-08-20 18:07:41 UTC

That modification worked? Because it also removed my formatting of the &region value, resulting in “&reg” being converted to the HTML5 character entity reference of the ”®” symbol, as you can see in your upload. That worked for you despite this?

eibyer · 2018-08-20 18:12:20 UTC

It looks like a display bug. Tagging @ipaterson to see if it is. The URL is still correct in the editor if I open it.

jerrydiaz11 · 2018-08-20 18:22:05 UTC

Would you mind please saving a screenshot with a backup code so I can load what you did? Adding the log to message didn’t make a difference and my workday query loads as expected without. Thanks.

eibyer · 2018-08-20 18:30:50 UTC

I split the URL at the ‘region’ part…

jerrydiaz11 · 2018-08-20 19:13:38 UTC

Thanks but I’m still getting the same non-result. I had to still enter the url’s themselves so I’m not sure if that’s the issue or not. You’re getting the full Christmas Day holiday value for the non-Boolean variable?

eibyer · 2018-08-20 20:35:29 UTC

Sorry, in the first piston I posted, I was just logging the $response. This time, I modified it to save the $response to variable and this is what I have as far as value after executing the piston.

ipaterson · 2018-08-20 23:33:24 UTC

Yes, a display bug. There have been similar reports in the past, it’s caused by a pattern used throughout the app that could be very time consuming to fix. The fix is replacing & with & in any user input that is displayed as HTML, in a way that does not interfere with any of the webCoRE content. URLs are particularly prone to this display glitch due to the & character.

jerrydiaz11 · 2018-08-20 23:46:57 UTC

Yes that’s exactly what my initial URL posted in the first message did. It displays without the “amp;” in the same way the ® replaces the “&reg.” I’ve worked that bit out … but I’m still unable to return anything but a null value for that query. The other (using the same formatting on the region) works as expected.

jerrydiaz11 · 2018-08-21 00:21:16 UTC

Yet somehow this worked. It makes no sense to me at all why but I’ve learned to stop concerning myself with the why when something finally works.
Thanks for your help guys.