web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse JSON from Web AP...
Power Automate
Answered

Parse JSON from Web API Html

(0) ShareShare
ReportReport
Posted on by 62

Using MS Flows, I am trying to create a list in Sharepoint from an Html list that I downloaded from a Web API. If I download an html with single user, the flow runs correctly. If i download an html with more than one user the flow stops during the Parse JSON step with the following error.  

 

 

[
 {
 "message": "Invalid type. Expected Object but got Array.",
 "lineNumber": 0,
 "linePosition": 0,
 "path": "PublicEmployeeResponse.Data.d2p1:PublicEmployee",
 "schemaId": "#/properties/PublicEmployeeResponse/properties/Data/properties/d2p1:PublicEmployee",
 "errorType": "type",
 "childErrors": []
 }
]​<p> </p><p>This is the schema I have that works with a single user. <li-code lang="markup">{
 "type": "object",
 "properties": {
 "PublicEmployeeResponse": {
 "type": "object",
 "properties": {
 "@@xmlns:i": {
 "type": "string"
 },
 "@@xmlns": {
 "type": "string"
 },
 "Count": {
 "type": "string"
 },
 "Data": {
 "type": "object",
 "properties": {
 "@@xmlns:d2p1": {
 "type": "string"
 },
 "d2p1:PublicEmployee": {
 "type": "object",
 "properties": {
 "d2p1:AgencyCode": {
 "type": "string"
 },
 "d2p1:AlternativeFirstName": {
 "type": "object",
 "properties": {
 "@@i:nil": {
 "type": "string"
 }
 }
 },
 "d2p1:EmployeeType": {
 "type": "string"
 },
 "d2p1:FirstName": {
 "type": "string"
 },
 "d2p1:FormattedSupervisorName": {
 "type": "string"
 },
 "d2p1:Grade": {
 "type": "string"
 },
 "d2p1:Id": {
 "type": "string"
 },
 "d2p1:IsActive": {
 "type": "string"
 },
 "d2p1:LastName": {
 "type": "string"
 },
 "d2p1:Location": {
 "type": "string"
 },
 "d2p1:LocationId": {
 "type": "string"
 },
 "d2p1:MiddleName": {
 "type": "string"
 },
 "d2p1:MobilePhone": {
 "type": "string"
 },
 "d2p1:MobilePhoneFormatted": {
 "type": "string"
 },
 "d2p1:MobilePhoneIsForeign": {
 "type": "string"
 },
 "d2p1:Office": {
 "type": "string"
 },
 "d2p1:OfficePhone": {
 "type": "string"
 },
 "d2p1:OfficePhoneFormatted": {
 "type": "string"
 },
 "d2p1:OfficePhoneIsForeign": {
 "type": "string"
 },
 "d2p1:OfficialEmail": {
 "type": "string"
 },
 "d2p1:OrgCode": {
 "type": "string"
 },
 "d2p1:OrgName": {
 "type": "string"
 },
 "d2p1:Series": {
 "type": "string"
 },
 "d2p1:Step": {
 "type": "string"
 },
 "d2p1:StreetAddress": {
 "type": "string"
 },
 "d2p1:SupervisorAlternativeFirstName": {
 "type": "object",
 "properties": {
 "@@i:nil": {
 "type": "string"
 }
 }
 },
 "d2p1:SupervisorEmail": {
 "type": "string"
 },
 "d2p1:SupervisorEmployeeType": {
 "type": "string"
 },
 "d2p1:SupervisorFirstName": {
 "type": "string"
 },
 "d2p1:SupervisorId": {
 "type": "string"
 },
 "d2p1:SupervisorLastName": {
 "type": "string"
 },
 "d2p1:SupervisorMiddleName": {
 "type": "string"
 },
 "d2p1:SupervisorMobilePhone": {
 "type": "string"
 },
 "d2p1:SupervisorMobilePhoneFormatted": {
 "type": "object",
 "properties": {
 "@@i:nil": {
 "type": "string"
 }
 }
 },
 "d2p1:SupervisorMobilePhoneIsForeign": {
 "type": "string"
 },
 "d2p1:SupervisorOfficialPhone": {
 "type": "string"
 },
 "d2p1:SupervisorOfficialPhoneFormatted": {
 "type": "object",
 "properties": {
 "@@i:nil": {
 "type": "string"
 }
 }
 },
 "d2p1:SupervisorOfficialPhoneIsForeign": {
 "type": "string"
 },
 "d2p1:SupervisorTitle": {
 "type": "string"
 },
 "d2p1:Title": {
 "type": "string"
 },
 "d2p1:UserPrincipalName": {
 "type": "string"
 }
 }
 }
 }
 },
 "Message": {
 "type": "object",
 "properties": {
 "@@i:nil": {
 "type": "string"
 }
 }
 },
 "Total": {
 "type": "string"
 }
 }
 }
 }
}

 

 

 

