Hi @Paulie78 ,
Make sense and thanks for the quick response. As instructed, I generated output from the flow and had to clean some confidential info. I have the JSON data for the Header and line items. I haven't seen any option to attach a file here or didn't understand "Pastebin", so trying to paste it directly here. Hope this helps
PO Header
{
"statusCode": 200,
"headers": {
"Transfer-Encoding": "chunked",
"Vary": "Origin,Accept-Encoding",
"X-SharePointHealthScore": "3",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "101",
"SPRequestGuid": "e867d6e3-8800-48ed-a58e-4421f7e4f9f0",
"request-id": "e867d6e3-8800-48ed-a58e-4421f7e4f9f0",
"MS-CV": "49Zn6ACI7UiljkQh9+T58A.0",
"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 *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;",
"MicrosoftSharePointTeamServices": "16.0.0.21117",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Cache-Control": "max-age=0, private",
"Date": "Thu, 01 Apr 2021 14:34:45 GMT",
"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",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Wed, 17 Mar 2021 14:34:45 GMT",
"Last-Modified": "Thu, 01 Apr 2021 14:34:45 GMT",
"Content-Length": "1985"
},
"body": {
"@odata.etag": "\"2\"",
"ItemInternalId": "119",
"ID": 119,
"Title": "00000000-040121T102420",
"ReqType": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "Expense (N6P)"
},
"ReqType#Id": 0,
"Vendor_x0020_Name": "Blank Vendor to be bid out to LDS",
"VendorNumber": "00000000",
"BILFINGER": false,
"GRCapture_AutoGR": false,
"GRCapture_SCForm": false,
"GRCapture_WeeklyGR": false,
"GRCapture_StoreGood": false,
"GRCapture_AutoGR_Update": false,
"GRCapture_WeeklyGR_Update": false,
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Author#Claims": "",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Editor#Claims": "",
"IsCrectVendAddress": true,
"VendorAddress": "N/A",
"Modified": "2021-04-01T14:24:28Z",
"Created": "2021-04-01T14:24:27Z",
"{Identifier}": "",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "",
"{Name}": "00000000-040121T102420",
"{FilenameWithExtension}": "00000000-040121T102420",
"{Path}": "Lists/PO Request Info/",
"{FullPath}": "",
"{HasAttachments}": false,
"{VersionNumber}": "2.0"
}
}
PO LineItems
{
"statusCode": 200,
"headers": {
"Transfer-Encoding": "chunked",
"Vary": "Origin,Accept-Encoding",
"X-SharePointHealthScore": "0",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "105",
"SPRequestGuid": "faf7d4b9-14cd-4dfb-abe7-f644f87fc38c",
"request-id": "faf7d4b9-14cd-4dfb-abe7-f644f87fc38c",
"MS-CV": "udT3+s0U+02r5/ZE+H/DjA.0",
"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 *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;",
"MicrosoftSharePointTeamServices": "16.0.0.21117",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Cache-Control": "max-age=0, private",
"Date": "Thu, 01 Apr 2021 14:34:46 GMT",
"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",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Wed, 17 Mar 2021 14:34:46 GMT",
"Last-Modified": "Thu, 01 Apr 2021 14:34:46 GMT",
"Content-Length": "5560"
},
"body": {
"value": [
{
"@odata.etag": "\"1\"",
"ItemInternalId": "21",
"ID": 21,
"Title": "00000000-040121T102420",
"POReqID": 119.0,
"LineItemDescription": "Frieght",
"UOM": "EA",
"QTY": "5",
"Currency": "USD",
"PriceEach": "100",
"ItemTotal": "500",
"CostCenter": "12345",
"CommodityName": "Commercial Parts",
"G_x002f_LAccountCode": "51720002",
"EndServiceDate": "4/30/2021",
"CurrencyChar": "$",
"MatCode": "G310000AA",
"Modified": "2021-04-01T14:32:25Z",
"Created": "2021-04-01T14:32:25Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Author#Claims": "",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Editor#Claims": "",
"GoodOrService": "Good (Item)",
"{Identifier}": "",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "",
"{Name}": "00000000-040121T102420",
"{FilenameWithExtension}": "00000000-040121T102420",
"{Path}": "",
"{FullPath}": "",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
},
{
"@odata.etag": "\"1\"",
"ItemInternalId": "22",
"ID": 22,
"Title": "00000000-040121T102420",
"POReqID": 119.0,
"LineItemDescription": "Installation",
"UOM": "EA",
"QTY": "5",
"Currency": "USD",
"PriceEach": "500",
"ItemTotal": "2500",
"CostCenter": "12345",
"CommodityName": "Equipment Installation Services",
"G_x002f_LAccountCode": "51720003",
"EndServiceDate": "4/30/2021",
"CurrencyChar": "$",
"MatCode": "S811400AA",
"Modified": "2021-04-01T14:32:25Z",
"Created": "2021-04-01T14:32:25Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Author#Claims": "",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Editor#Claims": "",
"GoodOrService": "Service (Work)",
"{Identifier}": "",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "",
"{Name}": "00000000-040121T102420",
"{FilenameWithExtension}": "00000000-040121T102420",
"{Path}": "",
"{FullPath}": "",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
},
{
"@odata.etag": "\"1\"",
"ItemInternalId": "23",
"ID": 23,
"Title": "00000000-040121T102420",
"POReqID": 119.0,
"LineItemDescription": "Support",
"UOM": "EA",
"QTY": "5",
"Currency": "USD",
"PriceEach": "100",
"ItemTotal": "500",
"CostCenter": "12345",
"CommodityName": "Equipment Installation Services",
"G_x002f_LAccountCode": "51720003",
"EndServiceDate": "5/3/2021",
"CurrencyChar": "$",
"MatCode": "S811400AA",
"Modified": "2021-04-01T14:32:25Z",
"Created": "2021-04-01T14:32:25Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Author#Claims": "",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": null,
"JobTitle": null
},
"Editor#Claims": "",
"GoodOrService": "Service (Work)",
"{Identifier}": "",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "",
"{Name}": "00000000-040121T102420",
"{FilenameWithExtension}": "00000000-040121T102420",
"{Path}": "",
"{FullPath}": "",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"
}
]
}
}
