subject:"Re\: JSON"

That script works here with HTTPS, I am guessing there is something else 
specific about the configuration.

 On 21 Aug 2015, at 1:23 pm, Peter W A Wood peterwaw...@gmail.com wrote:
 
 Jacque
 
 
 This works fine in LiveCode 7.0.3. I’ll download 7.1RC1 and see if it works 
 there too.
 
 Apart from the difference in LiveCode versions, there is one other difference 
 that may be significant. I am using HTTP on my machine not HTTPS. There have 
 been some bugs in LiveCode 7 HTTPS support. Is it possible for you to run 
 your test using HTTP to access your client’s server?
 
 Regards
 
 Peter
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Now I don't know what to try next. :( But I appreciate your help. This 
is a weird one.


Is your PHP script like the one Peter posted?

On 8/20/2015 10:30 PM, Charles Warwick wrote:

That script works here with HTTPS, I am guessing there is something else 
specific about the configuration.


On 21 Aug 2015, at 1:23 pm, Peter W A Wood peterwaw...@gmail.com wrote:

Jacque



This works fine in LiveCode 7.0.3. I’ll download 7.1RC1 and see if it works 
there too.


Apart from the difference in LiveCode versions, there is one other difference 
that may be significant. I am using HTTP on my machine not HTTPS. There have 
been some bugs in LiveCode 7 HTTPS support. Is it possible for you to run your 
test using HTTP to access your client’s server?

Regards

Peter

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode




--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


On 8/20/2015 10:23 PM, Peter W A Wood wrote:

Jacque



This works fine in LiveCode 7.0.3. I’ll download 7.1RC1 and see if
it works there too.


Apart from the difference in LiveCode versions, there is one other
difference that may be significant. I am using HTTP on my machine not
HTTPS. There have been some bugs in LiveCode 7 HTTPS support. Is it
possible for you to run your test using HTTP to access your client’s
server?


I'd thought of that too. I'll ask the PHP guy to set up an http URL. The 
other difference is the UTF8 encoding, but it's my understanding that 
servers always expect to receive that.


Thanks very much to you and Charles for your tests. I agree with Charles 
that it may indicate there is something wrong with the PHP script. If I 
give him the simple echo script that you posted here, is that a good test?


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Jacque

 On 21 Aug 2015, at 11:32, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 I'd thought of that too. I'll ask the PHP guy to set up an http URL.

I don’t think it is a problem with HTTPS. With Google and Stack overflow’s 
help, I found this website - http://httpbin.org - you can send a POST request 
to https://httpbin.org/post and it will return the POST data to you (in JSON). 
I ran your test against both the http:// and https:// URLs and both worked.

 The other difference is the UTF8 encoding, but it's my understanding that 
 servers always expect to receive that.

I don’t think that all servers expect to receive UTF-8. The character encoding 
can be specified in configuration files.

 Thanks very much to you and Charles for your tests. I agree with Charles that 
 it may indicate there is something wrong with the PHP script. If I give him 
 the simple echo script that you posted here, is that a good test?

It is possible but this may be more useful:

PHP:
?php 
  var_dump($_POST);
?

It will return the POST data received by PHP. For example:

LiveCode Message Box:

put textEncode({   quote  é  quote  : 1}, UTF-8) into tJSON
put json= before tJSON
post tJSON to URL http://localhost/jacque.php;
put textDecode(it, UTF-8)

This is what it returns:
array(1) {
  [json]=
  string(10) { é: 1}
}

Hope this helps.

Peter

PS I’m no PHP programmer.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Jacque

 
 This works fine in LiveCode 7.0.3. I’ll download 7.1RC1 and see if it works 
 there too.

Apart from the difference in LiveCode versions, there is one other difference 
that may be significant. I am using HTTP on my machine not HTTPS. There have 
been some bugs in LiveCode 7 HTTPS support. Is it possible for you to run your 
test using HTTP to access your client’s server?

Regards

Peter

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


 On 21 Aug 2015, at 10:58 am, Peter W A Wood peterwaw...@gmail.com wrote:
 
 put textEncode({   quote  é  quote  : 1}, UTF-8) into tJSON
 put json= before tJSON
 post URLEncode(tJSON) to URL http://Localhost/jacque.php 
 http://localhost/jacque.php
 put textDecode(it, UTF-8”)

You would want to urlEncode tJSON before you put json= before it so the = isn’t 
encoded.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Just before posting can you dump your tData variable into a binfile and send it 
to me. It's got to be something simple...

Sent from my iPhone

 On 21 Aug 2015, at 8:33 am, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 Thanks, but still no go. I get the same errors.
 
 Is anyone posting from LC 7? I also just tried 7.1rc1 but it doesn't work 
 either.
 
 On 8/20/2015 5:04 PM, Monte Goulding wrote:
 Is your convertToJSON function returning UTF8? I’m not sure what LC 7 does 
 when it concatenates “json=“ to a UTF8 string. If for example that json= is 
 UTF16 and the rest of the data is UTF8 it’s not surprising the server is 
 freaking out. Try:
 
 put textEncode(“json=“,”UTF8”) before tData
 
 On 21 Aug 2015, at 7:53 am, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 I'm still struggling with this. I have a valid JSON string, verified by a 
 web-checking site and by the PHP developer. He wants me to POST it this way:
 
 json=JSON string
 
 It doesn't work. He says the server receives it but it is not passed to the 
 PHP script because the main parameter is empty. Here's what I do:
 
  set the httpHeaders to content-type: application/json
  put convertToJSON() into tData -- produces valid JSON
  put json= before tData
  post tData to kServerURL
 
 The result is empty. The developer has set up the PHP to return the values 
 back to me for testing, but it is also always empty. He says this means 
 there is no main parameter, but he also said adding json= to the front 
 would provide that, he will just grab the params from what follows.
 
 The URL is https if that matters. I have also tried URLEncoding the JSON 
 but it didn't help. I also tried removing the custom header.
 
 He pointed me to this web site: https://www.hurl.it/ When I set it to 
 send JSON and enter the same params there, it POSTs successfully to the 
 server.
 
 How would you POST a JSON string to a PHP script on a secure server?
 
 --
 Jacqueline Landman Gay | jac...@hyperactivesw.com
 HyperActive Software   | http://www.hyperactivesw.com
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your 
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 
 
 -- 
 Jacqueline Landman Gay | jac...@hyperactivesw.com
 HyperActive Software   | http://www.hyperactivesw.com
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


 On 21 Aug 2015, at 9:25 am, Peter W A Wood peterwaw...@gmail.com wrote:
 
 You’re content is no longer valid JSON once you have inserted the “json=“ (at 
 the PHP developer’s request). There may be a conflict between the header and 
 the actual content. What happens if you remove the line setting the 
 httpHeaders?

