Hi Shakila, Thank you very much. It worked without any exceptions for 500 rows.
Thanks again, Riyafa On Tue, Dec 8, 2015 at 9:09 PM, Shakila Sivagnanarajah <[email protected]> wrote: > Hi Riyafa, > > This may be caused because of too many requests or due to network issue. > Some of the rows are not updated and that calls return 429 unknown status > code. The number of failing calls also change time to time. So try with > thread sleep in script mediator like [1]. > > [1] <script language="js"> java.lang.Thread.sleep(<INTERVAL>);</script> > > Thank you > > On Tue, Dec 8, 2015 at 8:52 PM, Shakila Sivagnanarajah <[email protected]> > wrote: > >> Hi Riyafa, >> >> This may be caused because of too many requests or due to network issue. >> I attach the result here. Some of the rows are not updated and that calls >> return 429 unknown status code. The number of failing calls also change >> time to time. So try with thread sleep in script mediator like [1]. >> >> [1] <script language="js"> java.lang.Thread.sleep(5000);</script> >> >> Thank you >> >> On Tue, Dec 8, 2015 at 10:46 AM, Riyafa Abdul Hameed <[email protected]> >> wrote: >> >>> Hi Elilmatha, >>> >>> It is working without any exceptions for upto 300 rows. >>> >>> Thanks >>> >>> On Tue, Dec 8, 2015 at 10:44 AM, Elilmatha Sivanesan <[email protected] >>> > wrote: >>> >>>> Hi Riyafa , >>>> >>>> As per the error here you are missing an end tag. >>>> >>>> org.apache.axiom.om.OMException: >>>> com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character 'I' >>>> (code 73) in prolog; expected '<' >>>> >>>> >>>> Thanks. >>>> >>>> >>>> On Tue, Dec 8, 2015 at 10:27 AM, Riyafa Abdul Hameed <[email protected]> >>>> wrote: >>>> >>>>> [+ Thulasika] >>>>> >>>>> On Tue, Dec 8, 2015 at 10:26 AM, Riyafa Abdul Hameed <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> To be more generic I have created a proxy which fetches a column (the >>>>>> column shouldn't be empty) and updates the same column in an iteration. >>>>>> The two exceptions [1] are thrown when updating more than 500 rows. The >>>>>> proxy service is attached with this mail. >>>>>> >>>>>> A sample spreadsheet is at [2] and a sample call is as given below: >>>>>> >>>>>> { >>>>>> >>>>>> "accesstoken":"ya29.RAK1F3bpXOp1TxuTg7N96CPFj5d4O1p5dyTCudfXmRTSz7UWK2OzTXmbZ2-_IBfuctb-", >>>>>> "key":"1HI9u5PuNxURVapBPSbj_aI_eM3C5NU6p8ftTyHdHW-g", >>>>>> "workSheetId":"1", >>>>>> "startRowNum":"1", >>>>>> "numRows":"500", >>>>>> "RetrievecolNum":"1" >>>>>> } >>>>>> >>>>>> >>>>>> [1] >>>>>> https://docs.google.com/document/d/1z37FzNjo2WHlHZHDyBoMR8zP1_w_WA_qJwz4O3AxEGk/edit >>>>>> [2] >>>>>> https://docs.google.com/spreadsheets/d/1HI9u5PuNxURVapBPSbj_aI_eM3C5NU6p8ftTyHdHW-g/edit#gid=0 >>>>>> >>>>>> -- >>>>>> Riyafa Abdul Hameed >>>>>> Software Engineering intern, WSO2 >>>>>> >>>>>> Email: [email protected] >>>>>> Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> >>>>>> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> >>>>>> <http://twitter.com/Riyafa1> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Riyafa Abdul Hameed >>>>> Software Engineering intern, WSO2 >>>>> >>>>> Email: [email protected] >>>>> Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> >>>>> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> >>>>> <http://twitter.com/Riyafa1> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> *S.Elilmatha* >>>> Associate Software Engineer, >>>> >>>> WSO2 Inc.; http://wso2.com >>>> lean.enterprise.middleware >>>> >>>> Mobile 0779842221. >>>> >>>> >>> >>> >>> -- >>> Riyafa Abdul Hameed >>> Software Engineering intern, WSO2 >>> >>> Email: [email protected] >>> Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> >>> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> >>> <http://twitter.com/Riyafa1> >>> >> >> >> >> -- >> Shakila Sivagnanarajah >> Associate Software Engineer >> Mobile :+94 (0) 768 856837 >> [email protected] >> > > > > -- > Shakila Sivagnanarajah > Associate Software Engineer > Mobile :+94 (0) 768 856837 > [email protected] > -- Riyafa Abdul Hameed Software Engineering intern, WSO2 Email: [email protected] Website: https://riyafa.wordpress.com/ <http://riyafa.wordpress.com/> <http://facebook.com/riyafa.ahf> <http://lk.linkedin.com/in/riyafa> <http://twitter.com/Riyafa1>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
