Populate a sublist from a list item

[keith weaver]

I am pulling data from salesforce. I have a list of records - when I click on one of the records I want to pull child items (attachments) and populate another list. I have followed a tutorial and I am using the id of the parent record and saving it to a variable. I then invoke a service that queries the child record and passes the variable of the parent Id but I must be missing something. Please see the attached screen shots of the mapping. What am I missing.

[Yurii Orishchuk]

Hi Keith,

You need:

1. Store parend id inside invisible list item label component.

2. On item click - get value from this invisible label component and use this value in the quest on child items.

   Please read more about this approach here:

   http://devcenter.appery.io/tutorials/...

   Regards.

[keith weaver]

Yurii Thanks! I am doing that but I am unclear how to query the Salesforce data but "filter" it for only those that = parent id. I tried the solution found here: https://getsatisfaction.com/apperyio/... but It is returning errors. See the screen shots.

[Yurii Orishchuk]

Hi Keith,

Please give us more information about this request..

We need to see headers, request parameters, full response etc..

Regards.

[keith weaver]

Yurii

I have pasted the cURL below I think all the info you need should be in that.

curl "https://api.appery.io/rest/1/proxy/tu..." -H "Host: api.appery.io" -H "User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0" -H "Accept: application/json, text/javascript, /; q=0.01" -H "Accept-Language: en-US,en;q=0.5" --compressed -H "Authorization: Bearer 00Do0000000ZyyJ!AQYAQOOEE4Kgc06rzfz39clRPGDpWUBDTSeSCwznRN72h8twhdSpDL5_lHaj0G1JFTyNwu32Jno7T9lPAqIi_inEL2hE1gEO" -H "appery-proxy-url: https://na17.salesforce.com/services/..." -H "appery-transformation: checkTunnel" -H "appery-key: 1420504568998" -H "appery-rest: ed546ec8-5aa7-4e6d-994a-2497b14ed43d" -H "Referer: http://appery.io/app/view/07f60b88-6c..." -H "Origin: http://appery.io" -H "Connection: keep-alive"

This is my java script on the request: return "SELECT Id, Name, ParentId, Body, Description, OwnerId, ContentType FROM Attachment WHERE ParentId like '%" + value + "%'";

Let me know if you need more info

[Yurii Orishchuk]

Hi Keith,

I can not see payload in your request..

Please give us your app public link and describe how we can reproduce this problem in your app.

Regards.