DbService Web Service

DbService

Click here for a complete list of operations.

Maga_Read

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /dbservice.asmx HTTP/1.1
Host: www.fborghi.it
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://tempuri.org/Maga_Read"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <Maga_Read xmlns="http://tempuri.org/">
      <iLoginData>
        <SecurKey>string</SecurKey>
        <CompanyName>string</CompanyName>
        <PathDatabase>string</PathDatabase>
        <Application_Config>string</Application_Config>
        <Application_DBName>string</Application_DBName>
        <Application_DBConnString>string</Application_DBConnString>
        <UserName>string</UserName>
        <UserProfile>string</UserProfile>
        <UserIsAdmin>boolean</UserIsAdmin>
        <Culture>string</Culture>
        <ReturnMessage>string</ReturnMessage>
      </iLoginData>
      <Codice>string</Codice>
      <LoadDetails>boolean</LoadDetails>
      <LoadPrices>boolean</LoadPrices>
      <LoadGiacenzeValore>boolean</LoadGiacenzeValore>
    </Maga_Read>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <Maga_ReadResponse xmlns="http://tempuri.org/">
      <Maga_ReadResult>
        <Codice>string</Codice>
        <Descri>string</Descri>
        <DesAgg>string</DesAgg>
        <CodBar>string</CodBar>
        <Famiglia>string</Famiglia>
        <Categ>string</Categ>
        <UnMis1>string</UnMis1>
        <IVA>float</IVA>
        <Esenz>string</Esenz>
        <Forn>string</Forn>
        <TipoArt>string</TipoArt>
        <TipoImballo>string</TipoImballo>
        <LOTTOMIN>float</LOTTOMIN>
        <PESOUNIT>float</PESOUNIT>
        <QTAMIN_FATTURABILE>float</QTAMIN_FATTURABILE>
        <Reparto>string</Reparto>
        <GIACMIN>float</GIACMIN>
        <GG_PRODUZIONE>int</GG_PRODUZIONE>
        <Ubicazione>string</Ubicazione>
        <Jolly>
          <J1>string</J1>
          <J2>string</J2>
          <J3>string</J3>
          <J4>string</J4>
          <J5>string</J5>
          <J6>string</J6>
          <J7>string</J7>
          <J8>string</J8>
          <J9>string</J9>
          <J10>string</J10>
        </Jolly>
        <NOTE>string</NOTE>
        <Costo>double</Costo>
        <aDistintaBases>
          <Maga_DistintaBase>
            <CodFiglio>string</CodFiglio>
            <Descri>string</Descri>
            <Note>string</Note>
            <Qta>float</Qta>
            <PosDis>string</PosDis>
            <NoMovMagComp>boolean</NoMovMagComp>
          </Maga_DistintaBase>
          <Maga_DistintaBase>
            <CodFiglio>string</CodFiglio>
            <Descri>string</Descri>
            <Note>string</Note>
            <Qta>float</Qta>
            <PosDis>string</PosDis>
            <NoMovMagComp>boolean</NoMovMagComp>
          </Maga_DistintaBase>
        </aDistintaBases>
        <aCicliLavoraziones>
          <Maga_CicliLavorazione>
            <Variante>string</Variante>
            <Variante_Desc>string</Variante_Desc>
            <CDL>string</CDL>
            <CDL_Desc>string</CDL_Desc>
            <TipoCalc>int</TipoCalc>
            <TLav>float</TLav>
            <Costo>double</Costo>
            <PPROD_Terzista>string</PPROD_Terzista>
            <ggProdCiclo>int</ggProdCiclo>
          </Maga_CicliLavorazione>
          <Maga_CicliLavorazione>
            <Variante>string</Variante>
            <Variante_Desc>string</Variante_Desc>
            <CDL>string</CDL>
            <CDL_Desc>string</CDL_Desc>
            <TipoCalc>int</TipoCalc>
            <TLav>float</TLav>
            <Costo>double</Costo>
            <PPROD_Terzista>string</PPROD_Terzista>
            <ggProdCiclo>int</ggProdCiclo>
          </Maga_CicliLavorazione>
        </aCicliLavoraziones>
        <PrezzoAcquisto>
          <Prezzo>double</Prezzo>
          <Sc1>float</Sc1>
          <Sc2>float</Sc2>
          <Sc3>float</Sc3>
          <ProvvAg>float</ProvvAg>
          <ImpProvvAg>double</ImpProvvAg>
          <ProvvSub>float</ProvvSub>
          <ImpProvvSub>double</ImpProvvSub>
          <DesAgg>string</DesAgg>
        </PrezzoAcquisto>
        <PrezzoVendita>
          <Prezzo>double</Prezzo>
          <Sc1>float</Sc1>
          <Sc2>float</Sc2>
          <Sc3>float</Sc3>
          <ProvvAg>float</ProvvAg>
          <ImpProvvAg>double</ImpProvvAg>
          <ProvvSub>float</ProvvSub>
          <ImpProvvSub>double</ImpProvvSub>
          <DesAgg>string</DesAgg>
        </PrezzoVendita>
        <QtaDispo>double</QtaDispo>
        <QtaCar>double</QtaCar>
        <QtaScar>double</QtaScar>
        <Valore>double</Valore>
        <ReturnMessage>string</ReturnMessage>
      </Maga_ReadResult>
    </Maga_ReadResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /dbservice.asmx HTTP/1.1