That’s a good question. I can’t see anything wrong with the JSON itself after 
reviewing the file. Validates and formats fine in TextMate. Are you sure they 
want post and not get or put?
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


On 8/20/2015 6:25 PM, Peter W A Wood wrote:


You’re content is no longer valid JSON once you have inserted the
“json=“ (at the PHP developer’s request). There may be a conflict
between the header and the actual content. What happens if you remove
the line setting the httpHeaders?


Thanks Peter. No change, it still fails. I think the PHP guy is 
stripping off the json= anyway and just grabbing the parameters. But 
it does work without the header in LC 6.


I may as well remove the header I suppose.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


 On 21 Aug 2015, at 9:29 am, Monte Goulding mo...@sweattechnologies.com 
 wrote:
 
 That’s a good question. I can’t see anything wrong with the JSON itself after 
 reviewing the file. Validates and formats fine in TextMate. Are you sure they 
 want post and not get or put?

Hmm… I just remembered you said it works in 6 and not 7. Perhaps it’s not 
something simple after all but try not setting the header first...

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

It will still be useful… what I want to look at is what headers are generated 
and whether or not the JSON is still correctly formatted.

With a copy of the script, I should be able to tell you what is causing it to 
break between the versions.

I have been posting JSON data to PHP in other applications with no problems, so 
it must be something specific to what you are trying to do.

 On 21 Aug 2015, at 11:35 am, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 On 8/20/2015 7:24 PM, Charles Warwick wrote:
 If you are still having issues with this, I am happy to run a packet
 capture against it if you give me a copy of the script…
 
 That way I can tell you what the exact difference is between what LC7
 and LC6 actually post to the server…
 
 Actually, now that I think of it, this probably will show a good deal of 
 difference because the LC 7 version will be UTF8 and the LC 6 version won't.
 
 Which might be the problem, but I don't know. Do you think this would still 
 be useful?
 
 -- 
 Jacqueline Landman Gay | jac...@hyperactivesw.com
 HyperActive Software   | http://www.hyperactivesw.com
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

What happens if you comment out line 247 of revLibURL stack script? textEncode 
native here seems to be a rather dangerous thing to do…

 On 21 Aug 2015, at 9:45 am, Dave Cragg dcr...@lacscentre.co.uk wrote:
 
 
 On 21 Aug 2015, at 00:33, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 On 8/20/2015 6:25 PM, Peter W A Wood wrote:
 
 You’re content is no longer valid JSON once you have inserted the
 “json=“ (at the PHP developer’s request). There may be a conflict
 between the header and the actual content. What happens if you remove
 the line setting the httpHeaders?
 
 Thanks Peter. No change, it still fails. I think the PHP guy is stripping 
 off the json= anyway and just grabbing the parameters. But it does work 
 without the header in LC 6.
 
 What happens if you remove the httpHeader setting and also UrlEncode tData? 
 
 Dave
 
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Encoding the = would break the POST data, as it would no longer be assigned the 
json data itself as a POST variable….

you only want to url encode the contents of the json variable

 On 21 Aug 2015, at 11:17 am, Monte Goulding mo...@sweattechnologies.com 
 wrote:
 
 
 On 21 Aug 2015, at 10:58 am, Peter W A Wood peterwaw...@gmail.com wrote:
 
 put textEncode({   quote  é  quote  : 1}, UTF-8) into tJSON
 put json= before tJSON
 post URLEncode(tJSON) to URL http://Localhost/jacque.php 
 http://localhost/jacque.php
 put textDecode(it, UTF-8”)
 
 You would want to urlEncode tJSON before you put json= before it so the = 
 isn’t encoded.
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


On 8/20/2015 8:46 PM, Charles Warwick wrote:

It will still be useful… what I want to look at is what headers are
generated and whether or not the JSON is still correctly formatted.

With a copy of the script, I should be able to tell you what is
causing it to break between the versions.

I have been posting JSON data to PHP in other applications with no
problems, so it must be something specific to what you are trying to
do.


Okay, thanks very much. I just sent a test script to the list that fails 
reproducibly. You'll need to put in a valid URL though, I can't really 
give out my client's.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Jacque

 On 21 Aug 2015, at 10:13, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 Here's a test. This posts just fine in LC 6.x but fails in 7.0.6 and 7.1rc1.
 
 Make a field with this in it:
 
   [{Meals:Yes,Purpose:Business}]
 
 Now put this into a button or card script:
 
 constant kServerURL = https://www.domain.com/results.php 
 https://www.domain.com/results.php  --### use a valid URL here
 
 
 command sendToServer
  if the version  7 then
put fld 1 into tData
put json= before tData
  else
put textEncode(fld 1,UTF8) into tData
put textEncode(json=,UTF8) before tData
  end if
  post tData to kServerURL
  put it into tResponse
  put the result into tErr
  breakpoint -- so you can see it
 end sendToServer
 
 If someone can test this against a simple echo PHP maybe it will tell us 
 something. The real server returns empty in LC 7 and OK in LC 6.

This works fine in LiveCode 7.0.3. I’ll download 7.1RC1 and see if it works 
there too.

Peter

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

If you are still having issues with this, I am happy to run a packet capture 
against it if you give me a copy of the script… 

That way I can tell you what the exact difference is between what LC7 and LC6 
actually post to the server…

 On 21 Aug 2015, at 9:50 am, Monte Goulding mo...@sweattechnologies.com 
 wrote:
 
 What happens if you comment out line 247 of revLibURL stack script? 
 textEncode native here seems to be a rather dangerous thing to do…
 
 On 21 Aug 2015, at 9:45 am, Dave Cragg dcr...@lacscentre.co.uk wrote:
 
 
 On 21 Aug 2015, at 00:33, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 On 8/20/2015 6:25 PM, Peter W A Wood wrote:
 
 You’re content is no longer valid JSON once you have inserted the
 “json=“ (at the PHP developer’s request). There may be a conflict
 between the header and the actual content. What happens if you remove
 the line setting the httpHeaders?
 
 Thanks Peter. No change, it still fails. I think the PHP guy is stripping 
 off the json= anyway and just grabbing the parameters. But it does work 
 without the header in LC 6.
 
 What happens if you remove the httpHeader setting and also UrlEncode tData? 
 
 Dave
 
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


