GET api/Provider?lname={lname}

Looks up a specific provider by last name

Request Information

URI Parameters

Name	Description	Type	Additional information
lname	The Last Name of the provider	string	Required

Body Parameters

None.

Response Information

Resource Description

V_SelectAllProviders

Name	Type	Additional information
ID	integer	None.
SiteID	integer	None.
Username	string	None.
LName	string	None.
MName	string	None.
FName	string	None.
FullName	string	None.
MisSpelled	string	None.
Address	string	None.
Address2	string	None.
City	string	None.
State	string	None.
Postal	string	None.
Ctry	string	None.
Company	string	None.
CompanyNRO	string	None.
WorkRelationship	string	None.
WorkAddress	string	None.
WorkAddress2	string	None.
WorkCity	string	None.
WorkState	string	None.
WorkPostal	string	None.
WorkCtry	string	None.
IsOwner	boolean	None.
OwnerName	string	None.
OwnerEmail	string	None.
ShipTo	string	None.
ShipAddress	string	None.
ShipAddress2	string	None.
ShipCity	string	None.
ShipState	string	None.
ShipPostal	string	None.
ShipCtry	string	None.
HomePhone	string	None.
WorkPhone	string	None.
CellPhone	string	None.
SMSAssigned	boolean	None.
SMSUpdated	boolean	None.
SMSCancelled	boolean	None.
Fax	string	None.
EMail	string	None.
Notes	string	None.
SubmittedDate	date	None.
RevisedDate	date	None.
ProUpdateDate	date	None.
Active	boolean	None.
DeactivateDate	date	None.
DeactivateReason	integer	None.
DeactivateOther	string	None.
AddressChanged	boolean	None.
W9Filed	boolean	None.
W9Sent	boolean	None.
W9LastSentDate	date	None.
BankInfoSent	boolean	None.
BankInfoLastSentDate	date	None.
BankInfoFiled	boolean	None.
AgreementSent	boolean	None.
AgreementLastSentDate	date	None.
AgreementFiled	boolean	None.
RCCID	integer	None.
VendorID	string	None.
CandidateID	string	None.
PONum	string	None.
LastLoginDate	date	None.
LoginCount	integer	None.
ImgArrayID1	integer	None.
ImgApproved	boolean	None.
Lat	string	None.
Lng	string	None.
TaxID	string	None.
TaxRules	string	None.
HalfDayRate	decimal number	None.
DayRate	decimal number	None.
ShowRate	decimal number	None.
HalfShowRate	decimal number	None.
ERRate	decimal number	None.
ERTravelRate	decimal number	None.
PerDiem	string	None.
PerDiemBkfast	decimal number	None.
PerDiemLunch	decimal number	None.
PerDiemDinner	decimal number	None.
SupportCategory	string	None.
SupCatID	integer	None.
AcctNum	string	None.
Title	string	None.
Region	string	None.
ManagerID	integer	None.
Division	string	None.
TravelRate	decimal number	None.
Mileage	decimal number	None.
LicNum	string	None.
LicState	string	None.
LicExp	date	None.
OrigContractDate	string	None.
CountryCd	integer	None.
SurveyUserID	integer	None.
District	string	None.
Territory	string	None.
ProStatusID	integer	None.
RosterComments	string	None.
HoldStatus	string	None.
Gender	string	None.
RenewalApproved	boolean	None.
InstagramHandle	string	None.
TikTokHandle	string	None.
FacebookHandle	string	None.
TwitterHandle	string	None.
AlertLastSent	date	None.
EventFeaturedArtist	boolean	None.
SupportCode	string	None.
IsFullTime	boolean	None.
Expr4	integer	None.
RoleGroup	string	None.

Response Formats

application/json, text/json

Sample:

