“ONE SOLUTION” BACK

APIS1.com DATA TRANSFORMATION Services

Using APIS1.com technology, you can connect to the APIS1.com system and send your message data and the APIS1.com system will automatically immediately convert it to a useable format. The APIS1.com system accepts numerous INPUT message formats as well as several different OUTPUT formats.

CBP UN/EDIFACT PAXLST PNR:

UN/EDIFACT
UNA:+.?*’ 
UNB+UNOA:4+ZZAIR+DHS+080708:0545+000000001++DHS' 
UNG+PAXLST+ZZAIR+ DHS+080708:0545+1+UN+D:05B' 
UNH+PAX001+PAXLST:D:05B:UN:IATA' 
BGM+745+PNR'
RFF+AVF:A1B2C3’
RFF+ACE:D4E5F6::P’
DTM+179:20080610'
DTM+558:20080612'
DTM+183:20080630'
NAD+MS+++C UNDERWOOD’
COM+703-555-1212:TE+703-555-4545:FX' 
NAD+BA+ORION TRAVEL++J JAVERT’
NAD+AG+ORION TRAVEL++D SONET’
TDT+20+QQ827+++QQ'
LOC+92+VIE’
DTM+189:200807102140:201'
LOC+92+BRU'
DTM+232:200807102355:201'
TDT+20+ QQ827+++QQ'
LOC+92+BRU'
DTM+189:200807102140:201'
LOC+92+CDG’
DTM+232:200807102300:201'
TDT+20+QQ827+++QQ '
LOC+125+CDG'
DTM+189:200807110200:201'
LOC+87+IAD’
DTM+232:200807111035:201'
NAD+FL+++BARRE:TODD+123 E MAIN ST+STAFFORD+VA+22554+USA'
ATT+2++M'
DTM+329:680223'
GEI+4+ZZZ:::HK'
LOC+178+VIE'
LOC+179+IAD'
LOC+174+FRA'
LOC+22+IAD'
COM+55 121212:TE+033:AI'
NAT+2+FRA'
RFF+AVF:A1B2C3'
RFF+ABO:UUI34T543'
RFF+SEA:35F'
RFF+ACD:AA1234567890'
RFF+CBA:09-87-654321'
MOA+11:435.50:EUR'
DOC+P+YY3478621G'
DTM+36:081230'
LOC+91+FRA:::PARIS'
NAD+FL+++LANG:KRISTIN+123 E MAIN ST+ STAFFORD+VA+22554+USA'
ATT+2++F'
DTM+329:700606'
GEI+4+ZZZ:::HK'
LOC+178+VIE'
LOC+179+IAD'
LOC+174+ESP'
COM+55 343434:TE+033:AI'
NAT+2+ESP'
RFF+AVF:A1B2C3'
RFF+ABO:WWT098L31E'
RFF+SEA:35E'
RFF+CBA:09-87-654325'
MOA+11:435.50:EUR'
DOC+P+YY3478621G'
DTM+36:081230'
LOC+91+ESP'
CNT+42:2'
CNT+59:3'
UNS+S'
FTX+OSI+++CTCA 703-555-1212 STEVEN WILSON TVL/X33566153/JOESEPH'
FTX+OSI+++CTCT NYC 888-555-1111 COOL TRAVEL SCA I 12 234234'
FTX+SSR+++FQTVQQHK1/ QQ8270000/BARRE/TODDMR'
FTX+SSR+++TKNEBAHK2/ QQ8270000/LANG/KRISTINMS'
FTX+SSR+++PLS SEE QQ SEAT POLICY - SEAT REQUEST NOT PERMITTED'
FTX+HST+C++EI 166 Y 08JUL10 VIEBRU HK1 1340 1555/HK'
FTX+PMT++AB+300, AV SUFFREN 75015 Paris, France'
FTX+PMT++TYP+CASH'
FTX+MKS+++QQ-123-11111111'
FTX+MKS+++QQ-123-22222222'
FTX+MKS+++QQ-123-33333333'
FTX+AAI+++VALUED PASSENGER'
UNT+78+PAX001' 
UNE+1+1' 
UNZ+1+000000001'
STRING LIST
MESGSENDER=ZZAIR
MESGDATE=07/08/08
MESGTIME=0545
MESGCONTROLREF=000000001
MESGCONTENT=745 PNR
MESGTYPE=PAXLST
CARRIER=ZZAIR
REPORTINGPARTY=C UNDERWOOD
CONTACTPHONE=703-555-1212
CONTACTFAX=703-555-4545
ISPNR=TRUE
PNR=A1B2C3
SPLITPNR=D4E5F6
PNRISSUEDON=06/10/2008
PNRSPLITON=06/12/2008
TICKETISSUEDON=06/30/2008
AGENCY=ORION TRAVEL
AGENTNAME=J JAVERT
CHANGINGAGENCY=ORION TRAVEL
CHANGINGAGENTNAME=D SONET
FLIGHTCOUNT=3
FLIGHT1-CARRIER=QQ
FLIGHT2-CARRIER=QQ
FLIGHT3-CARRIER=QQ
FLIGHT1=07/10/2008 QQ827 VIE-BRU 2140 2355
FLIGHT2=07/10/2008 QQ827 BRU-CDG 2140 2300
FLIGHT3=07/11/2008 QQ827 CDG-IAD 0200 1035
PAXCOUNT=2
001FIRSTNAME=TODD
001LASTNAME=BARRE
001DOB=02/23/68
001GENDER=M
001PAXTYPE=FL
001CITIZENSHIP=FRA
001RESIDENCE=FRA
001DOCTYPE1=P
001DOCNMBR1=YY3478621G
001DOCEXP1=12/30/08
001DOCCOUNTRY1=FRA
001DESTADDRESS=123 E MAIN ST
001DESTCITY=STAFFORD
001DESTSTATE=VA
001DESTZIP=22554
001DESTCOUNTRY=USA
001PNRREF=A1B2C3
001PAXREF=UUI34T543
001PAXSEAT=35F
001REFACD=AA1234567890
001PAXTICKET=09-87-654321
001PAXTICKETPRICE=435.50
001PAXTICKETCURRENCY=EUR
001PNRSTATUS=HK
001EMBARKATION=VIE
001DEBARKATION=IAD
001ENTRYCITY=IAD
002FIRSTNAME=KRISTIN
002LASTNAME=LANG
002DOB=06/06/70
002GENDER=F
002PAXTYPE=FL
002CITIZENSHIP=ESP
002RESIDENCE=ESP
002DOCTYPE1=P
002DOCNMBR1=YY3478621G
002DOCEXP1=12/30/08
002DOCCOUNTRY1=ESP
002DESTADDRESS=123 E MAIN ST
002DESTCITY=STAFFORD
002DESTSTATE=VA
002DESTZIP=22554
002DESTCOUNTRY=USA
002PNRREF=A1B2C3
002PAXREF=WWT098L31E
002PAXSEAT=35E
002PAXTICKET=09-87-654325
002PAXTICKETPRICE=435.50
002PAXTICKETCURRENCY=EUR
002PNRSTATUS=HK
002EMBARKATION=VIE
002DEBARKATION=IAD
PNRFREETEXTTYPES=OSI,SSR,HST,PMT,MKS,AAI
OSI-COUNT=2
SSR-COUNT=3
HST-COUNT=1
PMT-COUNT=2
MKS-COUNT=3
AAI-COUNT=1
OSI1=CTCA 703-555-1212 STEVEN WILSON TVL/X33566153/JOESEPH
OSI2=CTCT NYC 888-555-1111 COOL TRAVEL SCA I 12 234234
SSR1=FQTVQQHK1/ QQ8270000/BARRE/TODDMR
SSR2=TKNEBAHK2/ QQ8270000/LANG/KRISTINMS
SSR3=PLS SEE QQ SEAT POLICY - SEAT REQUEST NOT PERMITTED
HST1=C EI 166 Y 08JUL10 VIEBRU HK1 1340 1555/HK
PMT1=AB 300, AV SUFFREN 75015 Paris, France
PMT2=TYP CASH
MKS1=QQ-123-11111111
MKS2=QQ-123-22222222
MKS3=QQ-123-33333333
AAI1=VALUED PASSENGER
XML
<?xml version="1.0" encoding="UTF-8" ?> 
<Message>
  <MesgSender>ZZAIR</MesgSender>
  <MesgDate>07/08/08</MesgDate>
  <MesgTime>0545</MesgTime>
  <MesgControlRef>000000001</MesgControlRef>
  <MesgContent>745 PNR</MesgContent>
  <MesgType>PAXLST</MesgType>
  <Carrier>ZZAIR</Carrier>
  <ReportingParty>C UNDERWOOD</ReportingParty>
  <ContactPhone>703-555-1212</ContactPhone>
  <ContactFax>703-555-4545</ContactFax>
  <IsPNR>TRUE</IsPNR>
  <PNR>A1B2C3</PNR>
  <SplitPNR>D4E5F6</SplitPNR>
  <PNRIssuedOn>06/10/2008</PNRIssuedOn>
  <PNRSplitOn>06/12/2008</PNRSplitOn>
  <TicketIssuedOn>06/30/2008</TicketIssuedOn>
  <Agency>ORION TRAVEL</Agency>
  <AgentName>J JAVERT</AgentName>
  <ChangingAgency>ORION TRAVEL</ChangingAgency>
  <ChangingAgentName>D SONET</ChangingAgentName>
  <FLIGHTS count="3">
    <FLIGHT>
      <Carrier>QQ</Carrier>
      <Date>07/10/2008</Date>
      <FlightNumber>QQ827</FlightNumber>
      <DepartCity>VIE</DepartCity>
      <ArriveCity>BRU</ArriveCity>
      <ETD>2140</ETD>
      <ETA>2355</ETA>
    </FLIGHT>
    <FLIGHT>
      <Carrier>QQ</Carrier>
      <Date>07/10/2008</Date>
      <FlightNumber>QQ827</FlightNumber>
      <DepartCity>BRU</DepartCity>
      <ArriveCity>CDG</ArriveCity>
      <ETD>2140</ETD>
      <ETA>2300</ETA>
    </FLIGHT>
    <FLIGHT>
      <Carrier>QQ</Carrier>
      <Date>07/11/2008</Date>
      <FlightNumber>QQ827</FlightNumber>
      <DepartCity>CDG</DepartCity>
      <ArriveCity>IAD</ArriveCity>
      <ETD>0200</ETD>
      <ETA>1035</ETA>
    </FLIGHT>
  </FLIGHTS>
  <PAXLIST count="2">
    <PAX>
      <FirstName>TODD</FirstName>
      <LastName>BARRE</LastName>
      <DOB>02/23/68</DOB>
      <Gender>M</Gender>
      <PaxType>FL</PaxType>
      <Citizenship>FRA</Citizenship>
      <Residence>FRA</Residence>
      <DocType1>P</DocType1>
      <DocNmbr1>YY3478621G</DocNmbr1>
      <DocExp1>12/30/08</DocExp1>
      <DocCountry1>FRA</DocCountry1>
      <DestAddress>123 E MAIN ST</DestAddress>
      <DestCity>STAFFORD</DestCity>
      <DestState>VA</DestState>
      <DestZIP>22554</DestZIP>
      <DestCountry>USA</DestCountry>
      <PNRRef>A1B2C3</PNRRef>
      <PAXRef>UUI34T543</PAXRef>
      <PAXSeat>35F</PAXSeat>
      <RefACD>AA1234567890</RefACD>
      <PAXTicket>09-87-654321</PAXTicket>
      <PAXTicketPrice>435.50</PAXTicketPrice>
      <PAXTicketCurrency>EUR</PAXTicketCurrency>
      <PNRStatus>HK</PNRStatus>
      <EMBARKATION>VIE</EMBARKATION>
      <DEBARKATION>IAD</DEBARKATION>
      <ENTRYCITY>IAD</ENTRYCITY>
    </PAX>
    <PAX>
      <FirstName>KRISTIN</FirstName>
      <LastName>LANG</LastName>
      <DOB>06/06/70</DOB>
      <Gender>F</Gender>
      <PaxType>FL</PaxType>
      <Citizenship>ESP</Citizenship>
      <Residence>ESP</Residence>
      <DocType1>P</DocType1>
      <DocNmbr1>YY3478621G</DocNmbr1>
      <DocExp1>12/30/08</DocExp1>
      <DocCountry1>ESP</DocCountry1>
      <DestAddress>123 E MAIN ST</DestAddress>
      <DestCity>STAFFORD</DestCity>
      <DestState>VA</DestState>
      <DestZIP>22554</DestZIP>
      <DestCountry>USA</DestCountry>
      <PNRRef>A1B2C3</PNRRef>
      <PAXRef>WWT098L31E</PAXRef>
      <PAXSeat>35E</PAXSeat>
      <PAXTicket>09-87-654325</PAXTicket>
      <PAXTicketPrice>435.50</PAXTicketPrice>
      <PAXTicketCurrency>EUR</PAXTicketCurrency>
      <PNRStatus>HK</PNRStatus>
      <EMBARKATION>VIE</EMBARKATION>
      <DEBARKATION>IAD</DEBARKATION>
    </PAX>
  </PAXLIST>
  <PNRFreeTextTypes>OSI,SSR,HST,PMT,MKS,AAI</PNRFreeTextTypes>
  <OSI count="2">
    <MSG>CTCA 703-555-1212 STEVEN WILSON TVL/X33566153/JOESEPH</MSG>
    <MSG>CTCT NYC 888-555-1111 COOL TRAVEL SCA I 12 234234</MSG>
  </OSI> 
  <SSR count="3">
    <MSG>FQTVQQHK1/ QQ8270000/BARRE/TODDMR</MSG>
    <MSG>TKNEBAHK2/ QQ8270000/LANG/KRISTINMS</MSG>
    <MSG>PLS SEE QQ SEAT POLICY - SEAT REQUEST NOT PERMITTED</MSG>
  </SSR>
  <HST count="1">
    <MSG>C EI 166 Y 08JUL10 VIEBRU HK1 1340 1555/HK</MSG>
  </HSTLIST>
  <PMT count="2">
    <MSG>AB 300, AV SUFFREN 75015 Paris, France</MSG>
    <MSG>TYP CASH</MSG>
  </PMT>
  <MKS count="3">
    <MSG>QQ-123-11111111</MSG>
    <MSG>QQ-123-22222222</MSG>
    <MSG>QQ-123-33333333</MSG>
  </MKS>
  <AAI count="1">
    <MSG>VALUED PASSENGER</MSG>
  </AAI>
</Message>
Back to Data Transformation Index


CALL TODAY FOR ALL YOUR APIS SOLUTIONS

Aviation Technologies, Inc.
Wilkes-Barre/Scranton International Airport, Avoca, Pennsylvania, USA

570-457-4147

info@apis1.com