Vision web service insert into "Activity" table.

A forum for discussing new installs or conversions from other software.
jbrekke
Posts: 1
Joined: Sat May 09, 2015 4:18 pm
Brief Company Description: Central Consulting Group
Deltek Vision Version: 7.0
Number of Employees: 38
Company Position: Software Developer
Vision Modules: Majority
Number of Offices: 0

Vision web service insert into "Activity" table.

Postby jbrekke » Sat May 09, 2015 5:59 pm

I'm attempting to insert a record into the "Activity" table of Vision by calling the "AddActivity" method via web service proxy.

However, I'm getting the following returned error message:

<DLTKVisionMessage><ReturnCode>ErrSchemaVal</ReturnCode><ReturnDesc>Schema Validation Error
Validation error on line 1 col 279[CRLF]The element 'ROW' in namespace 'http://deltek.vision.com/XMLSchema' has invalid child element 'ActivityID'.
List of possible elements expected: 'http://deltek.vision.com/XMLSchema:ActivityID'.[CRLF] ...
Continuing Validation ...
[CRLF]</ReturnDesc><Detail>Validation error on line 1 col 279[CRLF]The element 'ROW' in namespace 'http://deltek.vision.com/XMLSchema' has invalid child element
'ActivityID'. List of possible elements expected: 'http://deltek.vision.com/XMLSchema:ActivityID'.[CRLF] ...
Continuing Validation ...[CRLF]</Detail></DLTKVisionMessage>

XML passed into the "AddActivity" method:
<?xml version="1.0" encoding="utf-8"?><RECS xmlns="http://deltek.vision.com/XMLSchema" xmlns:xdv="http://deltek.vision.com/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><REC><Activity name="Activity" alias="Activity" keys="ActivityID"><ROW tranType="INSERT"><ActivityID>TESTING635667873463825</ActivityID></ROW></Activity></REC></RECS>


Has anyone else had issues with inserting data through the web service?

Thanks,

Josh

noh
Posts: 4
Joined: Tue May 19, 2015 12:17 pm
Deltek Vision Version: 7.0
Number of Employees: 0
Number of Offices: 0

Re: Vision web service insert into "Activity" table.

Postby noh » Tue May 19, 2015 1:41 pm

Hi JBrekke - Make sure that the order of your XML schema elements matches the order of columns in database table.

Let me know if you have any questions.


Return to “Vision Implementation & Integration”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest