SOAP API not able to connect to SAAS

[PremRajani]

Hi,

If using REST API, able to connect to SAAS API. But when I use SOAP API it doesn't connect. The reason I'm using SOAP API is availability of searchrecordsbyreport and bulk update. Do we have the same features in REST API, then can someone please share the latest documentation.

Thanks,

Prem

[PremRajani]

Hi David,

Attach is the response from debug mode and hope it helps. Not getting any information at all.

Thanks,

Prem

[DavidPetty · Accepted solution]

Sorry Perm, that doesn't help at all...

When you make a call to general.asmx, what is the SOAP body you are sending it?

It should look something like this:

<?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>
          <CreateUserSessionFromInstance xmlns="http://archer-tech.com/webservices/">
               <userName>string</userName>
               <instanceName>string</instanceName>
               <password>string</password>
          </CreateUserSessionFromInstance>
     </soap:Body>
</soap:Envelope>

[PremRajani]

Hi David,

Since it was within network on-prem, just calling the function as it is worked. But now moving to SAAS was causing the problem. Changed it to above format and works without any issues. Learning pros/cons as we move to SAAS

Thanks,

Prem

[valeriacinelli]

Hi David,

i have the same issue and may POST Request is:

<?xml version="1.0" encoding="utf-8"?>' + '<soap:Envelope ' + 'xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance" ' +'xmlns:xsd="http://www.w3.org/2001/XMLSchema" ' + 'xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">' + '<soap:Body>' + '<ExecuteSearch xmlns="http://archer-tech.com/webservices/">' + '<sessionToken>' + sessionToken + '</sessionToken>' + '<searchOptions>' + '<![CDATA[' + '<SearchReport>' + '<PageSize>'+ "250" + '</PageSize>' + '<DisplayFields>' + '<DisplayField name="ID">' + "29484" + '</DisplayField>' + '</DisplayFields>' + '<Criteria>' + '<Filter>' + '<Conditions>' + '<TextFilterCondition>'+ '<Operator>' + "Equals" + '</Operator>' + '<Field>' + "29484" + '</Field>' + '<Value>' + "string" + '</Value>' + '</TextFilterCondition>' + '</Conditions>' + '</Filter>' + '<ModuleCriteria>' + '<Module name="Controls">' + "624"+ '</Module>' + '</ModuleCriteria>' + '</Criteria>' + '</SearchReport>' + ']]>' + '</searchOptions>' + '<pageNumber>' + "1" + '</pageNumber>' + '</ExecuteSearch>' + '</soap:Body>' + '</soap:Envelope>

[DavidPetty]

There shouldn't be double quotes around any values.  The <DisplayField> should not have any attributes like you have.

[valeriacinelli]

Thank You, I try it but i have the same problem

'<?xml version="1.0" encoding="utf-8"?>' + '<soap:Envelope ' + 'xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance" ' +'xmlns:xsd="http://www.w3.org/2001/XMLSchema" ' + 'xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">' + '<soap:Body>' + '<ExecuteSearch xmlns="http://archer-tech.com/webservices/">' + '<sessionToken>' + sessionToken + '</sessionToken>' + '<searchOptions>' + '<![CDATA[' + '<SearchReport>' + '<PageSize>'+ 250 + '</PageSize>' + '<DisplayFields>' + '<DisplayField>' + 29484 + '</DisplayField>' + '</DisplayFields>' + '<Criteria>' + '<Filter>' + '<Conditions>' + '<TextFilterCondition>'+ '<Operator>' + 'Equals' + '</Operator>' + '<Field>' + 29484 + '</Field>' + '<Value>' + '00001_01' + '</Value>' + '</TextFilterCondition>' + '</Conditions>' + '</Filter>' + '<ModuleCriteria>' + '<Module name="Controls">' + 624+ '</Module>' + '</ModuleCriteria>' + '</Criteria>' + '</SearchReport>' + ']]>' + '</searchOptions>' + '<pageNumber>' + 1 + '</pageNumber>' + '</ExecuteSearch>' + '</soap:Body>' + '</soap:Envelope>'

[DavidPetty]

What's the actual error coming back from Archer?

Also, you have an attribute for <Module> when there shouldn't be one.

[valeriacinelli]

I update the soap '<?xml version="1.0" encoding="utf-8"?>' + '<soap:Envelope ' + 'xmlns:xsi="http://www.w3.org/2001/XMLSchemainstance" ' +'xmlns:xsd="http://www.w3.org/2001/XMLSchema" ' + 'xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">' + '<soap:Body>' + '<ExecuteSearch xmlns="http://archer-tech.com/webservices/">' + '<sessionToken>' + sessionToken + '</sessionToken>' + '<searchOptions>' + '<![CDATA[' + '<SearchReport>' + '<PageSize>'+ 250 + '</PageSize>' + '<DisplayFields>' + '<DisplayField>' + 29484 + '</DisplayField>' + '</DisplayFields>' + '<Criteria>' + '<Filter>' + '<Conditions>' + '<TextFilterCondition>'+ '<Operator>' + 'Equals' + '</Operator>' + '<Field>' + 29484 + '</Field>' + '<Value>' + '00001_01_MISURAPRO_01' + '</Value>' + '</TextFilterCondition>' + '</Conditions>' + '</Filter>' + '<ModuleCriteria>' + '<Module>' + 624+ '</Module>' + '</ModuleCriteria>' + '</Criteria>' + '</SearchReport>' + ']]>' + '</searchOptions>' + '<pageNumber>' + 1 + '</pageNumber>' + '</ExecuteSearch>' + '</soap:Body>' + '</soap:Envelope>'

The error is 

{
"readyState": 4,
"responseText": "<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><soap:Fault><soap:Code><soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:lang=\"en\">Server was unable to process request. ---&gt; Root element is missing.</soap:Text></soap:Reason><soap:Detail /></soap:Fault></soap:Body></soap:Envelope>",
"responseXML": {
"location": null
},
"status": 500,
"statusText": "error"
}

soap:Receiver

[DavidPetty]

Hmm, it's complaining that there's a 'Root element is missing'.  The XML looks good now and not sure what missing.

This is a sample I have in Postman:

<?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>
		<ExecuteSearch xmlns="http://archer-tech.com/webservices/">
		    <sessionToken>{{sessionToken}}</sessionToken>
		    <searchOptions>
		        <![CDATA[
		            <SearchReport>
		                <PageSize>20</PageSize>
		                <MaxRecordCount>100</MaxRecordCount>
		                <ShowStatSummaries>false</ShowStatSummaries>
		                    <DisplayFields>
		                        <DisplayField>24931</DisplayField>
		                        <DisplayField>24947</DisplayField>
		                        <DisplayField>27489</DisplayField>
			                </DisplayFields>
		                    <Criteria>
		                        <ModuleCriteria>
				                    <Module>574</Module>
			                    	<IsKeywordModule>true</IsKeywordModule>
		                        </ModuleCriteria>
		                        <Filter>
			                          <Conditions>
		                                <TextFilterCondition>
			                                <Operator>Equals</Operator>
		                                    <Field>24945</Field>
		                                    <Value>9285856</Value>
		                                </TextFilterCondition>
		                            </Conditions>
			                    </Filter>
		                    </Criteria>
		                </SearchReport>
		            ]]>
		    </searchOptions>
		    <pageNumber>1</pageNumber>
		</ExecuteSearch>
	</soap:Body>
</soap:Envelope>