Catch up wih the Appery.io community on our forum. Here you'll find information on the lastest questions and issues Appery.io developers are discussing.
https://forum.appery.io/
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.
Hi Mike,
Could you please show us your service settings?
Ugh .. my bad .. I had the proxy off (can you put that on by default)
Sorry
it works.
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.
{
"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"
}
]
}
}
This is my Return from the Rest service. It checks out inside tester.
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.
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?
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.
The form is called test_test_test