Skip to content

Instantly share code, notes, and snippets.

View dperussina's full-sized avatar

Daniel Perussina dperussina

  • FragilePAK
  • Unknown
View GitHub Profile
{
"error": false,
"data": [{
"LoadID": "L200405-00008",
"Origin": "WDDC",
"OriginCity": "WACO",
"OriginState": "TX",
"OriginZipcode": "76712",
"Destination": "TX031",
"DestinationCity": "Garland",
{
"error": false,
"data": [{
"LoadID": "L200401-00106",
"Origin": "KS004",
"OriginCity": "Pittsburg",
"OriginState": "KS",
"OriginZipcode": "66762",
"Destination": "TX031",
"DestinationCity": "Garland",
{
"OnBoardDateTime": "4/3/2020",
"userName": "AAFES",
"facility": "DDDC",
"vehicle": "LoadTest-4320",
"trailer": null,
"driver": null,
"orders": [{
"freightPhotos": null,
"orderNumberPK": "AAFES:263U1005",
{
"OnBoardDateTime": "4/2/2020 3:24:39 PM",
"userName": "AUTOMATED",
"facility": "KS004",
"vehicle": "L200401-00072",
{
"OnBoardDateTime": "4/2/2020",
"userName": "dperussina",
"facility": "DDDC",
"vehicle": "AAFES_TEST",
"trailer": null,
"driver": null,
"orders": [{
"freightPhotos": null,
"orderNumberPK": "AAFES:9263U1103",
{
"error": false,
"data": [{
"LoadID": "AAFES_TEST",
"Origin": "DDDC",
"OriginCity": "NEWPORT NEWS",
"OriginState": "VA",
"OriginZipcode": "23603",
"Destination": "VA001",
"DestinationCity": "Richmond",
{
"error": false,
"data": [{
"LoadID": "L200322-00010",
"Origin": "CA004",
"OriginCity": "Santa Fe Springs",
"OriginState": "CA",
"OriginZipcode": "90670",
"Destination": "CA004",
"DestinationCity": "Santa Fe Springs",
{
"OnBoardDateTime": "3/20/2020",
"userName": "athompson",
"facility": "VA008",
"vehicle": "DROPSHIP",
"trailer": null,
"driver": null,
"orders": [{
"freightPhotos": null,
"orderNumberPK": "Residential Direct:9025908605",
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:LoadTenderData xmlns:ns2="http://schemas.3gtms.com/tms/v1/tns">
<BatchInfo>
<BatchNum>TRN-05129358</BatchNum>
<BatchDateTime>2020-02-25T21:05:08.679Z</BatchDateTime>
<SentBy>yrc_tgreenwood</SentBy>
<PageNum>1</PageNum>
<PageCnt>1</PageCnt>
</BatchInfo>
<Action>New</Action>
DECLARE @b64 VARCHAR(MAX);
SET @b64 = '/9j/4AAQSkZJRgABAQAAAQABAAD/4gIoSUNDX1BST0ZJTEUAAQEAAAIYAAAAAAIQAABtbnRyUkdCIFhZWiAAAAAAAAAAAAAAAABhY3NwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAA9tYAAQAAAADTLQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlkZXNjAAAA8AAAAHRyWFlaAAABZAAAABRnWFlaAAABeAAAABRiWFlaAAABjAAAABRyVFJDAAABoAAAAChnVFJDAAABoAAAAChiVFJDAAABoAAAACh3dHB0AAAByAAAABRjcHJ0AAAB3AAAADxtbHVjAAAAAAAAAAEAAAAMZW5VUwAAAFgAAAAcAHMAUgBHAEIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAAAA+EAAC2z3BhcmEAAAAAAAQAAAACZmYAAPKnAAANWQAAE9AAAApbAAAAAAAAAABYWVogAAAAAAAA9tYAAQAAAADTLW1sdWMAAAAAAAAAAQAAAAxlblVTAAAAIAAAABwARwBvAG8AZwBsAGUAIABJAG4AYwAuACAAMgAwADEANv/bAEMACAYGBwYFCAcHBwkJCAoMFA0MCwsMGRITDxQdGh8eHRocHCAkLicgIiwjHBwoNyksMDE0NDQfJzk9ODI8LjM0Mv/bAEMBCQkJDAsMGA0NGDIhHCEyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMv/AABEIAS4BkwMBIgACEQEDEQH/xAAcAAABB