On 8/20/2015 6:45 PM, Dave Cragg wrote:

What happens if you remove the httpHeader setting and also UrlEncode
tData?


Still errors I'm afraid.

Monte wrote:


What happens if you comment out line 247 of revLibURL stack script?
textEncode native here seems to be a rather dangerous thing to do…


Still errors.

Charles wrote:


If you are still having issues with this, I am happy to run a packet
capture against it if you give me a copy of the script…

That way I can tell you what the exact difference is between what
LC7 and LC6 actually post to the server…


That sounds useful. I probably won't understand it but someone else here
might. I'll write you privately if you don't mind. Thanks.

Peter wrote:


I’m not sure if you are URLEncoding the data … that certainly seems
to cause a problem


I'm not URLEncoding the data, though I did try it and it failed. I'm not 
good enough with PHP to even begin to reproduce your setup. I'm a 
one-trick LC pony.


I'm also running a low-grade fever and feel awful, so it's probably 
affecting my thought processes. But I thought I could just post and be 
done with it.


The next hurdle will be getting this to run on iOS which is the target 
platform. I haven't even gone there yet.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


On 8/20/2015 7:24 PM, Charles Warwick wrote:

If you are still having issues with this, I am happy to run a packet
capture against it if you give me a copy of the script…

That way I can tell you what the exact difference is between what LC7
and LC6 actually post to the server…


Actually, now that I think of it, this probably will show a good deal of 
difference because the LC 7 version will be UTF8 and the LC 6 version won't.


Which might be the problem, but I don't know. Do you think this would 
still be useful?


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

If I send that to a PHP script on one of my servers, I receive the JSON data 
correctly from LC7 in the PHP script.

I will just run it against LC6 and make sure it is identical.

If you want, you can post to my PHP script and then we can see how it compares 
between the two versions.  If it works there, it may be an issue with server 
you are posting to or the way that the PHP script is trying to read the data.  
Probably best if you send me a direct e-mail if you want to do that.



 On 21 Aug 2015, at 12:13 pm, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 Here's a test. This posts just fine in LC 6.x but fails in 7.0.6 and 7.1rc1.
 
 Make a field with this in it:
 
   [{Meals:Yes,Purpose:Business}]
 
 Now put this into a button or card script:
 
 constant kServerURL = https://www.domain.com/results.php;  --### use a valid 
 URL here
 
 
 command sendToServer
  if the version  7 then
put fld 1 into tData
put json= before tData
  else
put textEncode(fld 1,UTF8) into tData
put textEncode(json=,UTF8) before tData
  end if
  post tData to kServerURL
  put it into tResponse
  put the result into tErr
  breakpoint -- so you can see it
 end sendToServer
 
 If someone can test this against a simple echo PHP maybe it will tell us 
 something. The real server returns empty in LC 7 and OK in LC 6.
 
 -- 
 Jacqueline Landman Gay | jac...@hyperactivesw.com
 HyperActive Software   | http://www.hyperactivesw.com
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Jacque

 On 21 Aug 2015, at 05:53, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 Here's what I do:
 
  set the httpHeaders to content-type: application/json
  put convertToJSON() into tData -- produces valid JSON
  put json= before tData
  post tData to kServerURL

You’re content is no longer valid JSON once you have inserted the “json=“ (at 
the PHP developer’s request). There may be a conflict between the header and 
the actual content. What happens if you remove the line setting the httpHeaders?

Regards

Peter

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

2015-08-20 Thread Dave Cragg


 On 21 Aug 2015, at 00:33, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 On 8/20/2015 6:25 PM, Peter W A Wood wrote:
 
 You’re content is no longer valid JSON once you have inserted the
 “json=“ (at the PHP developer’s request). There may be a conflict
 between the header and the actual content. What happens if you remove
 the line setting the httpHeaders?
 
 Thanks Peter. No change, it still fails. I think the PHP guy is stripping off 
 the json= anyway and just grabbing the parameters. But it does work without 
 the header in LC 6.

What happens if you remove the httpHeader setting and also UrlEncode tData? 

Dave



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Jacque

 On 21 Aug 2015, at 07:35, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 Right. Works without header in 6, fails in 7. Thanks for looking at my file. 
 I wonder what would happen if I use the LC 6 libURL script in LC 7. Will my 
 unicode go all wonky? The file I sent you is in English but most of the time 
 it won't be.

I ran a very simple test using the message box and a very simple PHP script. I 
was able to post json={JSON} to PHP and get it back.

In the message box (using LC 7..0.3)

post textEncode(json={  quote  é  quote  : 1}, UTF-8) to  URL 
http://Localhost/jacque.php;
put textDecode(it, UTF-8”)

The PHP script:

?php 
  echo($_POST[json]);
?

The result in the message box:

{é: 1}

This would indicate your issue is not caused by a bug.

I’m not sure if you are URLEncoding the data … that certainly seems to cause a 
problem

Revised LiveCode
put textEncode({   quote  é  quote  : 1}, UTF-8) into tJSON
put json= before tJSON
post URLEncode(tJSON) to URL http://Localhost/jacque.php;
put textDecode(it, UTF-8”)

Result 
PHP sends back an empty response.

Hope this is of some help.

Peter
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


On 8/20/2015 6:32 PM, Monte Goulding wrote:



On 21 Aug 2015, at 9:29 am, Monte Goulding
mo...@sweattechnologies.com wrote:

That’s a good question. I can’t see anything wrong with the JSON
itself after reviewing the file. Validates and formats fine in
TextMate. Are you sure they want post and not get or put?


Hmm… I just remembered you said it works in 6 and not 7. Perhaps it’s
not something simple after all but try not setting the header
first...


Right. Works without header in 6, fails in 7. Thanks for looking at my 
file. I wonder what would happen if I use the LC 6 libURL script in LC 
7. Will my unicode go all wonky? The file I sent you is in English but 
most of the time it won't be.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


Here's a test. This posts just fine in LC 6.x but fails in 7.0.6 and 7.1rc1.

