Here is an example of the function for a simple form we use to enter weekly highlights:
CREATEFUNCTION [dbo].[ConfiGetWeeklyHighlightReport] () RETURNS @tbl TABLE ( RecordGuid NVARCHAR(32) NULL, RecordId INT NULL, Date DATE NULL, Status NVARCHAR(100) NULL, Reporter NVARCHAR(100) NULL, Description NVARCHAR(MAX) NULL, OwnedBy NVARCHAR(32) NULL, CreatedBy NVARCHAR(32) NULL, CreatedTs DATETIME NULL, IsDeleted BIT NULL ) AS BEGIN DECLARE @OffsetSecond INT = DATEPART(TZOFFSET, SYSDATETIMEOFFSET()) * 60; DECLARE @XmlData XML = ( SELECT XmlData = CAST(text_val AS XML) FROM ConfluenceStore.dbo.OS_PROPERTYENTRY WHERE entity_key = 'confiform_contentitassistWeeklyReport' AND entity_id = 39485704 -- page id ); WITH Items AS ( SELECT RecordGuid = item.value('(id/text())[1]', 'NVARCHAR(32)'), RecordId = item.value('(recordId/text())[1]', 'INT'), Date = item.value('(fields//date/text())[1]', 'NVARCHAR(32)'), Status = item.value('(fields//status/text())[1]', 'NVARCHAR(100)'), Reporter = item.value('(fields//reporter/text())[1]', 'NVARCHAR(100)'), Description = item.value('(fields//description/text())[1]', 'NVARCHAR(MAX)'), OwnedBy = item.value('(ownedBy/text())[1]', 'NVARCHAR(32)'), CreatedBy = item.value('(createdBy/text())[1]', 'NVARCHAR(32)'), CreatedTs = item.value('(created/text())[1]', 'NVARCHAR(32)'), IsDeleted = item.value('(deleted/text())[1]', 'BIT') FROM @XmlData.nodes('/list/entry') AS Requests(item) ) INSERT INTO @tbl SELECT RecordGuid, RecordId, Date = DATEADD(SECOND, (CONVERT(BIGINT, Date) / 1000) + @OffsetSecond, '1970-01-01'), Status = CASE Status WHEN 'success' THEN 'REPORTED' ELSE Status END, Reporter, Description, OwnedBy, CreatedBy, CreatedTs = DATEADD(SECOND, (CONVERT(BIGINT, CreatedTs) / 1000) + @OffsetSecond, '1970-01-01'), IsDeleted FROM Items ; RETURN END
Ohh, you better dont "integrate" on the database level.
We believe in teh same approach as Atlassian advices - use APIs and SDK, but never access your database directly.
We do have APIs for ConfiForms as well, as strongly advice to use APIs for incoming integrations and ConfiForms IFTTT macros for outgoing integrations
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.