Struggling with Fusion table response data

[hallworthdesign]

I'm struggling to work with the response data and mapping it to labels.
I don't know how to get the service response to pick up the data in the array and show it in different places. I just get all the data shown in one place.

I have set up a REST service to pull data from a Fusion table.
The test request works and returns data fine.

Data response is like this
code
{
"kind": "fusiontables#sqlresponse",
"columns": [
"rowid",
"name",
"description"
],
"rows": [
[
"1001",
"Harlequin Vintage",
"My desc"
],
[
"1002",
"Wolf & Gypsy Vintage",
""
],
[
"1003",
"Artifice Vintage Furniture & Interiors",
""
]
]
}
/code

I clicked 'Automatically Create Service Response' to set the response parameters like below

I map the service to the list components labels

Which shows this

I want to split the response data and show them under different labels.
All I get is
I've worked through the tutorials but can;t spot a similar scenario to work from.

Help!

[Maryna Brodina]

Hello!

As this is array, you can't map each value to a separate element. But you can add Grid with one label and do mapping, see the screenshot.

Another way is to fill in Label value with JS.

[hallworthdesign]

thanks for your reply Maryna, I've tried that but it just seems too give me the same result as when using the list item with labels or am I missing something?

[Maryna Brodina]

Please look at the screenshot I posted and do exactly the same mapping.

[hallworthdesign]

Apologies - I didn't put the grid in a list item and map it properly. I now have my data appearing as separate items - repeating the label for each item.

I don't want to show rowid in a label but as I've requested it in the select statement, it's being displayed. How can I intercept the data response values in javascript so I can format it? Sorry to be a dunce, but I'm trying to understand how this all fits together

[Nikita]

Hello,

You can handle data on mapping with adding JS:
http://docs.appery.io/documentation/r...

[hallworthdesign]

Ok thanks Nikita, I hadn't found that page previously

[hallworthdesign]

Finally got this working after 3 days bashing of head.
Hope this helps someone.

I have a single mobileListItem that contains 3 labels.
Labels are populated with data returned from fusion service response.

Here's the response mapping - javascript populates the 3 labels using the 'value' array it is passed.

Javascript is this
code
$('[dsid=rowid]', element).text(value[0]);
$('[dsid=placeName]', element).text(value[1]);
$('[dsid=placeDescription]', element).text(value[2]);
/code

[Maryna Brodina]

Thank you for sharing!