POST api/AirRates/AddAirRatesFromExcel

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
AddedBy	integer	None.
AddedOn	date	None.
Effective	date	None.
Expiry	date	None.
Commodity	string	None.
Notes	string	None.
Rates	Collection of AirRatesResp	None.
isNew	boolean	None.

Request Formats

application/json, text/json

Sample:

{
  "AddedBy": 1,
  "AddedOn": "2026-07-27T19:07:40.5485884+05:00",
  "Effective": "2026-07-27T19:07:40.5485884+05:00",
  "Expiry": "2026-07-27T19:07:40.5485884+05:00",
  "Commodity": "sample string 3",
  "Notes": "sample string 4",
  "Rates": [
    {
      "idx": 1,
      "Origin": 2,
      "Destination": 3,
      "rate": 4.0,
      "guideCut": 5.0,
      "minimum": 6.0,
      "m100": 7.0,
      "p100": 8.0,
      "p500": 9.0,
      "Notes": "sample string 10",
      "Commodity": "sample string 11",
      "Effective": "2026-07-27T19:07:40.5485884+05:00",
      "Expiry": "2026-07-27T19:07:40.5485884+05:00",
      "AddedBy": 14,
      "AddedOn": "2026-07-27T19:07:40.5485884+05:00",
      "AddedByName": "sample string 16",
      "OriginName": "sample string 17",
      "DestinationName": "sample string 18"
    },
    {
      "idx": 1,
      "Origin": 2,
      "Destination": 3,
      "rate": 4.0,
      "guideCut": 5.0,
      "minimum": 6.0,
      "m100": 7.0,
      "p100": 8.0,
      "p500": 9.0,
      "Notes": "sample string 10",
      "Commodity": "sample string 11",
      "Effective": "2026-07-27T19:07:40.5485884+05:00",
      "Expiry": "2026-07-27T19:07:40.5485884+05:00",
      "AddedBy": 14,
      "AddedOn": "2026-07-27T19:07:40.5485884+05:00",
      "AddedByName": "sample string 16",
      "OriginName": "sample string 17",
      "DestinationName": "sample string 18"
    }
  ],
  "isNew": true
}

application/xml, text/xml

Sample:

<AddUpdateAirRateReq xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/RSE_API.UwstModels.Requests">
  <AddedBy>1</AddedBy>
  <AddedOn>2026-07-27T19:07:40.5485884+05:00</AddedOn>
  <Commodity>sample string 3</Commodity>
  <Effective>2026-07-27T19:07:40.5485884+05:00</Effective>
  <Expiry>2026-07-27T19:07:40.5485884+05:00</Expiry>
  <Notes>sample string 4</Notes>
  <Rates xmlns:d2p1="http://schemas.datacontract.org/2004/07/RSE_API.UwstModels.Responses">
    <d2p1:AirRatesResp>
      <d2p1:AddedBy>14</d2p1:AddedBy>
      <d2p1:AddedByName>sample string 16</d2p1:AddedByName>
      <d2p1:AddedOn>2026-07-27T19:07:40.5485884+05:00</d2p1:AddedOn>
      <d2p1:Commodity>sample string 11</d2p1:Commodity>
      <d2p1:Destination>3</d2p1:Destination>
      <d2p1:DestinationName>sample string 18</d2p1:DestinationName>
      <d2p1:Effective>2026-07-27T19:07:40.5485884+05:00</d2p1:Effective>
      <d2p1:Expiry>2026-07-27T19:07:40.5485884+05:00</d2p1:Expiry>
      <d2p1:Notes>sample string 10</d2p1:Notes>
      <d2p1:Origin>2</d2p1:Origin>
      <d2p1:OriginName>sample string 17</d2p1:OriginName>
      <d2p1:guideCut>5</d2p1:guideCut>
      <d2p1:idx>1</d2p1:idx>
      <d2p1:m100>7</d2p1:m100>
      <d2p1:minimum>6</d2p1:minimum>
      <d2p1:p100>8</d2p1:p100>
      <d2p1:p500>9</d2p1:p500>
      <d2p1:rate>4</d2p1:rate>
    </d2p1:AirRatesResp>
    <d2p1:AirRatesResp>
      <d2p1:AddedBy>14</d2p1:AddedBy>
      <d2p1:AddedByName>sample string 16</d2p1:AddedByName>
      <d2p1:AddedOn>2026-07-27T19:07:40.5485884+05:00</d2p1:AddedOn>
      <d2p1:Commodity>sample string 11</d2p1:Commodity>
      <d2p1:Destination>3</d2p1:Destination>
      <d2p1:DestinationName>sample string 18</d2p1:DestinationName>
      <d2p1:Effective>2026-07-27T19:07:40.5485884+05:00</d2p1:Effective>
      <d2p1:Expiry>2026-07-27T19:07:40.5485884+05:00</d2p1:Expiry>
      <d2p1:Notes>sample string 10</d2p1:Notes>
      <d2p1:Origin>2</d2p1:Origin>
      <d2p1:OriginName>sample string 17</d2p1:OriginName>
      <d2p1:guideCut>5</d2p1:guideCut>
      <d2p1:idx>1</d2p1:idx>
      <d2p1:m100>7</d2p1:m100>
      <d2p1:minimum>6</d2p1:minimum>
      <d2p1:p100>8</d2p1:p100>
      <d2p1:p500>9</d2p1:p500>
      <d2p1:rate>4</d2p1:rate>
    </d2p1:AirRatesResp>
  </Rates>
  <isNew>true</isNew>
</AddUpdateAirRateReq>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

HttpResponseMessage

Name	Type	Additional information
Version	Version	None.
Content	HttpContent	None.
StatusCode	HttpStatusCode	None.
ReasonPhrase	string	None.
Headers	Collection of Object	None.
RequestMessage	HttpRequestMessage	None.
IsSuccessStatusCode	boolean	None.