Within <authentication/> include <clientId>2<clientId/>. This should retrieve your client record.

We are currently upgrading our XML-HTTP API from v2.9 to work with later versions of Centric. Documentation also needs to be updated along with the API!

Ananth

Also, the systemId should be 4. This maps to a table in Centric CRM that maps various object names allowed access by the client. You should also change your "code" value used above, now that others can see it here.

When working with XML documents though, the data should be encoded with a library.

ok..
I have added clientid tag to the authentication section in xml.
I have setted systemid to 4.

I have also fixed a syntax error in php code that prevents response to be read from the socket:

if ($response == )
echo "error: no response from server";
// return
} else
echo "-$response-";
}

== and not = as in your example (php specs changed, i think, but this is not important...)

by the way now i'm able to connect :-) and i receive this response:

<?xml version="1.0" encoding="UTF-8"?><aspcfs><response><status>1</status><errorText>Error: rollback() should not be called while in auto-commit mode.</errorText></response></aspcfs>

My xml envelope is:

<?xml version="1.0" encoding="utf-8"?>
<app><authentication>
<id>cms.abd.it</id>

baluba

<systemId>4</systemId>
<clientId>2</clientId>
</authentication>
<meta>
<property>id</property>
</meta>
<transaction id="1">
<ticket action="insert">
<problem>questo è un ticket</problem>
<sourceCode>123</sourceCode>
<catCode>1</catCode>
<subCat1>2</subCat1>
<subCat2>3</subCat2>
<subCat3>4</subCat3>
</ticket></transaction>
</app>

I'm concious of the need to maintain reserved the "code baluba" value for authentication :-) - i'm only playng to understand.

I suspect i'm missing something more or your documentation is definitely non complete... :-(
maybe there is some properties to set about the nature of the transaction int he transaction section??

Where i can find the full list of object and properties i can manipulate with the xml-api??

I need to experiment with creation of tickets from external application, creation of leads from web site and so on...

Thank you very much.

Lucio

Getting close then... you also need enteredBy and modifiedBy...

<transaction id="1">
<ticket action="insert">
<problem>questo è un ticket</problem>
<enteredBy>1</enteredBy>
<modifiedBy>1</modifiedBy>
</ticket>
</transaction>

Hi Mat,
I've added
<enteredBy>1</enteredBy>
<modifiedBy>1</modifiedBy>
and also i've checked that "1" is the right value in the [sync_client] table for my client record (i have only one).

So my current client authentication record is:

type: web feeder
version:1
enteredby:1
modifiedby:1
enabled:true
code:---
clientid:2

Still the response from Centric is:

<?xml version="1.0" encoding="UTF-8"?>
<aspcfs>
<response>
<status>1</status>
<errorText>Error: rollback() should not be called while in auto-commit mode.</errorText>
</response>
</aspcfs>

I use MS SQL server if this help...

I've examinated all the documentation i bought but there is no other informations about http-xml.

Thank you.

Lucio

Lucio,

<enteredby/> and <modifiedby/> value should point to a valid user in the database. Refer to the 'access' table to see if the user exists. These values DO NOT refer to your [sync_client], but to [access].

Let me know if this helps.

Ananth

>> Error: rollback() should not be called while in auto-commit mode.

Thanks, this does help since MSSQL returns this error whereas other database servers do not when dealing with multiple commit() and rollback() in a single transaction.

Maybe the Centric CRM transaction code is incorrectly changing the AutoCommit and causing this to fail under MS SQL. I will try this code using MS SQL and report back.

Ananth,
i've checked that <enteredby/> and <modifiedby/> value point to a valid user in the database. "2" is the contacID of me as a Centric user. it's a valid user, i can login and work.
Using 2 as the value for <enteredby/> and <modifiedby/> does not change anything.

Matt,
the ipotesi that Centric CRM transaction code is incorrectly changing the AutoCommit and causing this to fail under MS SQL may be a good candidate.
I will test this same code to another Centric installation using Postgress.

I will give my feedback about this test "asap".

Lucio

mmhh
I've tested the same insert in another Centric installation with postgress.

The xml envelope is:

$xmlDocument='<?xml version="1.0" encoding="utf-8"?>
<app>
<authentication>
<id>contatti.abd.it</id>

---

<systemId>4</systemId>
<clientId>2</clientId>
</authentication>
<meta>
<property>id</property>
</meta>
<transaction id="1">
<ticket action="insert">
<problem>questo essere un ticket</problem>
<enteredBy>1</enteredBy>
<modifiedBy>1</modifiedBy>
<sourceCode>123</sourceCode>
<catCode>1</catCode>
<subCat1>2</subCat1>
<subCat2>3</subCat2>
<subCat3>4</subCat3>
</ticket>
</transaction>
</app>'

Where i've created the client record, i've checked that 1 is a valid user for <enteredBy> and <modifiedBy>. The "password is ok" and so on.

The result is:

<?xml version="1.0" encoding="UTF-8"?>
<aspcfs>
<response id="1">
<status>1</status>
<errorText>Transaction failed</errorText>
</response>
</aspcfs>

more cryptic than before :-)

Lucio

Status 'Transaction Failed' indicates that authentication was successful. I guess there is something wrong with the transaction piece.

Can you verify if the following point to the corressponding tables?

<sourceCode>123</sourceCode> should refer to lookup_ticketsource (code)

<catCode>1</catCode>
<subCat1>2</subCat1>
<subCat2>3</subCat2>
<subCat3>4</subCat3>
should all refer to ticket_category(id)

<enteredBy>1</enteredBy>
<modifiedBy>1</modifiedBy>
should both refer to access(user_id)