PowerShell Concur: Get Travel Receipt Requests

Back to Index

Retrieves Concur travel receipt requests.

Documentation: https://developer.concur.com/api-reference/travel-receipts/overview.html

CURL Command

curl -H "Authorization: Bearer {YOUR ACCESS TOKEN}" https://us.api.concursolutions.com/travelreceipts/v1/receiptrequests
See: Online Tool to Generate Chilkat Code from a CURL Command

PowerShell Example

[Reflection.Assembly]::LoadFile("C:\myAssemblies\ChilkatDotNet2.dll")

$rest = New-Object Chilkat.Rest

#  URL: https://us.api.concursolutions.com/travelreceipts/v1/receiptrequests
$bTls = $true
$port = 443
$bAutoReconnect = $true
$success = $rest.Connect("us.api.concursolutions.com",$port,$bTls,$bAutoReconnect)
if ($success -ne $true) {
    $("ConnectFailReason: " + $rest.ConnectFailReason)
    $($rest.LastErrorText)
    exit
}

$rest.AddHeader("Authorization","Bearer {YOUR ACCESS TOKEN}")

$sbResponseBody = New-Object Chilkat.StringBuilder
$success = $rest.FullRequestNoBodySb("GET","/travelreceipts/v1/receiptrequests",$sbResponseBody)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

$respStatusCode = $rest.ResponseStatusCode
if ($respStatusCode -ge 400) {
    $("Response Status Code = " + $respStatusCode)
    $("Response Header:")
    $($rest.ResponseHeader)
    $("Response Body:")
    $($sbResponseBody.GetAsString())
    exit
}

$jsonResponse = New-Object Chilkat.JsonObject
$jsonResponse.LoadSb($sbResponseBody)

$next = $jsonResponse.StringOf("next")
$i = 0
$count_i = $jsonResponse.SizeOfArray("items")
while ($i -lt $count_i) {
    $jsonResponse.I = $i
    $requestId = $jsonResponse.StringOf("items[i].requestId")
    $confirmationNumber = $jsonResponse.StringOf("items[i].confirmationNumber")
    $firstName = $jsonResponse.StringOf("items[i].firstName")
    $lastName = $jsonResponse.StringOf("items[i].lastName")
    $segmentStartDate = $jsonResponse.StringOf("items[i].segmentStartDate")
    $segmentEndDate = $jsonResponse.StringOf("items[i].segmentEndDate")
    $requestDate = $jsonResponse.StringOf("items[i].requestDate")
    $i = $i + 1
}

Sample JSON Response Body