Make a field with this in it:

   [{Meals:Yes,Purpose:Business}]

Now put this into a button or card script:

constant kServerURL = https://www.domain.com/results.php;  --### use a 
valid URL here



command sendToServer
  if the version  7 then
put fld 1 into tData
put json= before tData
  else
put textEncode(fld 1,UTF8) into tData
put textEncode(json=,UTF8) before tData
  end if
  post tData to kServerURL
  put it into tResponse
  put the result into tErr
  breakpoint -- so you can see it
end sendToServer

If someone can test this against a simple echo PHP maybe it will tell us 
something. The real server returns empty in LC 7 and OK in LC 6.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

I'm still struggling with this. I have a valid JSON string, verified by 
a web-checking site and by the PHP developer. He wants me to POST it 
this way:


json=JSON string

It doesn't work. He says the server receives it but it is not passed to 
the PHP script because the main parameter is empty. Here's what I do:


  set the httpHeaders to content-type: application/json
  put convertToJSON() into tData -- produces valid JSON
  put json= before tData
  post tData to kServerURL

The result is empty. The developer has set up the PHP to return the 
values back to me for testing, but it is also always empty. He says 
this means there is no main parameter, but he also said adding json= 
to the front would provide that, he will just grab the params from what 
follows.


The URL is https if that matters. I have also tried URLEncoding the JSON 
but it didn't help. I also tried removing the custom header.


He pointed me to this web site: https://www.hurl.it/ When I set it to 
send JSON and enter the same params there, it POSTs successfully to the 
server.


How would you POST a JSON string to a PHP script on a secure server?

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Is your convertToJSON function returning UTF8? I’m not sure what LC 7 does when 
it concatenates “json=“ to a UTF8 string. If for example that json= is UTF16 
and the rest of the data is UTF8 it’s not surprising the server is freaking 
out. Try:

put textEncode(“json=“,”UTF8”) before tData

 On 21 Aug 2015, at 7:53 am, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 I'm still struggling with this. I have a valid JSON string, verified by a 
 web-checking site and by the PHP developer. He wants me to POST it this way:
 
 json=JSON string
 
 It doesn't work. He says the server receives it but it is not passed to the 
 PHP script because the main parameter is empty. Here's what I do:
 
  set the httpHeaders to content-type: application/json
  put convertToJSON() into tData -- produces valid JSON
  put json= before tData
  post tData to kServerURL
 
 The result is empty. The developer has set up the PHP to return the values 
 back to me for testing, but it is also always empty. He says this means 
 there is no main parameter, but he also said adding json= to the front 
 would provide that, he will just grab the params from what follows.
 
 The URL is https if that matters. I have also tried URLEncoding the JSON but 
 it didn't help. I also tried removing the custom header.
 
 He pointed me to this web site: https://www.hurl.it/ When I set it to send 
 JSON and enter the same params there, it POSTs successfully to the server.
 
 How would you POST a JSON string to a PHP script on a secure server?
 
 -- 
 Jacqueline Landman Gay | jac...@hyperactivesw.com
 HyperActive Software   | http://www.hyperactivesw.com
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8


Okay, addendum: It works fine in LC 6.7.6. It fails entirely in 7.0.6.

I wish I'd tried that sooner. We need 7.x because of the unicode support.


On 8/20/2015 4:53 PM, J. Landman Gay wrote:

I'm still struggling with this. I have a valid JSON string, verified by
a web-checking site and by the PHP developer. He wants me to POST it
this way:

json=JSON string

It doesn't work. He says the server receives it but it is not passed to
the PHP script because the main parameter is empty. Here's what I do:

   set the httpHeaders to content-type: application/json
   put convertToJSON() into tData -- produces valid JSON
   put json= before tData
   post tData to kServerURL

The result is empty. The developer has set up the PHP to return the
values back to me for testing, but it is also always empty. He says
this means there is no main parameter, but he also said adding json=
to the front would provide that, he will just grab the params from what
follows.

The URL is https if that matters. I have also tried URLEncoding the JSON
but it didn't help. I also tried removing the custom header.

He pointed me to this web site: https://www.hurl.it/ When I set it to
send JSON and enter the same params there, it POSTs successfully to the
server.

How would you POST a JSON string to a PHP script on a secure server?




--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

Thanks, but still no go. I get the same errors.

Is anyone posting from LC 7? I also just tried 7.1rc1 but it doesn't
work either.

On 8/20/2015 5:04 PM, Monte Goulding wrote:

Is your convertToJSON function returning UTF8? I’m not sure what LC 7 does when
it concatenates “json=“ to a UTF8 string. If for example that json= is UTF16
and the rest of the data is UTF8 it’s not surprising the server is freaking
out. Try:

put textEncode(“json=“,”UTF8”) before tData

On 21 Aug 2015, at 7:53 am, J. Landman Gay jac...@hyperactivesw.com wrote:

I'm still struggling with this. I have a valid JSON string, verified by a
web-checking site and by the PHP developer. He wants me to POST it this way:

json=JSON string

It doesn't work. He says the server receives it but it is not passed to the PHP
script because the main parameter is empty. Here's what I do:

set the httpHeaders to content-type: application/json
put convertToJSON() into tData -- produces valid JSON
put json= before tData
post tData to kServerURL

The result is empty. The developer has set up the PHP to return the values back to me for testing, but
it is also always empty. He says this means there is no main parameter, but he also
said adding json= to the front would provide that, he will just grab the params from what follows.

The URL is https if that matters. I have also tried URLEncoding the JSON but it
didn't help. I also tried removing the custom header.

He pointed me to this web site: https://www.hurl.it/ When I set it to send
JSON and enter the same params there, it POSTs successfully to the server.

How would you POST a JSON string to a PHP script on a secure server?

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com

Re: JSON, URL-encode, and UTF-8

2015-08-17 Thread Monte Goulding


 On 18 Aug 2015, at 6:54 am, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 Thanks Monte. The JSON is created by EasyJSON from a LC array. Most of the 
 values in the array are in foreign languages with lots of non-ascii 
 characters, and those will become the values in the parameter string that I 
 will send in a POST. It doesn't look like EasyJSON does any UTF8 encoding 
 when creating the JSON.

