“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.

IATA INTERLINE PNL:

INTERLINE MESSAGE 
.HDQRMD1 012128
PNL
DA4519/09MAR IAG PART1
CFG/030Y
RBD Y/DEFGHKTVFT
AVAIL
 IAG MYR
Y000
-MYR124Y
1ANDRZEJEWSKI/HENRYMR-N4 .L/HV8U45
.R/EPAY HK1 CC
1ANTINORE/KIMBERLY .L/P3UF9Q
.R/EPAY HK1 CC
2BADGER/KARENJMRS/MARKWMR .L/5APEKB
.R/EPAY HK2 CC
1BARRETT/IRENEMS-Q2 .L/M1GIUA
.R/EPAY HK1 CC
2KENNEY/ALBERTMR/KAYMRS .L/WVAJL2
.R/EPAY HK2 CC
2KENT/AMYMRS/LUCASMR .L/NWH69Y
.R/EPAY HK2 CC
1KEYSER/GAIL-H2 .L/EC7XPY
.R/RQST HK1 14B
.R/EPAY HK1 CC
1KLOC/DANIEL-M4 .L/HKUADK
.R/RQST HK1 8C
.R/EPAY HK1 CC
.R/PNLT
2LICK/ROBERTMR/SUSANMR .L/3N371J
.R/EPAY HK2 CC
1LINCE/EARLMR .L/DWVQ4Y
.R/EPAY HK1 CC
1LYONS/DUANE-K2 .L/GYMWWN
.R/EPAY HK1 CC
1MAJCHRZAK/JAMESMR-N4 .L/HV8U45
.R/EPAY HK1 CC
3MAMMOLETTI/BETTYANN/MARIAH/MARK .L/T6Y0ZZ .R/RQST HK3 3F 3E 3D .R/EPAY HK3 CC
3MANN/CHARLOTTE/DAVID/HEATHER .L/TQ28RR .R/RQST HK3 2D 2E 2F .R/EPAY HK3 CC
1MBDA/GUEST-J3 .L/F52C73
.R/RQST HK1 1B
.R/EPAY HK1
ENDPART1
STRING LIST 
MESGSENDER=HDQRMD1
MESGTYPE=PNL
FLIGHTCOUNT=1
FLIGHT1-CARRIER=DA
FLIGHT1=03/09/2008 DA4519 IAG-MYR
PAXCOUNT=23
001ACTION=ADD
001FIRSTNAME=HENRY
001LASTNAME=ANDRZEJEWSKI
001GENDER=M
001PNRREF=HV8U45
001BOOKINGGROUP=N4
001PAXRBD=Y
002ACTION=ADD
002FIRSTNAME=KIMBERLY
002LASTNAME=ANTINORE
002PNRREF=P3UF9Q
002PAXRBD=Y
003ACTION=ADD
003FIRSTNAME=KARENJ
003LASTNAME=BADGER
003GENDER=F
003PNRREF=5APEKB
003PAXRBD=Y
004ACTION=ADD
004FIRSTNAME=MARKW
004LASTNAME=BADGER
004GENDER=M
004PNRREF=5APEKB
004PAXRBD=Y
005ACTION=ADD
005FIRSTNAME=IRENE
005LASTNAME=BARRETT
005GENDER=F
005PNRREF=M1GIUA
005BOOKINGGROUP=Q2
005PAXRBD=Y
006ACTION=ADD
006FIRSTNAME=ALBERT
006LASTNAME=KENNEY
006GENDER=M
006PNRREF=WVAJL2
006PAXRBD=Y
007ACTION=ADD
007FIRSTNAME=KAY
007LASTNAME=KENNEY
007GENDER=F
007PNRREF=WVAJL2
007PAXRBD=Y
008ACTION=ADD
008FIRSTNAME=AMY
008LASTNAME=KENT
008GENDER=F
008PNRREF=NWH69Y
008PAXRBD=Y
009ACTION=ADD
009FIRSTNAME=LUCAS
009LASTNAME=KENT
009GENDER=M
009PNRREF=NWH69Y
009PAXRBD=Y
010ACTION=ADD
010FIRSTNAME=GAIL
010LASTNAME=KEYSER
010PNRREF=EC7XPY
010BOOKINGGROUP=H2
010PAXSEAT=14B
010PAXRBD=Y
011ACTION=ADD
011FIRSTNAME=DANIEL
011LASTNAME=KLOC
011PNRREF=HKUADK
011BOOKINGGROUP=M4
011PAXSEAT=8C
011PAXRBD=Y
012ACTION=ADD
012FIRSTNAME=ROBERT
012LASTNAME=LICK
012GENDER=M
012PNRREF=3N371J
012PAXRBD=Y
013ACTION=ADD
013FIRSTNAME=SUSAN
013LASTNAME=LICK
013GENDER=M
013PNRREF=3N371J
013PAXRBD=Y
014ACTION=ADD
014FIRSTNAME=EARL
014LASTNAME=LINCE
014GENDER=M
014PNRREF=DWVQ4Y
014PAXRBD=Y
015ACTION=ADD
015FIRSTNAME=DUANE
015LASTNAME=LYONS
015PNRREF=GYMWWN
015BOOKINGGROUP=K2
015PAXRBD=Y
016ACTION=ADD
016FIRSTNAME=JAMES
016LASTNAME=MAJCHRZAK
016GENDER=M
016PNRREF=HV8U45
016BOOKINGGROUP=N4
016PAXRBD=Y
017ACTION=ADD
017FIRSTNAME=BETTYANN
017LASTNAME=MAMMOLETTI
017PNRREF=T6Y0ZZ
017PAXSEAT=3F
017PAXRBD=Y
018ACTION=ADD
018FIRSTNAME=MARIAH
018LASTNAME=MAMMOLETTI
018PNRREF=T6Y0ZZ
018PAXSEAT=3E
018PAXRBD=Y
019ACTION=ADD
019FIRSTNAME=MARK
019LASTNAME=MAMMOLETTI
019PNRREF=T6Y0ZZ
019PAXSEAT=3D
019PAXRBD=Y
020ACTION=ADD
020FIRSTNAME=CHARLOTTE
020LASTNAME=MANN
020PNRREF=TQ28RR
020PAXSEAT=2D
020PAXRBD=Y
021ACTION=ADD
021FIRSTNAME=DAVID
021LASTNAME=MANN
021PNRREF=TQ28RR
021PAXSEAT=2E
021PAXRBD=Y
022ACTION=ADD
022FIRSTNAME=HEATHER
022LASTNAME=MANN
022PNRREF=TQ28RR
022PAXSEAT=2F
022PAXRBD=Y
023ACTION=ADD
023FIRSTNAME=GUEST
023LASTNAME=MBDA
023PNRREF=F52C73
023BOOKINGGROUP=J3
023PAXSEAT=1B
023PAXRBD=Y
XML 
<?xml version="1.0" encoding="UTF-8" ?> 
<Message>
  <MesgSender>HDQRMD1</MesgSender>
  <MesgType>PNL</MesgType>
  <FLIGHTS count="1">
    <FLIGHT>
      <Date>03/09/2008</Date>
      <FlightNumber>DA5419</FlightNumber>
      <DepartCity>IAG</DepartCity>
      <ArriveCity>MYR</ArriveCity>
    </FLIGHT>
  </FLIGHTS>
  <PAXLIST count="23">
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>HENRY</FirstName>
      <LastName>ANDRZEJEWSKI</LastName>
      <Gender>M</Gender>
      <PNRRef>HV8U45</PNRRef>
      <BookingGroup>N4</BookingGroup>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>KIMBERLY</FirstName>
      <LastName>ANTINORE</LastName>
      <PNRRef>P3UF9Q</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>KARENJ</FirstName>
      <LastName>BADGER</LastName>
      <Gender>F</Gender>
      <PNRRef>5APEKB</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>MARKW</FirstName>
      <LastName>BADGER</LastName>
      <Gender>M</Gender>
      <PNRRef>5APEKB</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>IRENE</FirstName>
      <LastName>BARRETT</LastName>
      <Gender>F</Gender>
      <PNRRef>M1GIUA</PNRRef>
      <BookingGroup>Q2</BookingGroup>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>ALBERT</FirstName>
      <LastName>KENNEY</LastName>
      <Gender>M</Gender>
      <PNRRef>WVAJL2</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>KAY</FirstName>
      <LastName>KENNEY</LastName>
      <Gender>F</Gender>
      <PNRRef>WVAJL2</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>AMY</FirstName>
      <LastName>KENT</LastName>
      <Gender>F</Gender>
      <PNRRef>NWH69Y</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>LUCAS</FirstName>
      <LastName>KENT</LastName>
      <Gender>M</Gender>
      <PNRRef>NWH69Y</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>GAIL</FirstName>
      <LastName>KEYSER</LastName>
      <PNRRef>EC7XPY</PNRRef>
      <BookingGroup>H2</BookingGroup>
      <PAXSeat>14B</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>DANIEL</FirstName>
      <LastName>KLOC</LastName>
      <PNRRef>HKUADK</PNRRef>
      <BookingGroup>M4</BookingGroup>
      <PAXSeat>8C</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>ROBERT</FirstName>
      <LastName>LICK</LastName>
      <Gender>M</Gender>
      <PNRRef>3N371J</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>SUSAN</FirstName>
      <LastName>LICK</LastName>
      <Gender>M</Gender>
      <PNRRef>3N371J</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>EARL</FirstName>
      <LastName>LINCE</LastName>
      <Gender>M</Gender>
      <PNRRef>DWVQ4Y</PNRRef>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>DUANE</FirstName>
      <LastName>LYONS</LastName>
      <PNRRef>GYMWWN</PNRRef>
      <BookingGroup>K2</BookingGroup>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>JAMES</FirstName>
      <LastName>MAJCHRZAK</LastName>
      <Gender>M</Gender>
      <PNRRef>HV8U45</PNRRef>
      <BookingGroup>N4</BookingGroup>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>BETTYANN</FirstName>
      <LastName>MAMMOLETTI</LastName>
      <PNRRef>T6Y0ZZ</PNRRef>
      <PAXSeat>3F</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>MARIAH</FirstName>
      <LastName>MAMMOLETTI</LastName>
      <PNRRef>T6Y0ZZ</PNRRef>
      <PAXSeat>3E</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>MARK</FirstName>
      <LastName>MAMMOLETTI</LastName>
      <PNRRef>T6Y0ZZ</PNRRef>
      <PAXSeat>3D</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>CHARLOTTE</FirstName>
      <LastName>MANN</LastName>
      <PNRRef>TQ28RR</PNRRef>
      <PAXSeat>2D</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>DAVID</FirstName>
      <LastName>MANN</LastName>
      <PNRRef>TQ28RR</PNRRef>
      <PAXSeat>2E</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>HEATHER</FirstName>
      <LastName>MANN</LastName>
      <PNRRef>TQ28RR</PNRRef>
      <PAXSeat>2F</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
    <PAX>
      <ACTION>ADD</ACTION>
      <FirstName>GUEST</FirstName>
      <LastName>MBDA</LastName>
      <PNRRef>F52C73</PNRRef>
      <BookingGroup>J3</BookingGroup>
      <PAXSeat>1B</PAXSeat>
      <PAXRBD>Y</PAXRBD>
    </PAX>
  </PAXLIST>
</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