Best approach? | Corona SDK + Drupal CMS

I’m looking for input, advice and previous experience in regards to pulling/pushing data backwards and forwards to PHP scripts and what the best approach might be.

I need to be able to perform the following tasks on a CMS through a Corona SDK UI: Login, Pull content, Create content. More specifically I’m looking to interface Corona SDK with Drupal. I’ve done a lot of work in the past using Drupal’s Services modules in unison with Flash (AMFPHP).

My first thoughts are to use JSON: Make calls to urls from Corona SDK with variables appended, do most of the leg work in custom PHP code and then return JSON formatted data back.

Alternatively what about using SOAP, or XMLRPC?

All input welcome and will be most appreciated.

Thanks in advance,

Ash [import]uid: 21125 topic_id: 20145 reply_id: 320145[/import]

I think staying with JSON will be the easiest. It matches Lua tables the best. While we have a few XML parsers, its not supported directly by Ansca and they are harder to work with.

As far as Drupal goes, as long as you can get it to produce JSON for your output you should be okay. Input can all be done with HTTP GET requests so you should be able to submit any form.
[import]uid: 19626 topic_id: 20145 reply_id: 78714[/import]

Phew, thanks for that @robmiracle. This confirms what I was airing towards.

However, any further links/suggestions are very much welcome.
[import]uid: 21125 topic_id: 20145 reply_id: 78737[/import]

@fixdit: how did you do it finally? I have to build an corona app that gets data from a cms/database. the client wants to manage the content with a cms.

thanks for sharing! [import]uid: 90610 topic_id: 20145 reply_id: 103053[/import]

What an interesting concept! I didnt even think of using Corona in this manner. Hmz. I am interested in knowing if you got it to work as well. [import]uid: 143556 topic_id: 20145 reply_id: 103056[/import]

Sorry Peach My finger must have stuttered. I didnt mean to double post. [import]uid: 143556 topic_id: 20145 reply_id: 103057[/import]