I haven’t used EasyJSON because it was done after mergJSON so I can’t confirm 
about the utf8. If you are posting JSON then you don’t need to urlEncode. Just 
set the content type header to application/json
 
 So I guess I need to UTF8 encode the array before sending it to the JSON 
 parser, then URL-encode the JSON. Is it possible to textEncode a whole array 
 at once without looping through all the elements?

No, just UTF8 encode any elements (or keys) that’s not likely to be ASCII.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

2015-08-17 Thread Monte Goulding

I think we would need to see the API to know about the urlEncoding. Is it a 
parameter in your query string? If you need to urlEncode it will be the last 
thing you do. If you are using one of the script libraries the UTF8 encoding 
may be done for you. If you are using mergJSON then UTF8 encode anything that's 
not ASCII before you JSON encode.

Cheers

Monte

Sent from my iPhone

 On 18 Aug 2015, at 4:41 am, J. Landman Gay jac...@hyperactivesw.com wrote:
 
 I've confused myself. I need to send JSON to a server. The values will have 
 foreign characters in them. So I think I need to use textEncode to convert it 
 to UTF8 and also it needs to be URL encoded. Is that right? And if so, what 
 order do I do it in?
 
 Do I URL-encode each value in the array, then create the JSON, then 
 textEncode that? Or some other order? Or does textEncoding remove the need to 
 URL encode?

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON, URL-encode, and UTF-8

2015-08-17 Thread J. Landman Gay

Thanks Monte. The JSON is created by EasyJSON from a LC array. Most of 
the values in the array are in foreign languages with lots of non-ascii 
characters, and those will become the values in the parameter string 
that I will send in a POST. It doesn't look like EasyJSON does any UTF8 
encoding when creating the JSON.


So I guess I need to UTF8 encode the array before sending it to the JSON 
parser, then URL-encode the JSON. Is it possible to textEncode a whole 
array at once without looping through all the elements?



On 8/17/2015 3:28 PM, Monte Goulding wrote:

I think we would need to see the API to know about the urlEncoding.
Is it a parameter in your query string? If you need to urlEncode it
will be the last thing you do. If you are using one of the script
libraries the UTF8 encoding may be done for you. If you are using
mergJSON then UTF8 encode anything that's not ASCII before you JSON
encode.

Cheers

Monte

Sent from my iPhone


On 18 Aug 2015, at 4:41 am, J. Landman Gay
jac...@hyperactivesw.com wrote:

I've confused myself. I need to send JSON to a server. The values
will have foreign characters in them. So I think I need to use
textEncode to convert it to UTF8 and also it needs to be URL
encoded. Is that right? And if so, what order do I do it in?

Do I URL-encode each value in the array, then create the JSON, then
textEncode that? Or some other order? Or does textEncoding remove
the need to URL encode?


___ use-livecode mailing
list use-livecode@lists.runrev.com Please visit this url to
subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode




--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON Safe Text

2015-07-24 Thread David Bovill

Yes - it's taken from the wild (an HTML page on the internet). Then turned
into XML, then a table extracted etc - so looks to me like non-utf8 stuff
has go in there somewhere.

That's why I was wandering if there was a way to filter out arbitrary text
and make it utf8-safe. You know urlencode for utf8 - or plain text? I don't
want to encode all the spaces and normal / safe chars - just whatever weird
stuff got into the data?

On 24 July 2015 at 00:12, Monte Goulding mo...@sweattechnologies.com
wrote:


  On 24 Jul 2015, at 7:22 am, David Bovill david@viral.academy wrote:
 
  I'm placing the text into an array and then using Monte's mergJsonEncode
  function to decode it. Usually works fine - but in this case it looks
 like
  the content needs some tidying before I put it into the array.

 mergJSON will choke on anything that’s not utf8. Is it possible there’s
 some other encoded data there or something you are doing with the data is
 messing with the encoding?

 --
 M E R Goulding http://goulding.ws/
 Software development services
 Bespoke application development for vertical markets

 mergExt http://mergext.com/ - There's an external for that!

 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON Safe Text

2015-07-24 Thread Monte Goulding

You really need to know the encoding you are working with. Check if the page 
has a charset attribute first and if it does re-encode to utf8 first. The try 
it in mergJSON. If it chokes then the best you can do is replace any char 
greater than charToNum(127) with “?”. Other than that I think there are 
encoding detectors around but it may depend on how critical the data is...

 On 24 Jul 2015, at 4:03 pm, David Bovill david@viral.academy wrote:
 
 Yes - it's taken from the wild (an HTML page on the internet). Then turned
 into XML, then a table extracted etc - so looks to me like non-utf8 stuff
 has go in there somewhere.
 
 That's why I was wandering if there was a way to filter out arbitrary text
 and make it utf8-safe. You know urlencode for utf8 - or plain text? I don't
 want to encode all the spaces and normal / safe chars - just whatever weird
 stuff got into the data?
 
 On 24 July 2015 at 00:12, Monte Goulding mo...@sweattechnologies.com
 wrote:
 
 
 On 24 Jul 2015, at 7:22 am, David Bovill david@viral.academy wrote:
 
 I'm placing the text into an array and then using Monte's mergJsonEncode
 function to decode it. Usually works fine - but in this case it looks
 like
 the content needs some tidying before I put it into the array.
 
 mergJSON will choke on anything that’s not utf8. Is it possible there’s
 some other encoded data there or something you are doing with the data is
 messing with the encoding?
 
 --
 M E R Goulding http://goulding.ws/
 Software development services
 Bespoke application development for vertical markets
 
 mergExt http://mergext.com/ - There's an external for that!
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

--
M E R Goulding http://goulding.ws/ 
Software development services
Bespoke application development for vertical markets

mergExt http://mergext.com/ - There's an external for that!

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON Safe Text

2015-07-23 Thread Monte Goulding


 On 24 Jul 2015, at 7:22 am, David Bovill david@viral.academy wrote:
 
 I'm placing the text into an array and then using Monte's mergJsonEncode
 function to decode it. Usually works fine - but in this case it looks like
 the content needs some tidying before I put it into the array.

mergJSON will choke on anything that’s not utf8. Is it possible there’s some 
other encoded data there or something you are doing with the data is messing 
with the encoding?

--
M E R Goulding http://goulding.ws/ 
Software development services
Bespoke application development for vertical markets

mergExt http://mergext.com/ - There's an external for that!

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON parser discovery

2015-07-21 Thread Jim Lambert

MarkW wrote:
 json_pp  filename

