当前位置：网站首页>Connection between Tongda OA and third-party app

Connection between Tongda OA and third-party app

2022-04-21 20:53:00 【QQ2524837118】

Single sign on authentication

Appid appkey code state The parameters are after the address

After the application obtains the parameters , call oauth Way to complete certification .

Oauth Authorization and authentication interface description ：

auth.open.XXXX.com/open/doc/list/yluywps0/zpsakobd/88c1cxll

APP Renderings of docking examples

Data synchronization

1 Basic introduction

Information synchronization may occur between different system architectures , Unequal information . So consider establishing relationships , If the personnel information is not initialized , You can consider following the access oa Synchronize personnel structure and organizational structure .

Data output

OA Push the data to the system intermediate table , The system manufacturer is responsible for maintaining data to the system library , The data items in the intermediate table shall be confirmed by both parties through negotiation

OA Standard intermediate table field information that can be provided , For reference only

Basic information of organization （ Standard construction , It can be increased or decreased according to the actual situation ）

Field name	Chinese meaning	data type	remarks
DWH	Unit number	VARCHAR2(10)
DWMC	Name of the company	VARCHAR2(60)
LSDWH	Subordinate unit no	VARCHAR2(50)
DWLBM	Unit category code	CHAR	Code
DWLBMC	Unit category name	VARCHAR2(50)	meaning

Basic user information table （ Standard construction , It can be increased or decreased according to the actual situation ）

Field name	Chinese meaning	data type	remarks
ID	ID	varchar2(50)	Primary key
GH	Job number	varchar2(50)
DWH	Unit number	varchar2(50)
SZKS	Department	varchar2(64)
XM	full name	varchar2(50)
XBM	Gender code	varchar2(50)	Code
XB	Gender	varchar2(50)	meaning
CSRQ	Date of birth	char(10)
CSDM	Place of birth code	varchar2(50)	Code
CSD	birthplace	varchar2(100)	meaning
JG	Native place	varchar2(50)	Code
JGD	Place of origin	varchar2(100)	meaning
MZM	Ethnic code	varchar2(50)	Code
MZ	nation	varchar2(100)	meaning
SFZJH	ID No	varchar2(50)
WHCD	degree of education	varchar2(50)	meaning
DQZTM	Current status code	char(5)	Code
DQZT	current state	varchar2(50)	meaning
PRZWM	Appointment code / Technical title	char(5)	Code
PRZW	Appointment position	varchar2(50)	meaning
JSZJM	Technical rank code	char(5)	Code
JSZJ	Technical rank	varchar2(50)	meaning
ZWJBM	Job level code / Administrative position	char(5)	Code
ZWJB	Job level	varchar2(50)	meaning
BYYX	University one is graduated from	varchar2(64)
YGXS	The form of employment	varchar2（10）	Code
YGXSMC	Name of employment form	varchar2(50)	meaning

Webservice The supply department , User basic data

Address of the interface

IP+syncdata.php?wsdl

department

The interface function ：

getDept()

Function description ：

Get the return value ：

Field	Parameter type	explain
deptNo	String	Department number
deptName	String	Department name
parentNo	string	Superior department No

user

The interface function ：

getUser()

Function description ： Get users

Parameters ：

Field	Parameter type	explain
userId	String	The user id
realName	String	User name
sex	String	Gender
deptId	String	Company id
type	string	Personnel status
phone	string	cell-phone number
email	String	mailbox