UFN_RE7INTEGRATION_GETPHONES_FROMXML
Returns a table of phone information from an XML list of phones supplied by RE7 Integration.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PHONES | xml | IN |
Definition
Copy
CREATE function dbo.UFN_RE7INTEGRATION_GETPHONES_FROMXML(
@PHONES xml
) returns table
as
return
(
select
T.c.value('(RE7PHONEID)[1]','int') as RE7PHONEID,
T.c.value('(PHONETYPE)[1]','nvarchar(100)') as PHONETYPE,
T.c.value('(NUMBER)[1]','nvarchar(100)') as NUMBER,
T.c.value('(DONOTCALL)[1]','bit') as DONOTCALL,
T.c.value('(ISPRIMARY)[1]','bit') as ISPRIMARY
from
@PHONES.nodes('/PHONES/ITEM') T(c)
);