Page 1 of 5

Cant find data in rest service

Posted: Wed Jul 31, 2013 6:11 pm
by abigdreamer

Can't find data in rest service. Please help. I created two 3 simple fields and tried to get data back from http://97.94.152.174:444/cfoxtow_web8... with 465971 My javascriptcommand says (FAILED) after I type in the Dispatch# in the box.


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:14 pm
by Kateryna Grynko

Hi Mike,

Could you please show us your service settings?


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:16 pm
by abigdreamer

Ugh .. my bad .. I had the proxy off (can you put that on by default)

Sorry
it works.


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:36 pm
by abigdreamer

http://97.94.152.174:444/cfoxtow_web8...
Ok
that wasn't the issue.

service settings are
get
json
none
none
use appery.io proxy

465971 is a valid Number.


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:38 pm
by abigdreamer

{
"master":{
"rows":[
{
"aaacallnum":"",
"aaamemtype":"",
"amount":"345",
"area":"",
"billtoact":"COD",
"billtoaddr1":"435 W THORN ST",
"billtoaddr2":"",
"billtocity":"SAN DIEGO",
"billtocont":"",
"billtoname":"LAUREN STONE",
"billtophone":"",
"billtost":"CA",
"billtozip":"92103-",
"bodytype":"2 Door Hatch",
"callactnum":"CPD",
"callactnum2":"CPD",
"callname":"CARLSBAD POLICE DEPARTMENT",
"callphone":"(760)931-2100",
"callremark1":"",
"calltype":"S",
"colorcar":"BLU",
"condition":"TOWABLE",
"cross_street":"",
"custnum":"COD",
"datein":"12/31/11",
"dateout":"01/02/12",
"datepaid":"01/02/12",
"days":"3",
"dispnum":"465971",
"driver":"JIMMY 19",
"equipment":"",
"foxtow_id":"",
"ftiresize":"",
"holdnote":"NO RELEASE NEEDED",
"invdate":"01/02/12",
"invoicenum":"578737",
"itemgroup":"C",
"keysinfo":"N",
"kitnum":"",
"licensenum":"6LFM179",
"licensest":"CA",
"liendin":"/ /",
"liendout":"/ /",
"lienfee":"0",
"lientype":"R",
"lientypems":"",
"makecar":"Honda",
"mapcord":"",
"membernum":"",
"miles":"0",
"milesto":"0",
"modelcar":"Civic",
"odometer":"148303",
"oldinvnum":"",
"paytype":"CRD",
"paytype2":"CRD",
"perday":"45",
"perdaytotal":"135",
"ponumber":"",
"priority":"1",
"referencenum":"4789230001046624 01/14",
"refnumber":"11-07961",
"regaddr1":"3042 BROADWAY",
"regaddr2":"",
"regaddr3":"",
"regcity":"SAN DIEGO",
"regname":"",
"regnametow":"ARTHUR ASHLEY",
"regstate":"CA",
"regzip":"92102",
"releasedate":"/ /",
"releaselic":"E3266266",
"releasetype":"",
"release_bywho":"MARIE",
"release_time":"14:27",
"release_time2":"14:26",
"retowto":"",
"rtiresize":"",
"storagetype":"3",
"tagmonthyear":"05/12",
"timeardst":"23:51",
"timearrive":"23:18",
"timecall":":",
"timeclear":"23:58",
"timeinrt":"23:07",
"timeintow":"23:33",
"timerec":"23:06",
"towdate":"12/31/11",
"towedfrom":"2560 EL CAMINO REAL, CBD [@ VONS",
"towedto":"3199 TYLER STREET, CARLSBAD, CA 92008",
"towtagnum":"",
"trucknum":"21",
"type":"C",
"vin":"2HGEH2359RH516532",
"whocalled":"",
"wposition":"",
"yearcar":"94"
}
]
}
}


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:38 pm
by abigdreamer

This is my Return from the Rest service. It checks out inside tester.


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:41 pm
by abigdreamer

My old settings worked, but I'm trying to use New code that pulls data from ANY database much better and doesn't require me to MAKE the json output string manually which took 5+ hours the last time. This is all function based and much easier.

I can use this method on other tables, any table, or any SQL query and get to where I want to be 100 times faster.


Cant find data in rest service

Posted: Wed Jul 31, 2013 6:55 pm
by Kateryna Grynko

Mike,

Please tell us where you use the code and show us your old and new code. What exactly you did, what do you want to achieve and what is not working?


Cant find data in rest service

Posted: Wed Jul 31, 2013 7:12 pm
by abigdreamer

I want to PULL data from the dispatch number 465971 and populate a form.
Very very simple task at first.
I got it to work when the REST result looked different. But now it doesn't work.

I can't hand code every single REST request.

http://appery.io/app/mobile-frame?src...


Cant find data in rest service

Posted: Wed Jul 31, 2013 7:12 pm
by abigdreamer

The form is called test_test_test