{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "PostItem"
},
"parameters": {
"dataset": "https://company.sharepoint.com/sites/SPDQCReview",
"table": "1efc55ab-7a2c-4623-8292-5d7e257e71b5",
"item/Title": "Employee Name",
"item/Re": "RFP_140577/140578_Qvidian_MKB",
"item/AssignedQCer": "join(triggerOutputs()?['body/AssignedQCer'], ', ')",
"item/QCerNeeded/Value": "US Needed",
"item/ProjectDueDate": "2025-03-07",
"item/ClientName": "Invirsa",
"item/BC_x0023__x0028_s_x0029_": "140577/140578",
"item/TypeofOpportunity/Value": "RFP",
"item/Swimlane/Value": "Advanced",
"item/Brand/Value": "COMPANY",
"item/QCStartDate": "2025-03-07",
"item/QCStartTime": "10 AM EST",
"item/QCCompletionDate": "2025-03-07",
"item/QCCompletionTime": "2 PM EST",
"item/DocumentstoQC": "join(triggerOutputs()?['body/DocumentsToQC'], ', ')",
"item/EstimatedLevelofEffort/Value": "3",
"item/EstimatedNumberofQCers/Value": "1",
"item/Notes": "n/a",
"item/QCReview": false
}
And Outputs:
"statusCode": 201,
"headers": {
"Cache-Control": "max-age=0, private",
"Vary": "Origin",
"X-NetworkStatistics": "4294967295,4294967295,4294967295,4294967295,4294967295,4294967295,4294967295,4294967295",
"X-SharePointHealthScore": "0",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "305",
"IsOCDI": "0",
"X-DataBoundary": "NONE",
"X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"SPRequestGuid": "6841efee-cca0-4b25-82c1-a3d06388e19a",
"request-id": "6841efee-cca0-4b25-82c1-a3d06388e19a",
"MS-CV": "oYhDT0DQAIAhFlmuIr5jlA.0",
"Alt-Svc": "h3=\":443\"",
"Strict-Transport-Security": "max-age=31536000",
"X-Frame-Options": "SAMEORIGIN",
"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com *.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com m365.cloud.microsoft *.cloud.microsoft *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
"MicrosoftSharePointTeamServices": "16.0.0.25812",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"x-ms-environment-id": "default-b67d722d-aa8a-4777-a169-ebeb7a6a3b67",
"x-ms-tenant-id": "b67d722d-aa8a-4777-a169-ebeb7a6a3b67",
"x-ms-dlp-re": "-|-",
"x-ms-dlp-gu": "-|-",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Fri, 07 Mar 2025 19:14:48 GMT",
"Content-Length": "3548",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Thu, 20 Feb 2025 19:14:48 GMT",
"Last-Modified": "Fri, 07 Mar 2025 19:14:48 GMT"
},
"body": {
"@odata.etag": "\"1\"",
"ItemInternalId": "112",
"ID": 112,
"Title": "Employee Name",
"Re": "RFP_140577/140578_Qvidian_MKB",
"AssignedQCer": [],
"AssignedQCer@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
"AssignedQCer#Claims": [],
"AssignedQCer#Claims@odata.type": "#Collection(String)",
"QCerNeeded": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": -1,
"Value": "US Needed"
},
"QCerNeeded#Id": -1,
"ProjectDueDate": "2025-03-07",
"ClientName": "Invirsa",
"BC_x0023__x0028_s_x0029_": "140577/140578",
"TypeofOpportunity": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "RFP"
},
"TypeofOpportunity#Id": 0,
"Swimlane": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Advanced"
},
"Swimlane#Id": 1,
"Brand": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Thermo Fisher"
},
"Brand#Id": 1,
"QCStartDate": "2025-03-07",
"QCStartTime": "10 AM EST",
"QCCompletionDate": "2025-03-07",
"QCCompletionTime": "2 PM EST",
"DocumentstoQC": [],
"DocumentstoQC@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"DocumentstoQC#Id": [],
"DocumentstoQC#Id@odata.type": "#Collection(Int64)",
"EstimatedLevelofEffort": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "3"
},
"EstimatedLevelofEffort#Id": 2,
"EstimatedNumberofQCers": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "1"
},
"EstimatedNumberofQCers#Id": 0,
"Notes": "n/a",
"QCReview": false,
"Modified": "2025-03-07T19:14:49Z",
"Created": "2025-03-07T19:14:49Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|employee.name@company.com",
"DisplayName": "Employee Name",
"Email": "employee.name@company.com",
"Picture": "https://Company.sharepoint.com/sites/SPDQCReview/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
"Department": "Clinical Research Group",
"JobTitle": "Strategic Proposal Dev Spec"
},
"Author#Claims": "i:0#.f|membership|employee.name@company.com",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|employee.name@company.com",
"DisplayName": "Employee Name",
"Email": "employee.name@company.com",
"Picture": "https://company.sharepoint.com/sites/SPDQCReview/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
"Department": "Clinical Research Group",
"JobTitle": "Strategic Proposal Dev Spec"
},
"Editor#Claims": "i:0#.f|membership|employee.name@company.com",
"{Identifier}": "Lists%252fQC%2bReview%2bTracker%252f112_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https://company.sharepoint.com/sites/SPDQCReview/_layouts/15/listform.aspx?PageType=4&ListId=1efc55ab%2D7a2c%2D4623%2D8292%2D5d7e257e71b5&ID=112&ContentTypeID=0x01001A6069906E6AA44599D474594649AF3000BA09F9A2415FCC45BB0DCC25504F1F07",
"{Name}": "Employee Name",
"{FilenameWithExtension}": "Employee Name",
"{Path}": "Lists/QC Review Tracker/",
"{FullPath}": "Lists/QC Review Tracker/112_.000",
"{ContentType}": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
"Id": "0x01001A6069906E6AA44599D474594649AF3000BA09F9A2415FCC45BB0DCC25504F1F07",
"Name": "Item"
},
"{ContentType}#Id": "0x01001A6069906E6AA44599D474594649AF3000BA09F9A2415FCC45BB0DCC25504F1F07",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"