Mark,

Very handy. Fast too.
Thanks!

Jim Lambert

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

2013-06-05 Thread Igor de Oliveira Couto

Sorry to come so late to this thread. 

It's nice to see that my little JSON library is being used. I wanted to let 
everyone know, that Monte's library is much faster and more efficient than the 
LiveCode-native solutions, like mine. I wholeheartedly recommend it. There are 
occasions, however, when a programmer may not be able to - or want to - use 
externals, so these native libraries can still come in handy.

I saw that someone wanted to add features to a native JSON library - for 
instance, forcing the parser to recognise a certain value as a string rather 
than a number. I kindly ask you to consider using the EasyJSON library as a 
base, and contributing back your enhancements to the code. EasyJSON is hosted 
here:

https://github.com/luxlogica/easyjson

I tried to take great care to thoroughly document the code, so that it would be 
easier for others to understand, debug and enhance later. EasyJSON has also 
been released into the public domain, meaning that it can be safely used in 
both Open Source and closed-source commercial projects.

And while you're there, you may want to check out another script I've released 
'into the wild': EasyLocalNumber:

https://github.com/luxlogica/easylocalnumber

This is a behaviour script that makes it relatively painless to create 
localised numeric fields - ie., enabling the user to enter numbers with 
customised decimal and thousands separators, and currency symbols. Any 
enhancements and bug-fixes there would be most welcome! :-)

Kindest regards to all,


--
Igor Couto
Sydney, Australia


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

2013-06-04 Thread Richard Gaskin


Mark Wieder wrote:

Well, what you want to push to the server depends on the key:value
pairs they expect. Here's a simple example:

{name : Tom McGrath, favorite_author : Dr. Seuss}

Here's an example from a mongodb student database:

{_id: {oid : 1234},
  student_id : 0,
  class_id : 49,
  scores : [
{type : exam, score : 54.6}
{type : quiz, score : 65.6}
{type : homework, score : 78}
{type : homework, score : 80.4}
  ]
}


JSON is a good argument for what I like to call LSON, where the L 
stands for LiveCode of course. :)


Similar to MongoDB's BSON, LSON is a very convenient way to move 
hierarchically-ordered data back and forth between sever and client, 
compressing arrays and then Base64'ing them for efficient, robust 
network transport:


function ArrayToLSON pArray
put arrayEncode(pArray) into tData
put compress(tData) into tData
return base64Encode(tData)
end ArrayToLSON

function LSONToArray pData
  try
put base64Decode(pData) into tData
put decompress(tData) into tData
put arrayDecode(tData) into tArray
  catch tErr
throw Error unpacking LSON data
  end try
  return tArray
end LSONToArray

My understanding is that LC's RevOnline uses that format, and I believe 
Andre is fond of it too.


Of course this only works if you have LC on both ends of the 
client-server setup, but who doesn't? :)


--
 Richard Gaskin
 Fourth World
 LiveCode training and consulting: http://www.fourthworld.com
 Webzine for LiveCode developers: http://www.LiveCodeJournal.com
 Follow me on Twitter:  http://twitter.com/FourthWorldSys

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

Monte, Are you saying that array's are not supported on iOS or are you saying 
that mergJSON is not supported on iOS? This is needed from an iOS app to send 
the data to my server from the app.

Tom

-- Tom McGrath III
http://lazyriver.on-rev.com
mcgra...@mac.com

On Jun 3, 2013, at 10:32 PM, Monte Goulding mo...@sweattechnologies.com wrote:

 Unfortunately as there's no array support for iOS externals I can't implement 
 mergJSON there...

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

mergJSON i do believe. arrays not being supported on iOS would come as kind
of a shock to me.


On Tue, Jun 4, 2013 at 4:17 PM, Thomas McGrath III mcgra...@mac.com wrote:

 Monte, Are you saying that array's are not supported on iOS or are you
 saying that mergJSON is not supported on iOS? This is needed from an iOS
 app to send the data to my server from the app.

 Tom

 -- Tom McGrath III
 http://lazyriver.on-rev.com
 mcgra...@mac.com

 On Jun 3, 2013, at 10:32 PM, Monte Goulding mo...@sweattechnologies.com
 wrote:

  Unfortunately as there's no array support for iOS externals I can't
 implement mergJSON there...

 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode




-- 
Regards,

Andrew Kluthe
and...@ctech.me
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

2013-06-04 Thread J. Landman Gay


On 6/4/13 4:17 PM, Thomas McGrath III wrote:

Monte, Are you saying that array's are not supported on iOS or are
you saying that mergJSON is not supported on iOS? This is needed from
an iOS app to send the data to my server from the app.


If Monte's external doesn't work out, there are several script-based 
solutions.


Igor de Oliveira Couto:
https://github.com/luxlogica/easyjson/blob/master/easyjson.lc

Andre Garzia:
http://andregarzia.com/stacks/lib.aag.json.livecode

Mark Smith:
http://revonline2.runrev.com/stack/82/LibJson-1-0b

Igor's is a newer update based on the other two, and in my tests it 
worked very well. You don't need to know JSON to use it. We eventually 
decided to go with plain text in my project, but I'd settled on Igor's 
library before we changed our minds.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON


On 05/06/2013, at 7:17 AM, Thomas McGrath III mcgra...@mac.com wrote:

 Monte, Are you saying that array's are not supported on iOS or are you saying 
 that mergJSON is not supported on iOS? This is needed from an iOS app to send 
 the data to my server from the app.

