This discussion is archived
0 Replies Latest reply: Dec 17, 2012 7:10 AM by 912156 RSS

RESTFul webservice does not return all fields defined in query

912156 Newbie
Currently Being Moderated
Hello,

I get a restful webservice defined and it return results when I click test button. But in the result returned, it only has two fields but not all fields I defined. Someone asked to post it in apex listener instead apex forum.

Any Ideas?

Version: 4.2
query:
select service_overview_his_id,
a.service_id, b.service_name,
cyear || '-' || cmonth month,
enviorment,
num,
availability_percent,
total_gb,
used_gb,
create_user_id,
create_time
from dbmon_service_overview_his a inner join dbmon_service_avil b on(a.service_id = b.service_id)
where (cyear || '-' || cmonth) = :c_month

test result:
{"next":{"$ref":"http://xxxx:7777/apex/dbmonitor/dba/report/overviewdba/report/overview/2012-11?page=1"},"items":[{"service_overview_his_id":19,"service_id":1},{"service_overview_his_id":20,"service_id":1},{"service_overview_his_id":21,"service_id":2},{"service_overview_his_id":22,"service_id":2},{"service_overview_his_id":23,"service_id":3}]}

Thanks,

Robin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points