{
  "ID": 1,
  "SiteID": 2,
  "Username": "sample string 3",
  "LName": "sample string 4",
  "MName": "sample string 5",
  "FName": "sample string 6",
  "FullName": "sample string 7",
  "MisSpelled": "sample string 8",
  "Address": "sample string 9",
  "Address2": "sample string 10",
  "City": "sample string 11",
  "State": "sample string 12",
  "Postal": "sample string 13",
  "Ctry": "sample string 14",
  "Company": "sample string 15",
  "CompanyNRO": "sample string 16",
  "WorkRelationship": "sample string 17",
  "WorkAddress": "sample string 18",
  "WorkAddress2": "sample string 19",
  "WorkCity": "sample string 20",
  "WorkState": "sample string 21",
  "WorkPostal": "sample string 22",
  "WorkCtry": "sample string 23",
  "IsOwner": true,
  "OwnerName": "sample string 25",
  "OwnerEmail": "sample string 26",
  "ShipTo": "sample string 27",
  "ShipAddress": "sample string 28",
  "ShipAddress2": "sample string 29",
  "ShipCity": "sample string 30",
  "ShipState": "sample string 31",
  "ShipPostal": "sample string 32",
  "ShipCtry": "sample string 33",
  "HomePhone": "sample string 34",
  "WorkPhone": "sample string 35",
  "CellPhone": "sample string 36",
  "SMSAssigned": true,
  "SMSUpdated": true,
  "SMSCancelled": true,
  "Fax": "sample string 40",
  "EMail": "sample string 41",
  "Notes": "sample string 42",
  "SubmittedDate": "2026-09-22T13:06:00.6882004-07:00",
  "RevisedDate": "2026-09-22T13:06:00.6882004-07:00",
  "ProUpdateDate": "2026-09-22T13:06:00.6882004-07:00",
  "Active": true,
  "DeactivateDate": "2026-09-22T13:06:00.6882004-07:00",
  "DeactivateReason": 1,
  "DeactivateOther": "sample string 46",
  "AddressChanged": true,
  "W9Filed": true,
  "W9Sent": true,
  "W9LastSentDate": "2026-09-22T13:06:00.6882004-07:00",
  "BankInfoSent": true,
  "BankInfoLastSentDate": "2026-09-22T13:06:00.6882004-07:00",
  "BankInfoFiled": true,
  "AgreementSent": true,
  "AgreementLastSentDate": "2026-09-22T13:06:00.6882004-07:00",
  "AgreementFiled": true,
  "RCCID": 54,
  "VendorID": "sample string 55",
  "CandidateID": "sample string 56",
  "PONum": "sample string 57",
  "LastLoginDate": "2026-09-22T13:06:00.6882004-07:00",
  "LoginCount": 1,
  "ImgArrayID1": 58,
  "ImgApproved": true,
  "Lat": "sample string 60",
  "Lng": "sample string 61",
  "TaxID": "sample string 62",
  "TaxRules": "sample string 63",
  "HalfDayRate": 64.0,
  "DayRate": 65.0,
  "ShowRate": 66.0,
  "HalfShowRate": 67.0,
  "ERRate": 68.0,
  "ERTravelRate": 69.0,
  "PerDiem": "sample string 70",
  "PerDiemBkfast": 1.0,
  "PerDiemLunch": 1.0,
  "PerDiemDinner": 1.0,
  "SupportCategory": "sample string 71",
  "SupCatID": 72,
  "AcctNum": "sample string 73",
  "Title": "sample string 74",
  "Region": "sample string 75",
  "ManagerID": 76,
  "Division": "sample string 77",
  "TravelRate": 78.0,
  "Mileage": 79.0,
  "LicNum": "sample string 80",
  "LicState": "sample string 81",
  "LicExp": "2026-09-22T13:06:00.6882004-07:00",
  "OrigContractDate": "sample string 82",
  "CountryCd": 83,
  "SurveyUserID": 84,
  "District": "sample string 85",
  "Territory": "sample string 86",
  "ProStatusID": 87,
  "RosterComments": "sample string 88",
  "HoldStatus": "sample string 89",
  "Gender": "sample string 90",
  "RenewalApproved": true,
  "InstagramHandle": "sample string 92",
  "TikTokHandle": "sample string 93",
  "FacebookHandle": "sample string 94",
  "TwitterHandle": "sample string 95",
  "AlertLastSent": "2026-09-22T13:06:00.6882004-07:00",
  "EventFeaturedArtist": true,
  "SupportCode": "sample string 97",
  "IsFullTime": true,
  "Expr4": 99,
  "RoleGroup": "sample string 100"
}

application/xml, text/xml

Sample:

