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_name">MyDeqAzuriteDS</property> >>>> </config> >>>> <query id="getContactPerson" useConfig="MyDeqAzuriteDS"> >>>> <sql>call 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": ####, >>>> "suffix": ####, >>>> "known_as": ####, >>>> "title": ####, >>>> "company_name": ####, >>>> "phone_area_code": "#####", >>>> "phone_number": "####", >>>> "phone_ext": "####", >>>> "phone_type": "#####" >>>> } >>>> } >>>> >>>> New response doesn't has "contact_person_info" element and simple >>>> change in the JSON format in the response. >>>> >>>> I was able to generate the response as I wanted by changing the result >>>> tag as following, >>>> >>>> <result defaultNamespace="http://mydeq.azdeq.gov/epa/info/data" >>>> element="contact_person_info" >>>> rowName="contact_person"> >>>> >>>> to >>>> >>>> <result defaultNamespace="http://mydeq.azdeq.gov/epa/info/data" >>>> element="contact_person"> >>>> >>>> >>>> >>>> I just wanted to check whether this is a good practice from DSS >>>> perspective as in not having a rowName, and whether this could cause any >>>> issues, Any thoughts ? >>>> >>>> >>>> Thanks, >>>> Kasun >>>> >>>> *Kasun de Silva* >>>> Software Engineer | *WSO2 Inc.*; http://wso2.com >>>> lean.enterprise.middleware >>>> >>>> email : kas...@wso2.com >>>> mobile : +94 77 794 4260 >>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> Dev@wso2.org >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> *Madhawa Gunasekara* >>> Software Engineer >>> WSO2 Inc.; http://wso2.com >>> lean.enterprise.middleware >>> >>> mobile: +94 719411002 <+94+719411002> >>> blog: *http://madhawa-gunasekara.blogspot.com >>> <http://madhawa-gunasekara.blogspot.com>* >>> linkedin: *http://lk.linkedin.com/in/mgunasekara >>> <http://lk.linkedin.com/in/mgunasekara>* >>> >> >> >> >> -- >> *Madhawa Gunasekara* >> Software Engineer >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> mobile: +94 719411002 <+94+719411002> >> blog: *http://madhawa-gunasekara.blogspot.com >> <http://madhawa-gunasekara.blogspot.com>* >> linkedin: *http://lk.linkedin.com/in/mgunasekara >> <http://lk.linkedin.com/in/mgunasekara>* >> > > > > -- > *Anjana Fernando* > Senior Technical Lead > WSO2 Inc. | http://wso2.com > lean . enterprise . middleware >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev