Cmdlets for SAP Concur

Build 23.0.8839


Lists Suppliers based on the search criteria.

Table Specific Information


To query this table, the WHERE clause must contain the Id or one of the following sets of columns:

  • Name_p
  • Phone_p
  • Address_p, City_p, and State_p

The cmdlet will use the SAP Concur APIs to filter by either Id or by any combination of Name_p, Address_p, Address2_p, City_p, State_p, Zip_p, Country_p, Phone_p, McCode_p, TaxId_p, MerchantType_p, MerchantID_p, IataCode_p, and Relevance_p. The cmdlet processes other filters client-side within the cmdlet.

For example, the following queries are processed server side:

SELECT * FROM Suppliers WHERE Id = 'sampleSuppliersId'
SELECT * FROM Suppliers WHERE Name_p = 'sampleName' AND Address_p = 'exampleAddress' AND Address2_p = 'exampleAddress2' AND City_p = 'exampleCity' AND State_p = 'exampleState' AND Zip_p = 'exampleZip' AND Country_p = 'exampleCountry' AND Phone_p = '123456789' AND McCode_p = 'exampleMcCode' AND TaxId_p = 'exampleTaxId' AND MerchantType_p = 'Visa' AND MerchantID_p = 'exampleMerchantID' AND IataCode_p = 'code' AND Relevance_p = 5


Name Type References Description
ID [KEY] String The unique identifier of the resource.
AmadeusId String Amadeus Id
CreditCardVendorId String Creditcard Vendor Id
GalileoId String Galileo Id
NorthstarId String Northstar Id
PegasusId String Pegasus Id
SabreId String Sabre Id
TaxId String Tax Id
WorldspanId String Worldspan Id
AustinTetra String Austin Tetra
BusinessName String Name
ChainCode String Chain Code
ChainName String Chain Name
City String City
CountryCode String Country Code
DunsNumber String Duns Number
Email String Email
Fax String Fax
MccCode String MCC Code (Ex: Delta Airline - 3058)
Phone String Phone
PostalCode String Zip
PrimaryNaics String Primary Naics Code
PrimarySic String Primary Sic Code
PropertyCode String undefined:ConnectSwaggerDocs-SUP_PARAM_PROPERTY_CODE
SecondaryNaics String Secondary Naics Code
SecondarySic String Secondary Sic Code
State String State
StreetAddress String Address
StreetAddress2 String Address2
TollFree String Toll Free
URI String The URI to the resource.
WebUrl String Web Address


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IataCode_p String IATA Code
MerchantType_p String Merchant Type Code(Ex: Visa - VI, Amex - AX)
MerchantID_p String Merchant Id
Zip_p String Zip
Relevance_p String Relevance of the Search results
Name_p String Name
Address_p String Address
McCode_p String MCC Code (Ex: Delta Airline - 3058)
TaxId_p String Tax Id
Address2_p String Address
Country_p String Country Code

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839