<V_SelectAllProviders xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ElabDataAccess">
  <AcctNum>sample string 73</AcctNum>
  <Active>true</Active>
  <Address>sample string 9</Address>
  <Address2>sample string 10</Address2>
  <AddressChanged>true</AddressChanged>
  <AgreementFiled>true</AgreementFiled>
  <AgreementLastSentDate>2026-09-22T13:06:00.6882004-07:00</AgreementLastSentDate>
  <AgreementSent>true</AgreementSent>
  <AlertLastSent>2026-09-22T13:06:00.6882004-07:00</AlertLastSent>
  <BankInfoFiled>true</BankInfoFiled>
  <BankInfoLastSentDate>2026-09-22T13:06:00.6882004-07:00</BankInfoLastSentDate>
  <BankInfoSent>true</BankInfoSent>
  <CandidateID>sample string 56</CandidateID>
  <CellPhone>sample string 36</CellPhone>
  <City>sample string 11</City>
  <Company>sample string 15</Company>
  <CompanyNRO>sample string 16</CompanyNRO>
  <CountryCd>83</CountryCd>
  <Ctry>sample string 14</Ctry>
  <DayRate>65</DayRate>
  <DeactivateDate>2026-09-22T13:06:00.6882004-07:00</DeactivateDate>
  <DeactivateOther>sample string 46</DeactivateOther>
  <DeactivateReason>1</DeactivateReason>
  <District>sample string 85</District>
  <Division>sample string 77</Division>
  <EMail>sample string 41</EMail>
  <ERRate>68</ERRate>
  <ERTravelRate>69</ERTravelRate>
  <EventFeaturedArtist>true</EventFeaturedArtist>
  <Expr4>99</Expr4>
  <FName>sample string 6</FName>
  <FacebookHandle>sample string 94</FacebookHandle>
  <Fax>sample string 40</Fax>
  <FullName>sample string 7</FullName>
  <Gender>sample string 90</Gender>
  <HalfDayRate>64</HalfDayRate>
  <HalfShowRate>67</HalfShowRate>
  <HoldStatus>sample string 89</HoldStatus>
  <HomePhone>sample string 34</HomePhone>
  <ID>1</ID>
  <ImgApproved>true</ImgApproved>
  <ImgArrayID1>58</ImgArrayID1>
  <InstagramHandle>sample string 92</InstagramHandle>
  <IsFullTime>true</IsFullTime>
  <IsOwner>true</IsOwner>
  <LName>sample string 4</LName>
  <LastLoginDate>2026-09-22T13:06:00.6882004-07:00</LastLoginDate>
  <Lat>sample string 60</Lat>
  <LicExp>2026-09-22T13:06:00.6882004-07:00</LicExp>
  <LicNum>sample string 80</LicNum>
  <LicState>sample string 81</LicState>
  <Lng>sample string 61</Lng>
  <LoginCount>1</LoginCount>
  <MName>sample string 5</MName>
  <ManagerID>76</ManagerID>
  <Mileage>79</Mileage>
  <MisSpelled>sample string 8</MisSpelled>
  <Notes>sample string 42</Notes>
  <OrigContractDate>sample string 82</OrigContractDate>
  <OwnerEmail>sample string 26</OwnerEmail>
  <OwnerName>sample string 25</OwnerName>
  <PONum>sample string 57</PONum>
  <PerDiem>sample string 70</PerDiem>
  <PerDiemBkfast>1</PerDiemBkfast>
  <PerDiemDinner>1</PerDiemDinner>
  <PerDiemLunch>1</PerDiemLunch>
  <Postal>sample string 13</Postal>
  <ProStatusID>87</ProStatusID>
  <ProUpdateDate>2026-09-22T13:06:00.6882004-07:00</ProUpdateDate>
  <RCCID>54</RCCID>
  <Region>sample string 75</Region>
  <RenewalApproved>true</RenewalApproved>
  <RevisedDate>2026-09-22T13:06:00.6882004-07:00</RevisedDate>
  <RoleGroup>sample string 100</RoleGroup>
  <RosterComments>sample string 88</RosterComments>
  <SMSAssigned>true</SMSAssigned>
  <SMSCancelled>true</SMSCancelled>
  <SMSUpdated>true</SMSUpdated>
  <ShipAddress>sample string 28</ShipAddress>
  <ShipAddress2>sample string 29</ShipAddress2>
  <ShipCity>sample string 30</ShipCity>
  <ShipCtry>sample string 33</ShipCtry>
  <ShipPostal>sample string 32</ShipPostal>
  <ShipState>sample string 31</ShipState>
  <ShipTo>sample string 27</ShipTo>
  <ShowRate>66</ShowRate>
  <SiteID>2</SiteID>
  <State>sample string 12</State>
  <SubmittedDate>2026-09-22T13:06:00.6882004-07:00</SubmittedDate>
  <SupCatID>72</SupCatID>
  <SupportCategory>sample string 71</SupportCategory>
  <SupportCode>sample string 97</SupportCode>
  <SurveyUserID>84</SurveyUserID>
  <TaxID>sample string 62</TaxID>
  <TaxRules>sample string 63</TaxRules>
  <Territory>sample string 86</Territory>
  <TikTokHandle>sample string 93</TikTokHandle>
  <Title>sample string 74</Title>
  <TravelRate>78</TravelRate>
  <TwitterHandle>sample string 95</TwitterHandle>
  <Username>sample string 3</Username>
  <VendorID>sample string 55</VendorID>
  <W9Filed>true</W9Filed>
  <W9LastSentDate>2026-09-22T13:06:00.6882004-07:00</W9LastSentDate>
  <W9Sent>true</W9Sent>
  <WorkAddress>sample string 18</WorkAddress>
  <WorkAddress2>sample string 19</WorkAddress2>
  <WorkCity>sample string 20</WorkCity>
  <WorkCtry>sample string 23</WorkCtry>
  <WorkPhone>sample string 35</WorkPhone>
  <WorkPostal>sample string 22</WorkPostal>
  <WorkRelationship>sample string 17</WorkRelationship>
  <WorkState>sample string 21</WorkState>
</V_SelectAllProviders>