Categories:
I have the same question (0)
  • grantjenkins Profile Picture
    11,063 Moderator on at

    Are you able to send through the schema output from multiple users to see the difference.

     

    Assuming a single user will just return a single object for that user, and multiple users will include each user object inside an array for the users. So just need to see the difference and workout how to structure the flow to get around it.

  • CRod Profile Picture
    62 on at

    If i get the download for a single user and create the schema from it works fine (Creating the schema from json on previous step).  But if i get the download from multiple users and create the schema, it does not work for single or multiple users. What I did notice is that the json created with a single user it has that classic look to it, but with the multiple users it creates something similar to the one attached.  

     

    {"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Accept-Encoding","Access-Control-Allow-Headers":"Origin, X-Requested-With, Authorization","Access-Control-Allow-Origin":"*","Access-Control-Allow-Credentials":"true","ms-correlation-x":"8edfe7c1-fb0e-49d4-a90f-13917862d52b","OData-Version":"4.0","Access-Control-Expose-Headers":"Date, Content-Length, Server, OData-Version,ms-correlation-x","request-id":"d81f36c6-b768-4a55-9dad-680f70858533","x-content-type-options":"nosniff","Strict-Transport-Security":"max-age=31536000; includeSubDomains","Date":"Sat, 19 Mar 2022 03:06:57 GMT","Server":"Microsoft-HTTPAPI/2.0","Content-Type":"application/json; odata.metadata=minimal; odata.streaming=true","Content-Length":"1099344"},"body":{"@odata.context":"https://api.businesscentral.dynamics.com/v2.0/2efefwefdfe9-848wef37712fwef6323/Production/ODataV4/$metadata#Company('Company')/CustomerCard","value":[{"@odata.etag":"W/\"JzQ0OzI0a1gxU3hNSmY5RVVuSHpqK0oxSm9mM2lxZUkrL1NPVndwWUE3QmRpY1E9MTswMDsn\"","No":"16997","Name":"Microsoft","Name_2":"","Search_Name":"Microsoft","IC_Partner_Code":"","Balance_LCY":0,"Balance_Due_LCY":0,"Credit_Limit_LCY":0,"Blocked":" ","Privacy_Blocked":false,"Salesperson_Code":"","Responsibility_Center":"","Service_Zone_Code":"","Document_Sending_Profile":"","TotalSales2":0,"CustSalesLCY_CustProfit_AdjmtCostLCY":0,"AdjCustProfit":0,"AdjProfitPct":0,"CFDI_Purpose":"","CFDI_Relation":"","CFDI_Export_Code":"","SAT_Tax_Regime_Classification":"","Last_Date_Modified":"2022-02-17","Disable_Search_by_Name":false,"WSI_Square_Footage":"","WSI_Contract_End_Date":"0001-01-01","WSI_County":"Palm Beach","WSI_Epay_ID":"0","Address":"3923 Technology Way","Address_2":"Suite 640","Country_Region_Code":"US","City":"Boca Raton","County":"FL","Post_Code":"33431","ShowMap":"Show on Map","Phone_No":"(561) 756-9047","MobilePhoneNo":"","E_Mail":"","Fax_No":"","Home_Page":"","Language_Code":"","Primary_Contact_No":"","ContactName":"","Bill_to_Customer_No":"","VAT_Registration_No":"","EORI_Number":"","GLN":"","Use_GLN_in_Electronic_Document":false,"Copy_Sell_to_Addr_to_Qte_From":"Company","Tax_Liable":true,"Tax_Area_Code":"EXEMPT","Tax_Identification_Type":"Legal Entity","Tax_Exemption_No":"","RFC_No":"","CURP_No":"","State_Inscription":"","Gen_Bus_Posting_Group":"","VAT_Bus_Posting_Group":"","Customer_Posting_Group":"DEFAULT","Currency_Code":"","Price_Calculation_Method":" ","Customer_Price_Group":"","Customer_Disc_Group":"","Allow_Line_Disc":true,"Invoice_Disc_Code":"","Prices_Including_VAT":false,"Prepayment_Percent":0,"Application_Method":"Manual","Partner_Type":" ","Payment_Terms_Code":"DOR","Payment_Method_Code":"CHEQUE","Reminder_Terms_Code":"","Fin_Charge_Terms_Code":"","Cash_Flow_Payment_Terms_Code":"","Print_Statements":false,"Last_Statement_No":0,"Block_Payment_Tolerance":false,"Preferred_Bank_Account_Code":"","Bank_Communication":"E English","Check_Date_Format":" ","Check_Date_Separator":" ","Ship_to_Code":"SHIP TO","Location_Code":"","Combine_Shipments":false,"Reserve":"Optional","Shipping_Advice":"Partial","Shipment_Method_Code":"","Shipping_Agent_Code":"","Shipping_Agent_Service_Code":"","Shipping_Time":"","Base_Calendar_Code":"","Customized_Calendar":"No","ExpectedCustMoneyOwed":0,"TotalMoneyOwed":0,"CalcCreditLimitLCYExpendedPct":0,"Balance_Due":0,"Payments_LCY":0,"CustomerMgt_AvgDaysToPay_No":0,"DaysPaidPastDueDate":0,"AmountOnPostedInvoices":0,"AmountOnCrMemo":0,"AmountOnOutstandingInvoices":0,"AmountOnOutstandingCrMemos":0,"CustInvDiscAmountLCY":0,"Global_Dimension_1_Filter":"","Global_Dimension_2_Filter":"","Currency_Filter":"","Date_Filter":"''..03/19/22"},{"@odata.etag":"W/\"JzQ0O1lvYnJsb1BxeDMwTHFLV3FxUTBMTit4cUdOcmVpakZZSlZmQ3V6c0xCTnc9MTswMDsn\"","No":"19645","Name":"Banfield, The Pet Hospital","Name_2":"","Search_Name":"BANFIELD, THE PET HOSPITAL","IC_Partner_Code":"","Balance_LCY":0,"Balance_Due_LCY":0,"Credit_Limit_LCY":0,"Blocked":"All","Privacy_Blocked":false,"Salesperson_Code":"","Responsibility_Center":"","Service_Zone_Code":"","Document_Sending_Profile":"","TotalSales2":0,"CustSalesLCY_CustProfit_AdjmtCostLCY":0,"AdjCustProfit":0,"AdjProfitPct":0,"CFDI_Purpose":"","CFDI_Relation":"","CFDI_Export_Code":"","SAT_Tax_Regime_Classification":"","Last_Date_Modified":"2022-02-17","Disable_Search_by_Name":false,"WSI_Square_Footage":"","WSI_Contract_End_Date":"0001-01-01","WSI_County":"Multnomah","WSI_Epay_ID":"0","Address":"8000 NE Tillamook St","Address_2":"","Country_Region_Code":"US","City":"Portland","County":"OR","Post_Code":"97213","ShowMap":"Show on Map","Phone_No":"","MobilePhoneNo":"","E_Mail":"","Fax_No":"","Home_Page":"","Language_Code":"","Primary_Contact_No":"","ContactName":"","Bill_to_Customer_No":"","VAT_Registration_No":"","EORI_Number":"","GLN":"","Use_GLN_in_Electronic_Document":false,"Copy_Sell_to_Addr_to_Qte_From":"Company","Tax_Liable":true,"Tax_Area_Code":"EXEMPT","Tax_Identification_Type":"Legal Entity","Tax_Exemption_No":"","RFC_No":"","CURP_No":"","State_Inscription":"","Gen_Bus_Posting_Group":"","VAT_Bus_Posting_Group":"","Customer_Posting_Group":"DEFAULT","Currency_Code":"","Price_Calculation_Method":" ","Customer_Price_Group":"","Customer_Disc_Group":"","Allow_Line_Disc":true,"Invoice_Disc_Code":"","Prices_Including_VAT":false,"Prepayment_Percent":0,"Application_Method":"Manual","Partner_Type":" ","Payment_Terms_Code":"DOR","Payment_Method_Code":"CHEQUE","Reminder_Terms_Code":"","Fin_Charge_Terms_Code":"","Cash_Flow_Payment_Terms_Code":"","Print_Statements":false,"Last_Statement_No":0,"Block_Payment_Tolerance":false,"Preferred_Bank_Account_Code":"","Bank_Communication":"E English","Check_Date_Format":" ","Check_Date_Separator":" ","Ship_to_Code":"SHIP TO","Location_Code":"","Combine_Shipments":false,"Reserve":"Optional","Shipping_Advice":"Partial","Shipment_Method_Code":"","Shipping_Agent_Code":"","Shipping_Agent_Service_Code":"","Shipping_Time":"","Base_Calendar_Code":"","Customized_Calendar":"No","ExpectedCustMoneyOwed":0,"TotalMoneyOwed":0,"CalcCreditLimitLCYExpendedPct":0,"Balance_Due":0,"Payments_LCY":0,"CustomerMgt_AvgDaysToPay_No":0,"DaysPaidPastDueDate":0,"AmountOnPostedInvoices":0,"AmountOnCrMemo":0,"AmountOnOutstandingInvoices":0,"AmountOnOutstandingCrMemos":0,"CustInvDiscAmountLCY":0,"Global_Dimension_1_Filter":"","Global_Dimension_2_Filter":"","Currency_Filter":"","Date_Filter":"''..03/19/22"},{"@odata.etag":"W/\"JzQ0O1VwNXp6dmZHYndSTWd0elgzQWZNUTZtb3lKdmpDZVkvZFpRbXBhL0tHSEU9MTswMDsn\"","No":"19655","Name":"Butters Realty & Management","Name_2":"","Search_Name":"BUTTERS REALTY & MANAGEMENT","IC_Partner_Code":"","Balance_LCY":0,"Balance_Due_LCY":0,"Credit_Limit_LCY":0,"Blocked":" ","Privacy_Blocked":false,"Salesperson_Code":"","Responsibility_Center":"","Service_Zone_Code":"","Document_Sending_Profile":"","TotalSales2":0,"CustSalesLCY_CustProfit_AdjmtCostLCY":0,"AdjCustProfit":0,"AdjProfitPct":0,"CFDI_Purpose":"","CFDI_Relation":"","CFDI_Export_Code":"","SAT_Tax_Regime_Classification":"","Last_Date_Modified":"2022-02-17","Disable_Search_by_Name":false,"WSI_Square_Footage":"","WSI_Contract_End_Date":"0001-01-01","WSI_County":"Broward","WSI_Epay_ID":"0","Address":"6820 Lyons Technology Circle, Suite 100","Address_2":"","Country_Region_Code":"US","City":"Coconut Creek","County":"FL","Post_Code":"33073","ShowMap":"Show on Map","Phone_No":"","MobilePhoneNo":"","E_Mail":"","Fax_No":"","Home_Page":"","Language_Code":"","Primary_Contact_No":"","ContactName":"","Bill_to_Customer_No":"19655","VAT_Registration_No":"","EORI_Number":"","GLN":"","Use_GLN_in_Electronic_Document":false,"Copy_Sell_to_Addr_to_Qte_From":"Company","Tax_Liable":true,"Tax_Area_Code":"EXEMPT","Tax_Identification_Type":"Legal Entity","Tax_Exemption_No":"","RFC_No":"","CURP_No":"","State_Inscription":"","Gen_Bus_Posting_Group":"","VAT_Bus_Posting_Group":"","Customer_Posting_Group":"DEFAULT","Currency_Code":"","Price_Calculation_Method":" ","Customer_Price_Group":"","Customer_Disc_Group":"","Allow_Line_Disc":true,"Invoice_Disc_Code":"","Prices_Including_VAT":false,"Prepayment_Percent":0,"Application_Method":"Manual","Partner_Type":" ","Payment_Terms_Code":"DOR","Payment_Method_Code":"CHEQUE","Reminder_Terms_Code":"","Fin_Charge_Terms_Code":"","Cash_Flow_Payment_Terms_Code":"","Print_Statements":false,"Last_Statement_No":0,"Block_Payment_Tolerance":false,"Preferred_Bank_Account_Code":"","Bank_Communication":"E English","Check_Date_Format":" ","Check_Date_Separator":" ","Ship_to_Code":"SHIP TO","Location_Code":"","Combine_Shipments":false,"Reserve":"Optional","Shipping_Advice":"Partial","Shipment_Method_Code":"","Shipping_Agent_Code":"","Shipping_Agent_Service_Code":"","Shipping_Time":"","Base_Calendar_Code":"","Customized_Calendar":"No","ExpectedCustMoneyOwed":0,"TotalMoneyOwed":0,"CalcCreditLimitLCYExpendedPct":0,"Balance_Due":0,"Payments_LCY":0,"CustomerMgt_AvgDaysToPay_No":0,"DaysPaidPastDueDate":0,"AmountOnPostedInvoices":0,"AmountOnCrMemo":0,"AmountOnOutstandingInvoices":0,"AmountOnOutstandingCrMemos":0,"CustInvDiscAmountLCY":0,"Global_Dimension_1_Filter":"","Global_Dimension_2_Filter":"","Currency_Filter":"","Date_Filter":"''..03/19/22"}]}}
  • CRod Profile Picture
    62 on at

    I am progressing but have not solved the issue. So the reason it worked with one is because the schema was set to object. When i created the schema with multiple users, I thought it was giving me errors due to the null values but I was wrong. I already tried using the ["string","null"] option but it didn't solve the issue.

     

     This is the error result i keep getting.

     

    {"errors":[{"message":"Invalid type. Expected String but got Object.","lineNumber":0,"linePosition":0,"path":"PublicEmployeeResponse.Data.d2p1:PublicEmployee[1].d2p1:SupervisorAlternativeFirstName","schemaId":"#/properties/PublicEmployeeResponse/properties/Data/properties/d2p1:PublicEmployee/items/properties/d2p1:SupervisorAlternativeFirstName","errorType":"type","childErrors":[]},

    I think the issue is coming from this part of the schema but i have tried multiple variations but i cant figure it out. 

     },
     "d2p1:AlternativeFirstName": {
     "type": "object",
     "properties": {
     "@@i:nil": {
     "type": "string"
     }
     }
     },

     

  • CRod Profile Picture
    62 on at

    Not sure if im getting closer but I did start getting dynamic contents with the parse JSON. However, they are not the ones i need. I took the scheme to a json viewer and this is what i see.  The items under properties are the itmes i get unter the dynamic contents. 

    	
    	object		{2}
    		
    type	:	object
    		
    	properties		{1}
    		
    	PublicEmployeeResponse		{2}
    		
    type	:	object
    		
    	properties		{4}
    		
    	@@xmlns:i		{1}
    		
    	@@xmlns		{1}
    		
    	Count		{1}
    		
    	Data		{4}

     

    The items I need are embedded a little further down and im lost on how to get to them. The array i need is located under a different property section. (The properties under Public Employee with {41})

     

    	
    	object		{2}
    		
    type	:	object
    		
    	properties		{1}
    		
    	PublicEmployeeResponse		{2}
    		
    type	:	object
    		
    	properties		{4}
    		
    	@@xmlns:i		{1}
    		
    	@@xmlns		{1}
    		
    	Count		{1}
    		
    	Data		{4}
    		
    type	:	object
    		
    	properties		{1}
    		
    	@@xmlns:d2p1		{2}
    		
    type	:	string
    		
    	d2p1:PublicEmployee		{2}
    		
    type	:	array
    		
    	items		{3}
    		
    type	:	object
    		
    	properties		{41}
    		
    	required		[41]
    		
    	Message		{1}
    		
    	Total		{1}

     

     

  • Verified answer
    CRod Profile Picture
    62 on at
  • grantjenkins Profile Picture
    11,063 Moderator on at

    Just confirming - have you got this sorted now? Sorry been away for the last few days and no time to get back to some of these questions. Let me know if you still need help.

  • CRod Profile Picture
    62 on at

    Thanks for the reply. I thought I had figured it out but nope 😔. I got all excited because i got the dynamic content variables to show up following that tutorial. But once i got to the create item i got another error. I grabbed a variable from the newly created dynamic content and it added an extra step automatically, apply to each. Im not sure if thats the way it should be. But its getting me null errors again. Im starting back to see if i can narrow down what im doing wrong. 

  • CRod Profile Picture
    62 on at

    😮I saw the first glimpse of success. I started again from scratch. When I create the schema from the compose (previous step) I get several errors on the output. Most are saying something like "expected object but received string". Somewhere i fount that if you replace it with "string","null". It takes care of the issue. So i did. But instead of doing all at once, i ran it multiple times. So, Im not getting all the varialbes i need yet but i got more. So, im on the right path. I did see that i do need the "apply to each" step. Hope, im making sence. dynamic contents.JPGNew Test.JPG

     

     

     

     

    {
     "type": "object",
     "properties": {
     "PublicEmployeeResponse": {
     "type": "object",
     "properties": {
     "@@xmlns:i": {
     "type": "string"
     },
     "@@xmlns": {
     "type": "string"
     },
     "Count": {
     "type": "string"
     },
     "Data": {
     "type": "object",
     "properties": {
     "@@xmlns:d2p1": {
     "type": "string"
     },
     "d2p1:PublicEmployee": {
     "type": "array",
     "items": {
     "type": "object",
     "properties": {
     "d2p1:AgencyCode": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:AlternativeFirstName": {
     "type": [
     "object",
     "string"
     ],
     "properties": {
     "@@i:nil": {
     "type": [
     "string",
     "object",
     "null"
     ]
     }
     }
     },
     "d2p1:EmployeeType": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:FirstName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:FormattedSupervisorName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Grade": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Id": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:IsActive": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:LastName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Location": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:LocationId": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:MiddleName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:MobilePhone": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:MobilePhoneFormatted": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:MobilePhoneIsForeign": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Office": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:OfficePhone": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:OfficePhoneFormatted": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:OfficePhoneIsForeign": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:OfficialEmail": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:OrgCode": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:OrgName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Series": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Step": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:StreetAddress": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorAlternativeFirstName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorEmail": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorEmployeeType": {
     "type": "string"
     },
     "d2p1:SupervisorFirstName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorId": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorLastName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorMiddleName": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorMobilePhone": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorMobilePhoneFormatted": {
     "type": "object",
     "properties": {
     "@@i:nil": {
     "type": [
     "string",
     "object",
     "null"
     ]
     }
     }
     },
     "d2p1:SupervisorMobilePhoneIsForeign": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorOfficialPhone": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorOfficialPhoneFormatted": {
     "type": "object",
     "properties": {
     "@@i:nil": {
     "type": [
     "string",
     "object",
     "null"
     ]
     }
     }
     },
     "d2p1:SupervisorOfficialPhoneIsForeign": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:SupervisorTitle": {
     "type": [
     "string",
     "object",
     "null"
     ]
     },
     "d2p1:Title": {
     "type": "string"
     },
     "d2p1:UserPrincipalName": {
     "type": "string"
     }
     },
     "required": [
     "d2p1:AgencyCode",
     "d2p1:AlternativeFirstName",
     "d2p1:EmployeeType",
     "d2p1:FirstName",
     "d2p1:FormattedSupervisorName",
     "d2p1:Grade",
     "d2p1:Id",
     "d2p1:IsActive",
     "d2p1:LastName",
     "d2p1:Location",
     "d2p1:LocationId",
     "d2p1:MiddleName",
     "d2p1:MobilePhone",
     "d2p1:MobilePhoneFormatted",
     "d2p1:MobilePhoneIsForeign",
     "d2p1:Office",
     "d2p1:OfficePhone",
     "d2p1:OfficePhoneFormatted",
     "d2p1:OfficePhoneIsForeign",
     "d2p1:OfficialEmail",
     "d2p1:OrgCode",
     "d2p1:OrgName",
     "d2p1:Series",
     "d2p1:Step",
     "d2p1:StreetAddress",
     "d2p1:SupervisorAlternativeFirstName",
     "d2p1:SupervisorEmail",
     "d2p1:SupervisorEmployeeType",
     "d2p1:SupervisorFirstName",
     "d2p1:SupervisorId",
     "d2p1:SupervisorLastName",
     "d2p1:SupervisorMiddleName",
     "d2p1:SupervisorMobilePhone",
     "d2p1:SupervisorMobilePhoneFormatted",
     "d2p1:SupervisorMobilePhoneIsForeign",
     "d2p1:SupervisorOfficialPhone",
     "d2p1:SupervisorOfficialPhoneFormatted",
     "d2p1:SupervisorOfficialPhoneIsForeign",
     "d2p1:SupervisorTitle",
     "d2p1:Title",
     "d2p1:UserPrincipalName"
     ]
     }
     }
     }
     },
     "Message": {
     "type": "object",
     "properties": {
     "@@i:nil": {
     "type": "string"
     }
     }
     },
     "Total": {
     "type": "string"
     }
     }
     }
     }
    }

     

     

  • CRod Profile Picture
    62 on at

    The only usable variable i got was title and it worked, it filled my list. If i can only get the other 30 I need. 

  • grantjenkins Profile Picture
    11,063 Moderator on at

    That raw output you provided for the array of customer data has a body/value element that contains an array of the customer data. Looks like if we can just return that array then we should be able to loop over each of your customers and get the data. I'll see what I can come up with during the day.

    grantjenkins_1-1666395857633.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard