GET api/Salesman/GetSqlByDsn

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of SalesmanGroupModel

Name	Type	Additional information
DsnName	string	None.
Id	integer	None.
UserName	string	None.
Description	string	None.
FirstName	string	None.
LastName	string	None.
JobTitle	string	None.
Cellphone	string	None.
EmailAddress	string	None.
CompanyName	string	None.
SendMail	boolean	None.
SendMailCCs	boolean	None.
SendMailBCCs	boolean	None.
Blocked	boolean	None.
Enabled	boolean	None.
SalesmanModels	Collection of SalesmanModel	None.
Codes	Collection of string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "DsnName": "sample string 1",
    "Id": 2,
    "UserName": "sample string 3",
    "Description": "sample string 4",
    "FirstName": "sample string 5",
    "LastName": "sample string 6",
    "JobTitle": "sample string 7",
    "Cellphone": "sample string 8",
    "EmailAddress": "sample string 9",
    "CompanyName": "sample string 10",
    "SendMail": true,
    "SendMailCCs": true,
    "SendMailBCCs": true,
    "Blocked": true,
    "Enabled": true,
    "SalesmanModels": [
      {
        "DsnName": "sample string 1",
        "GroupId": 2,
        "GUID": "sample string 3",
        "Code": "sample string 4",
        "Description": "sample string 5",
        "Blocked": true,
        "Enabled": true
      },
      {
        "DsnName": "sample string 1",
        "GroupId": 2,
        "GUID": "sample string 3",
        "Code": "sample string 4",
        "Description": "sample string 5",
        "Blocked": true,
        "Enabled": true
      }
    ],
    "Codes": [
      "sample string 1",
      "sample string 2"
    ]
  },
  {
    "DsnName": "sample string 1",
    "Id": 2,
    "UserName": "sample string 3",
    "Description": "sample string 4",
    "FirstName": "sample string 5",
    "LastName": "sample string 6",
    "JobTitle": "sample string 7",
    "Cellphone": "sample string 8",
    "EmailAddress": "sample string 9",
    "CompanyName": "sample string 10",
    "SendMail": true,
    "SendMailCCs": true,
    "SendMailBCCs": true,
    "Blocked": true,
    "Enabled": true,
    "SalesmanModels": [
      {
        "DsnName": "sample string 1",
        "GroupId": 2,
        "GUID": "sample string 3",
        "Code": "sample string 4",
        "Description": "sample string 5",
        "Blocked": true,
        "Enabled": true
      },
      {
        "DsnName": "sample string 1",
        "GroupId": 2,
        "GUID": "sample string 3",
        "Code": "sample string 4",
        "Description": "sample string 5",
        "Blocked": true,
        "Enabled": true
      }
    ],
    "Codes": [
      "sample string 1",
      "sample string 2"
    ]
  }
]

application/xml, text/xml

Sample:

<ArrayOfSalesmanGroupModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PASTEL.Api.Library.Models.Sql">
  <SalesmanGroupModel>
    <Blocked>true</Blocked>
    <Cellphone>sample string 8</Cellphone>
    <Codes xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:string>sample string 1</d3p1:string>
      <d3p1:string>sample string 2</d3p1:string>
    </Codes>
    <CompanyName>sample string 10</CompanyName>
    <Description>sample string 4</Description>
    <DsnName>sample string 1</DsnName>
    <EmailAddress>sample string 9</EmailAddress>
    <Enabled>true</Enabled>
    <FirstName>sample string 5</FirstName>
    <Id>2</Id>
    <JobTitle>sample string 7</JobTitle>
    <LastName>sample string 6</LastName>
    <SalesmanModels>
      <SalesmanModel>
        <Blocked>true</Blocked>
        <Code>sample string 4</Code>
        <Description>sample string 5</Description>
        <DsnName>sample string 1</DsnName>
        <Enabled>true</Enabled>
        <GUID>sample string 3</GUID>
        <GroupId>2</GroupId>
      </SalesmanModel>
      <SalesmanModel>
        <Blocked>true</Blocked>
        <Code>sample string 4</Code>
        <Description>sample string 5</Description>
        <DsnName>sample string 1</DsnName>
        <Enabled>true</Enabled>
        <GUID>sample string 3</GUID>
        <GroupId>2</GroupId>
      </SalesmanModel>
    </SalesmanModels>
    <SendMail>true</SendMail>
    <SendMailBCCs>true</SendMailBCCs>
    <SendMailCCs>true</SendMailCCs>
    <UserName>sample string 3</UserName>
  </SalesmanGroupModel>
  <SalesmanGroupModel>
    <Blocked>true</Blocked>
    <Cellphone>sample string 8</Cellphone>
    <Codes xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:string>sample string 1</d3p1:string>
      <d3p1:string>sample string 2</d3p1:string>
    </Codes>
    <CompanyName>sample string 10</CompanyName>
    <Description>sample string 4</Description>
    <DsnName>sample string 1</DsnName>
    <EmailAddress>sample string 9</EmailAddress>
    <Enabled>true</Enabled>
    <FirstName>sample string 5</FirstName>
    <Id>2</Id>
    <JobTitle>sample string 7</JobTitle>
    <LastName>sample string 6</LastName>
    <SalesmanModels>
      <SalesmanModel>
        <Blocked>true</Blocked>
        <Code>sample string 4</Code>
        <Description>sample string 5</Description>
        <DsnName>sample string 1</DsnName>
        <Enabled>true</Enabled>
        <GUID>sample string 3</GUID>
        <GroupId>2</GroupId>
      </SalesmanModel>
      <SalesmanModel>
        <Blocked>true</Blocked>
        <Code>sample string 4</Code>
        <Description>sample string 5</Description>
        <DsnName>sample string 1</DsnName>
        <Enabled>true</Enabled>
        <GUID>sample string 3</GUID>
        <GroupId>2</GroupId>
      </SalesmanModel>
    </SalesmanModels>
    <SendMail>true</SendMail>
    <SendMailBCCs>true</SendMailBCCs>
    <SendMailCCs>true</SendMailCCs>
    <UserName>sample string 3</UserName>
  </SalesmanGroupModel>
</ArrayOfSalesmanGroupModel>