Host: www.fborghi.it
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <Maga_Read xmlns="http://tempuri.org/">
      <iLoginData>
        <SecurKey>string</SecurKey>
        <CompanyName>string</CompanyName>
        <PathDatabase>string</PathDatabase>
        <Application_Config>string</Application_Config>
        <Application_DBName>string</Application_DBName>
        <Application_DBConnString>string</Application_DBConnString>
        <UserName>string</UserName>
        <UserProfile>string</UserProfile>
        <UserIsAdmin>boolean</UserIsAdmin>
        <Culture>string</Culture>
        <ReturnMessage>string</ReturnMessage>
      </iLoginData>
      <Codice>string</Codice>
      <LoadDetails>boolean</LoadDetails>
      <LoadPrices>boolean</LoadPrices>
      <LoadGiacenzeValore>boolean</LoadGiacenzeValore>
    </Maga_Read>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <Maga_ReadResponse xmlns="http://tempuri.org/">
      <Maga_ReadResult>
        <Codice>string</Codice>
        <Descri>string</Descri>
        <DesAgg>string</DesAgg>
        <CodBar>string</CodBar>
        <Famiglia>string</Famiglia>
        <Categ>string</Categ>
        <UnMis1>string</UnMis1>
        <IVA>float</IVA>
        <Esenz>string</Esenz>
        <Forn>string</Forn>
        <TipoArt>string</TipoArt>
        <TipoImballo>string</TipoImballo>
        <LOTTOMIN>float</LOTTOMIN>
        <PESOUNIT>float</PESOUNIT>
        <QTAMIN_FATTURABILE>float</QTAMIN_FATTURABILE>
        <Reparto>string</Reparto>
        <GIACMIN>float</GIACMIN>
        <GG_PRODUZIONE>int</GG_PRODUZIONE>
        <Ubicazione>string</Ubicazione>
        <Jolly>
          <J1>string</J1>
          <J2>string</J2>
          <J3>string</J3>
          <J4>string</J4>
          <J5>string</J5>
          <J6>string</J6>
          <J7>string</J7>
          <J8>string</J8>
          <J9>string</J9>
          <J10>string</J10>
        </Jolly>
        <NOTE>string</NOTE>
        <Costo>double</Costo>
        <aDistintaBases>
          <Maga_DistintaBase>
            <CodFiglio>string</CodFiglio>
            <Descri>string</Descri>
            <Note>string</Note>
            <Qta>float</Qta>
            <PosDis>string</PosDis>
            <NoMovMagComp>boolean</NoMovMagComp>
          </Maga_DistintaBase>
          <Maga_DistintaBase>
            <CodFiglio>string</CodFiglio>
            <Descri>string</Descri>
            <Note>string</Note>
            <Qta>float</Qta>
            <PosDis>string</PosDis>
            <NoMovMagComp>boolean</NoMovMagComp>
          </Maga_DistintaBase>
        </aDistintaBases>
        <aCicliLavoraziones>
          <Maga_CicliLavorazione>
            <Variante>string</Variante>
            <Variante_Desc>string</Variante_Desc>
            <CDL>string</CDL>
            <CDL_Desc>string</CDL_Desc>
            <TipoCalc>int</TipoCalc>
            <TLav>float</TLav>
            <Costo>double</Costo>
            <PPROD_Terzista>string</PPROD_Terzista>
            <ggProdCiclo>int</ggProdCiclo>
          </Maga_CicliLavorazione>
          <Maga_CicliLavorazione>
            <Variante>string</Variante>
            <Variante_Desc>string</Variante_Desc>
            <CDL>string</CDL>
            <CDL_Desc>string</CDL_Desc>
            <TipoCalc>int</TipoCalc>
            <TLav>float</TLav>
            <Costo>double</Costo>
            <PPROD_Terzista>string</PPROD_Terzista>
            <ggProdCiclo>int</ggProdCiclo>
          </Maga_CicliLavorazione>
        </aCicliLavoraziones>
        <PrezzoAcquisto>
          <Prezzo>double</Prezzo>
          <Sc1>float</Sc1>
          <Sc2>float</Sc2>
          <Sc3>float</Sc3>
          <ProvvAg>float</ProvvAg>
          <ImpProvvAg>double</ImpProvvAg>
          <ProvvSub>float</ProvvSub>
          <ImpProvvSub>double</ImpProvvSub>
          <DesAgg>string</DesAgg>
        </PrezzoAcquisto>
        <PrezzoVendita>
          <Prezzo>double</Prezzo>
          <Sc1>float</Sc1>
          <Sc2>float</Sc2>
          <Sc3>float</Sc3>
          <ProvvAg>float</ProvvAg>
          <ImpProvvAg>double</ImpProvvAg>
          <ProvvSub>float</ProvvSub>
          <ImpProvvSub>double</ImpProvvSub>
          <DesAgg>string</DesAgg>
        </PrezzoVendita>
        <QtaDispo>double</QtaDispo>
        <QtaCar>double</QtaCar>
        <QtaScar>double</QtaScar>
        <Valore>double</Valore>
        <ReturnMessage>string</ReturnMessage>
      </Maga_ReadResult>
    </Maga_ReadResponse>
  </soap12:Body>
</soap12:Envelope>