Formatting arrays for use with Beezwax webservices plug-in and Magento

[rufusbiggs]

Hi,

I hope someone can help. We are trying to integrate our Filemaker database with our online Magento store. Magento provide and API and Beezwax have a handy API plug-in for query the API directly from Filemaker functions. Teh problem we are having is in formatting data in such a way as to get the desired result.

For instance, using the command:

Magento_catalogInventoryStockItemList( sessionId; products_* ) as an example,

I can use this with a single product id in the following fashion:

Magento_catalogInventoryStockItemList( $$_SessionID; "9998" )

And this will return valid data

However, the products_* is capable of storing an array of product ID's according to the API guide

http://www.magentocommerce.com/wiki/doc/webservices-api/api/cataloginventory_stock_item#cataloginventory_stock_item.list

You can see they show in the bottom example that it is a nested array required - how do we do this with filemaker?

We have tried all kinds of separators but can only get 1 result returned at a time.

Has anyone else done this or know how to about this?

Many thanks

Rufus