Hello

Im trying to fetch information through the Rest API but im havving trouble

the XML

    <API version="1.0">  
            <citype>
                  <name>Database Server</name>
                  <criterias>
                  <criteria>
                        <parameter>
                              <name compOperator="IS">Asset State</name>
                              <value>In Store</value>
                        </parameter>
                  </criteria>
                  </criterias>
             <returnFields>
                  <name>*</name>

            </returnFields>
            <sortFields sortOrder="desc">
                  <name>Product Name</name>
            </sortFields>
       </citype>

    </API>           

Gives me the result

3001       Unknown error. SQL Syntax Error : Incorrect syntax near ')'

  While the XML

    <API version="1.0">  
            <citype>
                  <name>Workstation</name>
                  <criterias>
                  <criteria>
                        <parameter>
                              <name compOperator="IS">Asset State</name>
                              <value>In Store</value>
                        </parameter>
                  </criteria>
                  </criterias>
             <returnFields>
                  <name>*</name>

            </returnFields>
            <sortFields sortOrder="desc">
                  <name>Product Name</name>
            </sortFields>
       </citype>

    </API>

Gives me a success back and I can view the information. The only diffrent is the CI Type.

I also wondering how I through rest API can fetch what department or user a asset  is assigned to.

                                 

Best regards Peter Samuelsson Sodra Skogsagarna