abigdreamer
Posts: 0
Joined: Fri Jul 12, 2013 7:20 pm

ActiveVfP rest JSON integration Visual FoxPro prg

Ok -- Now we are doing Live stuff -- (the real deal) and its still testing of course but I'm trying real data.

This is how my data looks right now. Appery.io doesn't like my data.

http://97.94.152.174:444/cfoxtow_web8...

465971 is a good Dispatch#
and this is what my program is giving me back.

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

IT does not find the record. I am trying other things. But I'm just saying.

{
"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_a":"CPD",
"callactnum_b":"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":"0000-00-00T00:00:00-08:00",
"liendout":"0000-00-00T00:00:00-08:00",
"lienfee":"0",
"lientype":"R",
"lientypems":"",
"makecar":"Honda",
"mapcord":"",
"membernum":"",
"miles":"0",
"milesto":"0",
"modelcar":"Civic",
"odometer":"148303",
"oldinvnum":"",
"paytype_a":"CRD",
"paytype_b":"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"
}
]
}
}True

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

ActiveVfP rest JSON integration Visual FoxPro prg

Use jsonlint.com -- to validate the JSON that you are getting back.

abigdreamer
Posts: 0
Joined: Fri Jul 12, 2013 7:20 pm

ActiveVfP rest JSON integration Visual FoxPro prg

Parse error on line 105:
... } ] }}True
--------------------^
Expecting 'EOF', '}', ',', ']'

abigdreamer
Posts: 0
Joined: Fri Jul 12, 2013 7:20 pm

ActiveVfP rest JSON integration Visual FoxPro prg

I didn't write JSON.prg --- looking for info.l

Maryna Brodina
Posts: 0
Joined: Thu Apr 05, 2012 7:27 am

ActiveVfP rest JSON integration Visual FoxPro prg

Hello! You need to delete "true" in the end of your json.

Return to “Issues”