Arrays are not yet supported in iOS externals (it's all ifdefed out), however, 
it looks like I should be able to use the old externals sdk to compile for 
iOS... and possibly android if the external doesn't need any native features. 
Unlike most of my mergExt stuff mergJSON uses a cross platform C library and is 
a good candidate for that. However, this is probably going to be well down my 
priority list given I've only had one person interested in buying it and I 
don't currently need it on mobile...

--
Monte Goulding

M E R Goulding - software development services
mergExt - There's an external for that!





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

Thanks for the info. I am trying to use Igor's library and I am trying to build 
my first array to convert to json.

This is the info I have to send as json:
{data:
{appuser_details: 
{
name:Tom_iPad,
email:i...@gmail.com,
device_type:2,
dentist_id:73,
device_token:98be5c7a3cc9e400ae6a90977ac6d64f498bb01cbe83c3c3d1bb4856de59ba1c
} 
}
}

I think I need to send text/json as a header.

I have tried many things but I don't think I am sending the information 
correctly. 

I got a result error 400 Bad Request

I don't think my array is right.



-- Tom McGrath III
http://lazyriver.on-rev.com
mcgra...@mac.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

Are device_type and dentist_id meant to be strings or integers?

On 05/06/2013, at 7:55 AM, Thomas McGrath III mcgra...@mac.com wrote:

 Thanks for the info. I am trying to use Igor's library and I am trying to 
 build my first array to convert to json.
 
 This is the info I have to send as json:
 {data:
 {appuser_details: 
 {
 name:Tom_iPad,
 email:i...@gmail.com,
 device_type:2,
 dentist_id:73,
 device_token:98be5c7a3cc9e400ae6a90977ac6d64f498bb01cbe83c3c3d1bb4856de59ba1c
 } 
 }
 }
 
 I think I need to send text/json as a header.
 
 I have tried many things but I don't think I am sending the information 
 correctly. 
 
 I got a result error 400 Bad Request
 
 I don't think my array is right.
 
 
 
 -- Tom McGrath III
 http://lazyriver.on-rev.com
 mcgra...@mac.com
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

--
Monte Goulding

M E R Goulding - software development services
mergExt - There's an external for that!





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

I don't know Monte, I will try and find out. But the info below is what was 
sent in the test using a restful client by the developer of the api.


-- Tom McGrath III
http://lazyriver.on-rev.com
mcgra...@mac.com

On Jun 4, 2013, at 6:07 PM, Monte Goulding mo...@sweattechnologies.com wrote:

 Are device_type and dentist_id meant to be strings or integers?
 
 On 05/06/2013, at 7:55 AM, Thomas McGrath III mcgra...@mac.com wrote:
 
 Thanks for the info. I am trying to use Igor's library and I am trying to 
 build my first array to convert to json.
 
 This is the info I have to send as json:
 {data:
 {appuser_details: 
 {
 name:Tom_iPad,
 email:i...@gmail.com,
 device_type:2,
 dentist_id:73,
 device_token:98be5c7a3cc9e400ae6a90977ac6d64f498bb01cbe83c3c3d1bb4856de59ba1c
 } 
 }
 }
 
 I think I need to send text/json as a header.
 
 I have tried many things but I don't think I am sending the information 
 correctly. 
 
 I got a result error 400 Bad Request
 
 I don't think my array is right.
 
 
 
 -- Tom McGrath III
 http://lazyriver.on-rev.com
 mcgra...@mac.com
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 
 --
 Monte Goulding
 
 M E R Goulding - software development services
 mergExt - There's an external for that!
 
 
 
 
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

2013-06-04 Thread J. Landman Gay


On 6/4/13 4:55 PM, Thomas McGrath III wrote:

Thanks for the info. I am trying to use Igor's library and I am trying to build 
my first array to convert to json.

This is the info I have to send as json:
{data:
{appuser_details:
{
name:Tom_iPad,
email:i...@gmail.com,
device_type:2,
dentist_id:73,
device_token:98be5c7a3cc9e400ae6a90977ac6d64f498bb01cbe83c3c3d1bb4856de59ba1c
}
}
}

I think I need to send text/json as a header.

I have tried many things but I don't think I am sending the information 
correctly.

I got a result error 400 Bad Request

I don't think my array is right.


I got the same error at first. The web server can't understand what 
you're sending.


You just need to create a regular LiveCode array (none of that 
punctuation stuff,) pass it through Igor's library, and then send a POST 
with whatever you get back. I'm not sure about the headers, I don't 
think I had to change those but it might depend on the server.


Something like this off the top of my head:

put Tom_iPad into tArray[data][appuser_details][name]
put i...@gmail.com into tArray[data][appuser_details][email]
...etc
put jsonFromArray(tArray) into tJSON
post tJSON to http://xxx.xxx;

You might have to twiddle that a bit.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON


On 05/06/2013, at 8:16 AM, Thomas McGrath III wrote:

 I don't know Monte, I will try and find out. But the info below is what was 
 sent in the test using a restful client by the developer of the api.

strings then

--
M E R Goulding 
Software development services
Bespoke application development for vertical markets

mergExt - There's an external for that!

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON


On 05/06/2013, at 8:57 AM, J. Landman Gay wrote:

 I got the same error at first. The web server can't understand what you're 
 sending.
 
 You just need to create a regular LiveCode array (none of that punctuation 
 stuff,) pass it through Igor's library, and then send a POST with whatever 
 you get back. I'm not sure about the headers, I don't think I had to change 
 those but it might depend on the server.
 
 Something like this off the top of my head:
 
 put Tom_iPad into tArray[data][appuser_details][name]
 put i...@gmail.com into tArray[data][appuser_details][email]
 ...etc
 put jsonFromArray(tArray) into tJSON
 post tJSON to http://xxx.xxx;
 
 You might have to twiddle that a bit.

Ah... how is that library working out if something is a number or a string? If 
it's doing it's just using is a number then given you have numbers that you 
need to send as strings you're going to have a problem. You might need to look 
at the api and find out if it has a way to force elements to be a string. 
Alternatively... seeing as it's really not a big document and you don't need to 
do JSONToArray you could just put a template in a custom property and use 
merge...

Cheers

--
M E R Goulding 
Software development services
Bespoke application development for vertical markets

mergExt - There's an external for that!

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

I dont know about the libraries he is using, but if it is based at all on
the late mark smiths's the numbers in his array would translate to integers
in terms of the json it spits out. I actually had to modify the output of
the mark smith library to place 0's before decimal points to avoid bad
request errors.

{
  data: {
appuser_details: {
  name: Tom_iPad,
  email: i...@gmail.com,
  device_type: 2,
  dentist_id: 73,
  device_token:
98be5c7a3cc9e400ae6a90977ac6d64f498bb01cbe83c3c3d1bb4856de59ba1c
}
  }
}

Also doing something like

set the httpHeaders to Content-Type: application/json

could help if you aren't doing this already.

Hmm, I wonder why your back end developer would be looking to use strings
in the place of integers. I


On Tue, Jun 4, 2013 at 6:13 PM, Monte Goulding
mo...@sweattechnologies.comwrote:


 On 05/06/2013, at 8:57 AM, J. Landman Gay wrote:

  I got the same error at first. The web server can't understand what
 you're sending.
 
  You just need to create a regular LiveCode array (none of that
 punctuation stuff,) pass it through Igor's library, and then send a POST
 with whatever you get back. I'm not sure about the headers, I don't think I
 had to change those but it might depend on the server.
 
  Something like this off the top of my head:
 
  put Tom_iPad into tArray[data][appuser_details][name]
  put i...@gmail.com into tArray[data][appuser_details][email]
  ...etc
  put jsonFromArray(tArray) into tJSON
  post tJSON to http://xxx.xxx;
 
  You might have to twiddle that a bit.

 Ah... how is that library working out if something is a number or a
 string? If it's doing it's just using is a number then given you have
 numbers that you need to send as strings you're going to have a problem.
 You might need to look at the api and find out if it has a way to force
 elements to be a string. Alternatively... seeing as it's really not a big
 document and you don't need to do JSONToArray you could just put a template
 in a custom property and use merge...

 Cheers

 --
 M E R Goulding
 Software development services
 Bespoke application development for vertical markets

 mergExt - There's an external for that!

 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode




-- 
Regards,

Andrew Kluthe
and...@ctech.me
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON


On 05/06/2013, at 9:40 AM, Andrew Kluthe wrote:

 Hmm, I wonder why your back end developer would be looking to use strings
 in the place of integers

Well... they look like numbers in the sample data we have but they might not 
always be numbers. It's risky just assuming if an element is a number that it 
should be JSON encoded as a number... LiveCode might not care but the thing on 
the other end more than likely will break if it doesn't get the right type. 
mergJSON does this by allowing you to force elements as strings and also to 
pre-parse the array to ensure things are encoded correctly... things like an 
empty element might be meant to be an empty JSON object or array.

Cheers

--
M E R Goulding 
Software development services
Bespoke application development for vertical markets

mergExt - There's an external for that!

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

Good point. Handy feature. I might have to see if that can replace my
modified mark smith lib in some of my projects. Is mergJSON dual licensed?


On Tue, Jun 4, 2013 at 6:58 PM, Monte Goulding
mo...@sweattechnologies.comwrote:


 On 05/06/2013, at 9:40 AM, Andrew Kluthe wrote:

  Hmm, I wonder why your back end developer would be looking to use strings
  in the place of integers

 Well... they look like numbers in the sample data we have but they might
 not always be numbers. It's risky just assuming if an element is a number
 that it should be JSON encoded as a number... LiveCode might not care but
 the thing on the other end more than likely will break if it doesn't get
 the right type. mergJSON does this by allowing you to force elements as
 strings and also to pre-parse the array to ensure things are encoded
 correctly... things like an empty element might be meant to be an empty
 JSON object or array.

 Cheers

 --
 M E R Goulding
 Software development services
 Bespoke application development for vertical markets

 mergExt - There's an external for that!

 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode




-- 
Regards,

Andrew Kluthe
and...@ctech.me
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON


On 05/06/2013, at 11:08 AM, Andrew Kluthe wrote:

 Good point. Handy feature. I might have to see if that can replace my
 modified mark smith lib in some of my projects. Is mergJSON dual licensed?

That's the intention but as there hasn't been a rush to buy (I did expect that 
given there's LC only options) I haven't added it yet as an option to buy on 
mergExt.com I'm still working out exactly what I should deliver as the 
commercial version... I'm thinking that just the license file naming the 
current version is all that's required. BTW it will be $49 individually and 
also bundled with mergExt.

--
M E R Goulding 
Software development services
Bespoke application development for vertical markets

mergExt - There's an external for that!

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON

Andrew, That did it. I had the headers wrong.

  set the httpHeaders to Content-Type: application/json

worked and not set the httpHeaders to text/json did not.

It actually worked. THanks to everyone who helped me out.

Tom

-- Tom McGrath III
http://lazyriver.on-rev.com
mcgra...@mac.com

On Jun 4, 2013, at 7:40 PM, Andrew Kluthe and...@ctech.me wrote:

 I dont know about the libraries he is using, but if it is based at all on
 the late mark smiths's the numbers in his array would translate to integers
 in terms of the json it spits out. I actually had to modify the output of
 the mark smith library to place 0's before decimal points to avoid bad
 request errors.
 
 {
  data: {
appuser_details: {
  name: Tom_iPad,
  email: i...@gmail.com,
  device_type: 2,
  dentist_id: 73,
  device_token:
 98be5c7a3cc9e400ae6a90977ac6d64f498bb01cbe83c3c3d1bb4856de59ba1c
}
  }
 }
 
 Also doing something like
 
 set the httpHeaders to Content-Type: application/json
 
 could help if you aren't doing this already.
 
 Hmm, I wonder why your back end developer would be looking to use strings
 in the place of integers. I
 
 
 On Tue, Jun 4, 2013 at 6:13 PM, Monte Goulding
 mo...@sweattechnologies.comwrote:
 
 
 On 05/06/2013, at 8:57 AM, J. Landman Gay wrote:
 
 I got the same error at first. The web server can't understand what
 you're sending.
 
 You just need to create a regular LiveCode array (none of that
 punctuation stuff,) pass it through Igor's library, and then send a POST
 with whatever you get back. I'm not sure about the headers, I don't think I
 had to change those but it might depend on the server.
 
 Something like this off the top of my head:
 
 put Tom_iPad into tArray[data][appuser_details][name]
 put i...@gmail.com into tArray[data][appuser_details][email]
 ...etc
 put jsonFromArray(tArray) into tJSON
 post tJSON to http://xxx.xxx;
 
 You might have to twiddle that a bit.
 
 Ah... how is that library working out if something is a number or a
 string? If it's doing it's just using is a number then given you have
 numbers that you need to send as strings you're going to have a problem.
 You might need to look at the api and find out if it has a way to force
 elements to be a string. Alternatively... seeing as it's really not a big
 document and you don't need to do JSONToArray you could just put a template
 in a custom property and use merge...
 
 Cheers
 
 --
 M E R Goulding
 Software development services
 Bespoke application development for vertical markets
 
 mergExt - There's an external for that!
 
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode
 
 
 
 
 -- 
 Regards,
 
 Andrew Kluthe
 and...@ctech.me
 ___
 use-livecode mailing list
 use-livecode@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your subscription 
 preferences:
 http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: JSON