{
  "items": [
    {
      "requestId": "905be7a3-882e-4bdf-8184-206908142aed",
      "confirmationNumber": "324186883",
      "firstName": "THOMAS",
      "lastName": "METGER",
      "segmentStartDate": "2018-01-30T14:40:00Z",
      "segmentEndDate": "2018-02-01T21:55:00Z",
      "requestDate": "2018-01-23T18:49:57.915931237Z"
    },
    {
      "requestId": "89eaff84-1cbe-4a2f-9048-5884117bd17e",
      "confirmationNumber": "335512084",
      "firstName": "CLYDE",
      "lastName": "DUNCAN",
      "segmentStartDate": "2018-01-23T15:30:00Z",
      "segmentEndDate": "2018-01-27T18:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915933229Z"
    },
    {
      "requestId": "df1b2194-97b7-4c97-9c8a-fe5e42a6326b",
      "confirmationNumber": "443502429",
      "firstName": "SAM",
      "lastName": "SELIMAN",
      "segmentStartDate": "2018-03-16T18:15:00Z",
      "segmentEndDate": "2018-03-20T01:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915935026Z"
    },
    {
      "requestId": "b338497d-6443-4c19-ab1d-105bf6acf01c",
      "confirmationNumber": "4652321537",
      "firstName": "WALTER",
      "lastName": "RICHARD",
      "segmentStartDate": "2018-01-22T14:00:00Z",
      "segmentEndDate": "2018-01-25T17:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915936721Z"
    },
    {
      "requestId": "29a8925f-56a1-4a37-b3dc-fab2d1f85a1d",
      "confirmationNumber": "212291436",
      "firstName": "VAN",
      "lastName": "CLYDE",
      "segmentStartDate": "2018-01-22T16:00:00Z",
      "segmentEndDate": "2018-01-25T23:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915938106Z"
    },
    {
      "requestId": "8b803a73-8dd2-43bf-8f35-8aa6d24f82c1",
      "confirmationNumber": "934514835",
      "firstName": "LYNN",
      "lastName": "CAREY",
      "segmentStartDate": "2018-01-23T18:45:00Z",
      "segmentEndDate": "2018-01-26T03:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915939879Z"
    },
    {
      "requestId": "36653406-08f5-425f-b186-653c53fcf3b1",
      "confirmationNumber": "244689456",
      "firstName": "GEORGE",
      "lastName": "STOLLEY",
      "segmentStartDate": "2018-01-24T13:30:00Z",
      "segmentEndDate": "2018-01-25T13:30:00Z",
      "requestDate": "2018-01-23T18:49:57.915941244Z"
    },
    {
      "requestId": "44c2267e-8630-4ea7-a958-a598d2000611",
      "confirmationNumber": "530203526",
      "firstName": "CHRIS",
      "lastName": "GALLAGHER",
      "segmentStartDate": "2018-01-30T20:35:00Z",
      "segmentEndDate": "2018-02-03T13:15:00Z",
      "requestDate": "2018-01-23T18:49:57.915942604Z"
    },
    {
      "requestId": "7d6bbb2f-2862-44aa-9764-c779fae94fe9",
      "confirmationNumber": "455319127",
      "firstName": "STEVE",
      "lastName": "LOCK",
      "segmentStartDate": "2018-01-23T23:30:00Z",
      "segmentEndDate": "2018-01-26T23:30:00Z",
      "requestDate": "2018-01-23T18:49:57.915943946Z"
    },
    {
      "requestId": "ade1df9d-629f-4a99-86a2-2c6cc87221fb",
      "confirmationNumber": "163724658",
      "firstName": "TRACEY",
      "lastName": "CAMPBELL",
      "segmentStartDate": "2018-01-25T00:05:00Z",
      "segmentEndDate": "2018-01-26T18:40:00Z",
      "requestDate": "2018-01-23T18:49:57.915949116Z"
    },
    {
      "requestId": "787bd2ba-aaaf-4e04-ae85-1f05a3679101",
      "confirmationNumber": "245527331",
      "firstName": "SAMMY",
      "lastName": "STEVENS",
      "segmentStartDate": "2018-01-25T04:15:00Z",
      "segmentEndDate": "2018-01-26T02:25:00Z",
      "requestDate": "2018-01-23T18:49:57.915950543Z"
    },
    {
      "requestId": "ee74ace2-67bf-4af5-b64e-6695f7ea971d",
      "confirmationNumber": "132759455",
      "firstName": "DAVE",
      "lastName": "SCHULTZ",
      "segmentStartDate": "2018-02-03T02:07:00Z",
      "segmentEndDate": "2018-02-08T16:50:00Z",
      "requestDate": "2018-01-23T18:49:57.915951902Z"
    },
    {
      "requestId": "9d783dfc-6bcd-4391-b659-53b673c7eb23",
      "confirmationNumber": "537355772",
      "firstName": "GARY",
      "lastName": "BOTTIS",
      "segmentStartDate": "2018-01-23T02:25:00Z",
      "segmentEndDate": "2018-01-26T16:35:00Z",
      "requestDate": "2018-01-23T18:49:57.915953271Z"
    },
    {
      "requestId": "6cb48fad-0468-4f6a-8e68-6bc2dfbdda5f",
      "confirmationNumber": "553257291",
      "firstName": "NICOLE",
      "lastName": "ELKIDGE",
      "segmentStartDate": "2018-01-22T04:30:00Z",
      "segmentEndDate": "2018-01-26T21:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915954617Z"
    },
    {
      "requestId": "539039fc-11ad-46d9-83f8-45260391caa9",
      "confirmationNumber": "304450523",
      "firstName": "NADIA",
      "lastName": "KHAN",
      "segmentStartDate": "2018-01-22T04:00:00Z",
      "segmentEndDate": "2018-01-26T16:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915955955Z"
    },
    {
      "requestId": "c5198cd7-e87e-4f07-86fa-a712dcd49bbf",
      "confirmationNumber": "248124345",
      "firstName": "JAMIE",
      "lastName": "COTTIGAN",
      "segmentStartDate": "2018-01-29T23:00:00Z",
      "segmentEndDate": "2018-01-31T21:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915957285Z"
    },
    {
      "requestId": "d567bfed-b6ca-40c0-a1ae-f5c5339e9258",
      "confirmationNumber": "322723456",
      "firstName": "SARAH",
      "lastName": "STANLEY",
      "segmentStartDate": "2018-06-06T19:14:00Z",
      "segmentEndDate": "2018-06-09T16:40:00Z",
      "requestDate": "2018-01-23T18:49:57.915958625Z"
    },
    {
      "requestId": "f9ae54c7-eb19-494b-a46c-bb5d76f17973",
      "confirmationNumber": "312876745",
      "firstName": "MELISSA",
      "lastName": "NIAYE",
      "segmentStartDate": "2018-01-26T22:50:00Z",
      "segmentEndDate": "2018-02-09T20:45:00Z",
      "requestDate": "2018-01-23T18:49:57.915961987Z"
    },
    {
      "requestId": "6378174d-d38b-4f9a-af85-8c3033efc491",
      "confirmationNumber": "313324743",
      "firstName": "SCOTTY",
      "lastName": "THOMPSON",
      "segmentStartDate": "2018-01-22T21:24:00Z",
      "segmentEndDate": "2018-01-26T13:15:00Z",
      "requestDate": "2018-01-23T18:49:57.915963318Z"
    },
    {
      "requestId": "aab3ea49-a899-4ecf-90b0-ed474408447e",
      "confirmationNumber": "313853757",
      "firstName": "MICHAEL",
      "lastName": "CARSON",
      "segmentStartDate": "2018-02-01T20:05:00Z",
      "segmentEndDate": "2018-02-02T23:25:00Z",
      "requestDate": "2018-01-23T18:49:57.915964654Z"
    },
    {
      "requestId": "99268619-f42a-4abd-ae44-698a37791a4e",
      "confirmationNumber": "4332095991",
      "firstName": "CECIL",
      "lastName": "LEE",
      "segmentStartDate": "2018-01-29T16:02:00Z",
      "segmentEndDate": "2018-02-01T16:40:00Z",
      "requestDate": "2018-01-23T18:49:57.915966004Z"
    },
    {
      "requestId": "18b124b8-7fa3-438b-85c6-57e16e5b3258",
      "confirmationNumber": "346384323",
      "firstName": "JOHN",
      "lastName": "FRANK",
      "segmentStartDate": "2018-04-25T16:00:00Z",
      "segmentEndDate": "2018-04-29T23:30:00Z",
      "requestDate": "2018-01-23T18:49:57.915967343Z"
    },
    {
      "requestId": "f80ee9ba-2d04-416e-9a96-ac7b282b38a9",
      "confirmationNumber": "407480677",
      "firstName": "STACEY",
      "lastName": "SCOTT",
      "segmentStartDate": "2018-02-05T18:00:00Z",
      "segmentEndDate": "2018-02-09T10:30:00Z",
      "requestDate": "2018-01-23T18:49:57.915968682Z"
    },
    {
      "requestId": "bb8da2e0-c7c2-454b-84bf-c3a2f9ed37fb",
      "confirmationNumber": "553338341",
      "firstName": "GEORGE",
      "lastName": "TESSER",
      "segmentStartDate": "2018-01-26T20:00:00Z",
      "segmentEndDate": "2018-01-28T20:00:00Z",
      "requestDate": "2018-01-23T18:49:57.9159701Z"
    },
    {
      "requestId": "a2903477-f4a8-4159-bf9a-4f42cea47ce1",
      "confirmationNumber": "530244855",
      "firstName": "ERICA",
      "lastName": "VANASSEY",
      "segmentStartDate": "2018-01-22T13:00:00Z",
      "segmentEndDate": "2018-01-23T00:00:00Z",
      "requestDate": "2018-01-23T18:49:57.915971485Z"
    }
  ],
  "next": "/v1/receiptrequests/1516561200/6443f257-03fe-5881-ac46-2e4865d944d3"
}