Re: [Dev] [DSS] Changing response format in a data service

2015-05-08 Thread Kasun De Silva 
Thanks guys!

*Kasun de Silva*
Software Engineer | *WSO2 Inc.*; http://wso2.com
lean.enterprise.middleware

email   : kas...@wso2.com
mobile : +94 77 794 4260


On Fri, May 8, 2015 at 7:46 AM, Anjana Fernando anj...@wso2.com wrote:

 Hi,

 +1 for what Madhawa said, if you're sure, you're receiving only one result
 entry, then it is correct.

 Cheers,
 Anjana.

 On Fri, May 8, 2015 at 7:58 AM, Madhawa Gunasekara madha...@wso2.com
 wrote:

 Adding Rajith and Anjana

 On Fri, May 8, 2015 at 7:57 AM, Madhawa Gunasekara madha...@wso2.com
 wrote:

 Hi Kasun,

 Is your stored procedure gives only one contact person every time?
 if it is only one person, then I don't think it will be a bad practice.

 Regards

 On Fri, May 8, 2015 at 1:55 AM, Kasun De Silva kas...@wso2.com wrote:

 Hi Devs,

 Say I have a DSS service as follows,

 data name=EPAGetContactPersonDS serviceNamespace=
 services.info.epa.mydeq.azdeq.gov
 config id=MyDeqAzuriteDS
 property
 name=carbon_datasource_nameMyDeqAzuriteDS/property
 /config
 query id=getContactPerson useConfig=MyDeqAzuriteDS
 sqlcall ARD_MYDEQ_EPAID_SUMMARY_PKG.get_contact_person(?, ?,
 ?, ?, ?, ?)/sql
 result defaultNamespace=http://mydeq.azdeq.gov/epa/info/data;
 element=contact_person_info rowName=contact_person
 element column=CUS_IDNO name=cus_idno
 xsdType=xs:string optional=true/
 element column=CUSNAM_IDNO name=cusnam_idno
 xsdType=xs:string optional=true/
 element column=PLCNAM_IDNO name=plcnam_idno
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE1 name=address1
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE2 name=address2
 xsdType=xs:string optional=true/
 element column=CITY name=city xsdType=xs:string
 optional=true/
 element column=STATE name=state xsdType=xs:string
 optional=true/
 element column=COUNTRY_CODE name=country
 xsdType=xs:string optional=true/
 element column=POSTAL_CODE name=zip
 xsdType=xs:string optional=true/
 element column=PLUS4 name=plus4 xsdType=xs:string
 optional=true/
 element column=START_DATE name=start_date
 xsdType=xs:string optional=true/
 element column=CUS_EMAIL name=email
 xsdType=xs:string optional=true/
 element column=CATEGORY name=category
 xsdType=xs:string optional=true/
 element column=LAST_NAME name=last_name
 xsdType=xs:string optional=true/
 element column=FIRST_NAME name=first_name
 xsdType=xs:string optional=true/
 element column=MIDDLE_I name=middle_initial
 xsdType=xs:string optional=true/
 element column=PREFIX name=prefix xsdType=xs:string
 optional=true/
 element column=SUFFIX name=suffix xsdType=xs:string
 optional=true/
 element column=KNOWN_AS name=known_as
 xsdType=xs:string optional=true/
 element column=TITLE name=title xsdType=xs:string
 optional=true/
 element column=COMPANY_NAME name=company_name
 xsdType=xs:string optional=true/
 element column=AREA_CODE name=phone_area_code
 xsdType=xs:string optional=true/
 element column=PHONE name=phone_number
 xsdType=xs:string optional=true/
 element column=EXT name=phone_ext xsdType=xs:string
 optional=true/
 element column=PHONE_TYPE name=phone_type
 xsdType=xs:string optional=true/
 /result
 param name=p_place_idno sqlType=INTEGER/
 param name=p_cus_idno sqlType=INTEGER/
 param name=p_epaid sqlType=STRING/
 param name=p_contact sqlType=ORACLE_REF_CURSOR type=OUT/
 param name=p_err_code sqlType=STRING type=OUT/
 param name=p_err_msg sqlType=STRING type=OUT/
 /query
 resource method=GET
 path=getContactPerson/{p_place_idno}/{p_cus_idno}/{p_epaid}
 call-query href=getContactPerson
 with-param name=p_place_idno query-param=p_place_idno/
 with-param name=p_cus_idno query-param=p_cus_idno/
 with-param name=p_epaid query-param=p_epaid/
 /call-query
 /resource
 /data


 From this service I get a response as below,

 {
 contact_person_info: {
 contact_person: [
 {
 cus_idno: #,
 cusnam_idno: #,
 plcnam_idno: ##,
 address1: ,
 address2: #,
 city: #,
 state: ##,
 country: ,
 zip: ,
 plus4: ,
 start_date: ###,
 email: ,
 category: ,
 last_name: ,
 first_name:  ,
 middle_initial: ###,
 prefix: ,
 suffix: ,
 known_as: ,
 title: ,

Re: [Dev] [DSS] Changing response format in a data service

2015-05-08 Thread Anjana Fernando 
Hi,

+1 for what Madhawa said, if you're sure, you're receiving only one result
entry, then it is correct.

Cheers,
Anjana.

On Fri, May 8, 2015 at 7:58 AM, Madhawa Gunasekara madha...@wso2.com
wrote:

 Adding Rajith and Anjana

 On Fri, May 8, 2015 at 7:57 AM, Madhawa Gunasekara madha...@wso2.com
 wrote:

 Hi Kasun,

 Is your stored procedure gives only one contact person every time?
 if it is only one person, then I don't think it will be a bad practice.

 Regards

 On Fri, May 8, 2015 at 1:55 AM, Kasun De Silva kas...@wso2.com wrote:

 Hi Devs,

 Say I have a DSS service as follows,

 data name=EPAGetContactPersonDS serviceNamespace=
 services.info.epa.mydeq.azdeq.gov
 config id=MyDeqAzuriteDS
 property name=carbon_datasource_nameMyDeqAzuriteDS/property
 /config
 query id=getContactPerson useConfig=MyDeqAzuriteDS
 sqlcall ARD_MYDEQ_EPAID_SUMMARY_PKG.get_contact_person(?, ?,
 ?, ?, ?, ?)/sql
 result defaultNamespace=http://mydeq.azdeq.gov/epa/info/data;
 element=contact_person_info rowName=contact_person
 element column=CUS_IDNO name=cus_idno
 xsdType=xs:string optional=true/
 element column=CUSNAM_IDNO name=cusnam_idno
 xsdType=xs:string optional=true/
 element column=PLCNAM_IDNO name=plcnam_idno
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE1 name=address1
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE2 name=address2
 xsdType=xs:string optional=true/
 element column=CITY name=city xsdType=xs:string
 optional=true/
 element column=STATE name=state xsdType=xs:string
 optional=true/
 element column=COUNTRY_CODE name=country
 xsdType=xs:string optional=true/
 element column=POSTAL_CODE name=zip xsdType=xs:string
 optional=true/
 element column=PLUS4 name=plus4 xsdType=xs:string
 optional=true/
 element column=START_DATE name=start_date
 xsdType=xs:string optional=true/
 element column=CUS_EMAIL name=email xsdType=xs:string
 optional=true/
 element column=CATEGORY name=category
 xsdType=xs:string optional=true/
 element column=LAST_NAME name=last_name
 xsdType=xs:string optional=true/
 element column=FIRST_NAME name=first_name
 xsdType=xs:string optional=true/
 element column=MIDDLE_I name=middle_initial
 xsdType=xs:string optional=true/
 element column=PREFIX name=prefix xsdType=xs:string
 optional=true/
 element column=SUFFIX name=suffix xsdType=xs:string
 optional=true/
 element column=KNOWN_AS name=known_as
 xsdType=xs:string optional=true/
 element column=TITLE name=title xsdType=xs:string
 optional=true/
 element column=COMPANY_NAME name=company_name
 xsdType=xs:string optional=true/
 element column=AREA_CODE name=phone_area_code
 xsdType=xs:string optional=true/
 element column=PHONE name=phone_number
 xsdType=xs:string optional=true/
 element column=EXT name=phone_ext xsdType=xs:string
 optional=true/
 element column=PHONE_TYPE name=phone_type
 xsdType=xs:string optional=true/
 /result
 param name=p_place_idno sqlType=INTEGER/
 param name=p_cus_idno sqlType=INTEGER/
 param name=p_epaid sqlType=STRING/
 param name=p_contact sqlType=ORACLE_REF_CURSOR type=OUT/
 param name=p_err_code sqlType=STRING type=OUT/
 param name=p_err_msg sqlType=STRING type=OUT/
 /query
 resource method=GET
 path=getContactPerson/{p_place_idno}/{p_cus_idno}/{p_epaid}
 call-query href=getContactPerson
 with-param name=p_place_idno query-param=p_place_idno/
 with-param name=p_cus_idno query-param=p_cus_idno/
 with-param name=p_epaid query-param=p_epaid/
 /call-query
 /resource
 /data


 From this service I get a response as below,

 {
 contact_person_info: {
 contact_person: [
 {
 cus_idno: #,
 cusnam_idno: #,
 plcnam_idno: ##,
 address1: ,
 address2: #,
 city: #,
 state: ##,
 country: ,
 zip: ,
 plus4: ,
 start_date: ###,
 email: ,
 category: ,
 last_name: ,
 first_name:  ,
 middle_initial: ###,
 prefix: ,
 suffix: ,
 known_as: ,
 title: ,
 company_name: ,
 phone_area_code: #,
 phone_number: ,
 phone_ext: ,
 phone_type: #
 }
 ]
 }
 }


 But In my use case I want the the following

Re: [Dev] [DSS] Changing response format in a data service

2015-05-07 Thread Madhawa Gunasekara 
Adding Rajith and Anjana

On Fri, May 8, 2015 at 7:57 AM, Madhawa Gunasekara madha...@wso2.com
wrote:

 Hi Kasun,

 Is your stored procedure gives only one contact person every time?
 if it is only one person, then I don't think it will be a bad practice.

 Regards

 On Fri, May 8, 2015 at 1:55 AM, Kasun De Silva kas...@wso2.com wrote:

 Hi Devs,

 Say I have a DSS service as follows,

 data name=EPAGetContactPersonDS serviceNamespace=
 services.info.epa.mydeq.azdeq.gov
 config id=MyDeqAzuriteDS
 property name=carbon_datasource_nameMyDeqAzuriteDS/property
 /config
 query id=getContactPerson useConfig=MyDeqAzuriteDS
 sqlcall ARD_MYDEQ_EPAID_SUMMARY_PKG.get_contact_person(?, ?, ?,
 ?, ?, ?)/sql
 result defaultNamespace=http://mydeq.azdeq.gov/epa/info/data;
 element=contact_person_info rowName=contact_person
 element column=CUS_IDNO name=cus_idno
 xsdType=xs:string optional=true/
 element column=CUSNAM_IDNO name=cusnam_idno
 xsdType=xs:string optional=true/
 element column=PLCNAM_IDNO name=plcnam_idno
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE1 name=address1
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE2 name=address2
 xsdType=xs:string optional=true/
 element column=CITY name=city xsdType=xs:string
 optional=true/
 element column=STATE name=state xsdType=xs:string
 optional=true/
 element column=COUNTRY_CODE name=country
 xsdType=xs:string optional=true/
 element column=POSTAL_CODE name=zip xsdType=xs:string
 optional=true/
 element column=PLUS4 name=plus4 xsdType=xs:string
 optional=true/
 element column=START_DATE name=start_date
 xsdType=xs:string optional=true/
 element column=CUS_EMAIL name=email xsdType=xs:string
 optional=true/
 element column=CATEGORY name=category
 xsdType=xs:string optional=true/
 element column=LAST_NAME name=last_name
 xsdType=xs:string optional=true/
 element column=FIRST_NAME name=first_name
 xsdType=xs:string optional=true/
 element column=MIDDLE_I name=middle_initial
 xsdType=xs:string optional=true/
 element column=PREFIX name=prefix xsdType=xs:string
 optional=true/
 element column=SUFFIX name=suffix xsdType=xs:string
 optional=true/
 element column=KNOWN_AS name=known_as
 xsdType=xs:string optional=true/
 element column=TITLE name=title xsdType=xs:string
 optional=true/
 element column=COMPANY_NAME name=company_name
 xsdType=xs:string optional=true/
 element column=AREA_CODE name=phone_area_code
 xsdType=xs:string optional=true/
 element column=PHONE name=phone_number
 xsdType=xs:string optional=true/
 element column=EXT name=phone_ext xsdType=xs:string
 optional=true/
 element column=PHONE_TYPE name=phone_type
 xsdType=xs:string optional=true/
 /result
 param name=p_place_idno sqlType=INTEGER/
 param name=p_cus_idno sqlType=INTEGER/
 param name=p_epaid sqlType=STRING/
 param name=p_contact sqlType=ORACLE_REF_CURSOR type=OUT/
 param name=p_err_code sqlType=STRING type=OUT/
 param name=p_err_msg sqlType=STRING type=OUT/
 /query
 resource method=GET
 path=getContactPerson/{p_place_idno}/{p_cus_idno}/{p_epaid}
 call-query href=getContactPerson
 with-param name=p_place_idno query-param=p_place_idno/
 with-param name=p_cus_idno query-param=p_cus_idno/
 with-param name=p_epaid query-param=p_epaid/
 /call-query
 /resource
 /data


 From this service I get a response as below,

 {
 contact_person_info: {
 contact_person: [
 {
 cus_idno: #,
 cusnam_idno: #,
 plcnam_idno: ##,
 address1: ,
 address2: #,
 city: #,
 state: ##,
 country: ,
 zip: ,
 plus4: ,
 start_date: ###,
 email: ,
 category: ,
 last_name: ,
 first_name:  ,
 middle_initial: ###,
 prefix: ,
 suffix: ,
 known_as: ,
 title: ,
 company_name: ,
 phone_area_code: #,
 phone_number: ,
 phone_ext: ,
 phone_type: #
 }
 ]
 }
 }


 But In my use case I want the the following response instead of the above.

 {
 contact_person: {
 cus_idno: #,
 cusnam_idno: #,
 plcnam_idno: ##,
 address1:

Re: [Dev] [DSS] Changing response format in a data service

2015-05-07 Thread Madhawa Gunasekara 
Hi Kasun,

Is your stored procedure gives only one contact person every time?
if it is only one person, then I don't think it will be a bad practice.

Regards

On Fri, May 8, 2015 at 1:55 AM, Kasun De Silva kas...@wso2.com wrote:

 Hi Devs,

 Say I have a DSS service as follows,

 data name=EPAGetContactPersonDS serviceNamespace=
 services.info.epa.mydeq.azdeq.gov
 config id=MyDeqAzuriteDS
 property name=carbon_datasource_nameMyDeqAzuriteDS/property
 /config
 query id=getContactPerson useConfig=MyDeqAzuriteDS
 sqlcall ARD_MYDEQ_EPAID_SUMMARY_PKG.get_contact_person(?, ?, ?,
 ?, ?, ?)/sql
 result defaultNamespace=http://mydeq.azdeq.gov/epa/info/data;
 element=contact_person_info rowName=contact_person
 element column=CUS_IDNO name=cus_idno xsdType=xs:string
 optional=true/
 element column=CUSNAM_IDNO name=cusnam_idno
 xsdType=xs:string optional=true/
 element column=PLCNAM_IDNO name=plcnam_idno
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE1 name=address1
 xsdType=xs:string optional=true/
 element column=ADDRESS_LINE2 name=address2
 xsdType=xs:string optional=true/
 element column=CITY name=city xsdType=xs:string
 optional=true/
 element column=STATE name=state xsdType=xs:string
 optional=true/
 element column=COUNTRY_CODE name=country
 xsdType=xs:string optional=true/
 element column=POSTAL_CODE name=zip xsdType=xs:string
 optional=true/
 element column=PLUS4 name=plus4 xsdType=xs:string
 optional=true/
 element column=START_DATE name=start_date
 xsdType=xs:string optional=true/
 element column=CUS_EMAIL name=email xsdType=xs:string
 optional=true/
 element column=CATEGORY name=category xsdType=xs:string
 optional=true/
 element column=LAST_NAME name=last_name
 xsdType=xs:string optional=true/
 element column=FIRST_NAME name=first_name
 xsdType=xs:string optional=true/
 element column=MIDDLE_I name=middle_initial
 xsdType=xs:string optional=true/
 element column=PREFIX name=prefix xsdType=xs:string
 optional=true/
 element column=SUFFIX name=suffix xsdType=xs:string
 optional=true/
 element column=KNOWN_AS name=known_as xsdType=xs:string
 optional=true/
 element column=TITLE name=title xsdType=xs:string
 optional=true/
 element column=COMPANY_NAME name=company_name
 xsdType=xs:string optional=true/
 element column=AREA_CODE name=phone_area_code
 xsdType=xs:string optional=true/
 element column=PHONE name=phone_number
 xsdType=xs:string optional=true/
 element column=EXT name=phone_ext xsdType=xs:string
 optional=true/
 element column=PHONE_TYPE name=phone_type
 xsdType=xs:string optional=true/
 /result
 param name=p_place_idno sqlType=INTEGER/
 param name=p_cus_idno sqlType=INTEGER/
 param name=p_epaid sqlType=STRING/
 param name=p_contact sqlType=ORACLE_REF_CURSOR type=OUT/
 param name=p_err_code sqlType=STRING type=OUT/
 param name=p_err_msg sqlType=STRING type=OUT/
 /query
 resource method=GET
 path=getContactPerson/{p_place_idno}/{p_cus_idno}/{p_epaid}
 call-query href=getContactPerson
 with-param name=p_place_idno query-param=p_place_idno/
 with-param name=p_cus_idno query-param=p_cus_idno/
 with-param name=p_epaid query-param=p_epaid/
 /call-query
 /resource
 /data


 From this service I get a response as below,

 {
 contact_person_info: {
 contact_person: [
 {
 cus_idno: #,
 cusnam_idno: #,
 plcnam_idno: ##,
 address1: ,
 address2: #,
 city: #,
 state: ##,
 country: ,
 zip: ,
 plus4: ,
 start_date: ###,
 email: ,
 category: ,
 last_name: ,
 first_name:  ,
 middle_initial: ###,
 prefix: ,
 suffix: ,
 known_as: ,
 title: ,
 company_name: ,
 phone_area_code: #,
 phone_number: ,
 phone_ext: ,
 phone_type: #
 }
 ]
 }
 }


 But In my use case I want the the following response instead of the above.

 {
 contact_person: {
 cus_idno: #,
 cusnam_idno: #,
 plcnam_idno: ##,
 address1: ,
 address2: #,
 city: #,

[Dev] [DSS] Changing response format in a data service

2015-05-07 Thread Kasun De Silva 
Hi Devs,

Say I have a DSS service as follows,

data name=EPAGetContactPersonDS serviceNamespace=
services.info.epa.mydeq.azdeq.gov
config id=MyDeqAzuriteDS
property name=carbon_datasource_nameMyDeqAzuriteDS/property
/config
query id=getContactPerson useConfig=MyDeqAzuriteDS
sqlcall ARD_MYDEQ_EPAID_SUMMARY_PKG.get_contact_person(?, ?, ?,
?, ?, ?)/sql
result defaultNamespace=http://mydeq.azdeq.gov/epa/info/data;
element=contact_person_info rowName=contact_person
element column=CUS_IDNO name=cus_idno xsdType=xs:string
optional=true/
element column=CUSNAM_IDNO name=cusnam_idno
xsdType=xs:string optional=true/
element column=PLCNAM_IDNO name=plcnam_idno
xsdType=xs:string optional=true/
element column=ADDRESS_LINE1 name=address1
xsdType=xs:string optional=true/
element column=ADDRESS_LINE2 name=address2
xsdType=xs:string optional=true/
element column=CITY name=city xsdType=xs:string
optional=true/
element column=STATE name=state xsdType=xs:string
optional=true/
element column=COUNTRY_CODE name=country
xsdType=xs:string optional=true/
element column=POSTAL_CODE name=zip xsdType=xs:string
optional=true/
element column=PLUS4 name=plus4 xsdType=xs:string
optional=true/
element column=START_DATE name=start_date
xsdType=xs:string optional=true/
element column=CUS_EMAIL name=email xsdType=xs:string
optional=true/
element column=CATEGORY name=category xsdType=xs:string
optional=true/
element column=LAST_NAME name=last_name
xsdType=xs:string optional=true/
element column=FIRST_NAME name=first_name
xsdType=xs:string optional=true/
element column=MIDDLE_I name=middle_initial
xsdType=xs:string optional=true/
element column=PREFIX name=prefix xsdType=xs:string
optional=true/
element column=SUFFIX name=suffix xsdType=xs:string
optional=true/
element column=KNOWN_AS name=known_as xsdType=xs:string
optional=true/
element column=TITLE name=title xsdType=xs:string
optional=true/
element column=COMPANY_NAME name=company_name
xsdType=xs:string optional=true/
element column=AREA_CODE name=phone_area_code
xsdType=xs:string optional=true/
element column=PHONE name=phone_number xsdType=xs:string
optional=true/
element column=EXT name=phone_ext xsdType=xs:string
optional=true/
element column=PHONE_TYPE name=phone_type
xsdType=xs:string optional=true/
/result
param name=p_place_idno sqlType=INTEGER/
param name=p_cus_idno sqlType=INTEGER/
param name=p_epaid sqlType=STRING/
param name=p_contact sqlType=ORACLE_REF_CURSOR type=OUT/
param name=p_err_code sqlType=STRING type=OUT/
param name=p_err_msg sqlType=STRING type=OUT/
/query
resource method=GET
path=getContactPerson/{p_place_idno}/{p_cus_idno}/{p_epaid}
call-query href=getContactPerson
with-param name=p_place_idno query-param=p_place_idno/
with-param name=p_cus_idno query-param=p_cus_idno/
with-param name=p_epaid query-param=p_epaid/
/call-query
/resource
/data


From this service I get a response as below,

{
contact_person_info: {
contact_person: [
{
cus_idno: #,
cusnam_idno: #,
plcnam_idno: ##,
address1: ,
address2: #,
city: #,
state: ##,
country: ,
zip: ,
plus4: ,
start_date: ###,
email: ,
category: ,
last_name: ,
first_name:  ,
middle_initial: ###,
prefix: ,
suffix: ,
known_as: ,
title: ,
company_name: ,
phone_area_code: #,
phone_number: ,
phone_ext: ,
phone_type: #
}
]
}
}


But In my use case I want the the following response instead of the above.

{
contact_person: {
cus_idno: #,
cusnam_idno: #,
plcnam_idno: ##,
address1: ,
address2: #,
city: #,
state: ##,
country: ,
zip: ,
plus4: ,
start_date: ###,
email: ,
category: ,
last_name: ,
first_name:  ,
middle_initial: ###,
prefix: ,