spyreqop.blogg.se

Errors - An array of error messages should an error occur.HttpStatusMessage - The HTTP Status message for the response.HttpStatusCode - The HTTP Status code for the response.OperationId - The unique ID assigned to this operation.FileContent - The processed Excel document.Filename - The filename of the document.The ' Convert JSON to Excel' flow action returns the following data. Please refer to the Culture Names article for a list of supported cultures. Culture Name: This setting is used to set the culture for the workbook prior to conversion.Ignore Attribute Titles: Ignores titles of JSON attributes when converting JSON to Excel.Title - Wrap Text: Set whether a titles text is wrapped.Title - Font Bold: Set the title to bold.Title - Font Color: Set the title font color.Ignore Null Values: Ignore JSON properties which contain null values.Numeric Format: Set the numeric format.Date Format: Set the date and time format.Convert Numeric and Date: Auto parse numeric and date values, setting the cell format category to 'Number' or 'Date'.Worksheet Name: The name of the worksheet that the JSON data is added to.First Column: The first column to be written to.First Row: The first row to be written to.The advanced ' Convert JSON to Excel' flow action parameters are detailed below: You can control the output file format by setting the file extension of the ' Output Filename' property, i.e.You must provide either a ' File Content' (a file) value or a ' JSON Data' value but not both.JSON Data: Optional - The JSON data (as a string) to be processed.File Content: Optional - A Base64 encoded representation of the JSON file to be processed.Output Filename: The filename (including extension) of the output document.The default ' Convert JSON to Excel' flow action parameters are detailed below: The ' Convert JSON to Excel' flow action provides the capability to convert the JSON data to provided to a Microsoft Excel or CSV document.