Presalytics

OOXML Automation

This API helps users convert Excel and Powerpoint documents into rich, live dashboards and stories.

Data & analytics#openapi#analytics

Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.

Overview

This API helps users convert Excel and Powerpoint documents into rich, live dashboards and stories.

Endpoints 148

Charts

  • GETCharts: Get Chart Data/Charts/ChartUpdate/:idGets a ChartDataDTO object, usually used for downstream analytics and chart updates
  • PUTCharts: Update Chart Data/Charts/ChartUpdate/:idSimplifies chart update by allowing users to supply data via ChartDataDTO
  • GETCharts: Get Dependent Objects Tree/Charts/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Chart and retreive their corresponding metadata in order to make…
  • GETCharts: Get Details/Charts/Details/:idReturns object metadata and information about relative dependent objects
  • GETCharts: Get Underlying Xml/Charts/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Chart object. The returned xml data conforms to…
  • PUTCharts: Modify Underlying Xml/Charts/OpenOfficeXml/:idDirectly eidt the underlying xml of a Chart object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETCharts: Get Svg file/Charts/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Chart as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETCharts: Get by Id/Charts/:idGet by Id: Use this method to retrieve a Charts object by its primary key (id)

Charts/Axes

  • GETAxes: Get by Id/Charts/Axes/:idGet by Id: Use this method to retrieve a Axes object by its primary key (id)

Charts/AxisDataTypes

  • GETAxisDataTypes: List All Possible Types/Charts/AxisDataTypesList Types: Use this method to retreive a list of possible options for the AxisDataTypes type. Use the Id from oneof the returned elements on to make changes…
  • GETAxisDataTypes: Get By Type Id/Charts/AxisDataTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETAxisDataTypes: Get by Id/Charts/AxisDataTypes/:idGet by Id: Use this method to retrieve a AxisDataTypes object by its primary key (id)

Charts/ChartData

  • GETChartData: Get by Id/Charts/ChartData/:idGet by Id: Use this method to retrieve a ChartData object by its primary key (id)

Charts/ColumnCollections

  • GETColumnCollections: Get by Id/Charts/ColumnCollections/:idGet by Id: Use this method to retrieve a ColumnCollections object by its primary key (id)

Charts/Columns

  • GETColumns: Get by Id/Charts/Columns/:idGet by Id: Use this method to retrieve a Columns object by its primary key (id)

Charts/DataPoints

  • GETDataPoints: Get by Id/Charts/DataPoints/:idGet by Id: Use this method to retrieve a DataPoints object by its primary key (id)

Charts/PlotType

  • GETPlotType: List All Possible Types/Charts/PlotTypeList Types: Use this method to retreive a list of possible options for the PlotType type. Use the Id from oneof the returned elements on to make changes to…
  • GETPlotType: Get By Type Id/Charts/PlotType/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETPlotType: Get by Id/Charts/PlotType/:idGet by Id: Use this method to retrieve a PlotType object by its primary key (id)

Charts/RowCol

  • GETRowCol: List All Possible Types/Charts/RowColList Types: Use this method to retreive a list of possible options for the RowCol type. Use the Id from oneof the returned elements on to make changes to…
  • GETRowCol: Get By Type Id/Charts/RowCol/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETRowCol: Get by Id/Charts/RowCol/:idGet by Id: Use this method to retrieve a RowCol object by its primary key (id)

Charts/RowCollections

  • GETRowCollections: Get by Id/Charts/RowCollections/:idGet by Id: Use this method to retrieve a RowCollections object by its primary key (id)

Charts/RowNameFormatTypes

  • GETRowNameFormatTypes: List All Possible Types/Charts/RowNameFormatTypesList Types: Use this method to retreive a list of possible options for the RowNameFormatTypes type. Use the Id from oneof the returned elements on to make…
  • GETRowNameFormatTypes: Get By Type Id/Charts/RowNameFormatTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETRowNameFormatTypes: Get by Id/Charts/RowNameFormatTypes/:idGet by Id: Use this method to retrieve a RowNameFormatTypes object by its primary key (id)

Charts/Rows

  • GETRows: Get by Id/Charts/Rows/:idGet by Id: Use this method to retrieve a Rows object by its primary key (id)

ConnectionShapes

  • GETSlides: Get Dependent Objects Tree/ConnectionShapes/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Slide and retreive their corresponding metadata in order to make…
  • GETSlides: Get Details/ConnectionShapes/Details/:idReturns object metadata and information about relative dependent objects
  • GETSlides: Get Underlying Xml/ConnectionShapes/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Slide object. The returned xml data conforms to…
  • PUTSlides: Modify Underlying Xml/ConnectionShapes/OpenOfficeXml/:idDirectly eidt the underlying xml of a Slide object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETSlides: Get Svg file/ConnectionShapes/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Slide as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETConnectionShapes: Get by Id/ConnectionShapes/:idGet by Id: Use this method to retrieve a ConnectionShapes object by its primary key (id)

Documents

  • POSTDocuments: Upload/DocumentsUpload an OpenOfficeXml document (e.g., .xlsx, .pptx) for processing by the API.
  • GETDocumentsController: Get Dependent Objects Tree/Documents/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this DocumentsController and retreive their corresponding metadata in order…
  • POSTDocuments: Clone an existing Ooxml Document to new Parent Story/Documents/Clone/:idClone A Document that has already been uploaded to a new Story
  • GETDocuments: Download/Documents/Download/:id?orginal=falseDownload the into a bytestream for client-side processing.
  • GETDocuments: Get by Id/Documents/:idGet by Id: Use this method to retrieve a Documents object by its primary key (id)
  • DELETEDocuments: Delete by Id/Documents/:idPermantly delete a document from the Ooxml Automation API. Note that is does not make changes to the related Presalytics APIs. Please use the delete endpoint…

Documents/DocumentType

  • GETDocumentType: List All Possible Types/Documents/DocumentTypeList Types: Use this method to retreive a list of possible options for the DocumentType type. Use the Id from oneof the returned elements on to make changes…
  • GETDocumentType: Get By Type Id/Documents/DocumentType/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETDocumentType: Get by Id/Documents/DocumentType/:idGet by Id: Use this method to retrieve a DocumentType object by its primary key (id)

Groups

  • GETSlides: Get Dependent Objects Tree/Groups/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Slide and retreive their corresponding metadata in order to make…
  • GETSlides: Get Details/Groups/Details/:idReturns object metadata and information about relative dependent objects
  • GETSlides: Get Underlying Xml/Groups/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Slide object. The returned xml data conforms to…
  • PUTSlides: Modify Underlying Xml/Groups/OpenOfficeXml/:idDirectly eidt the underlying xml of a Slide object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETSlides: Get Svg file/Groups/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Slide as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETGroups: Get by Id/Groups/:idGet by Id: Use this method to retrieve a Groups object by its primary key (id)

Images

  • GETShared: Get Dependent Objects Tree/Images/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Shared and retreive their corresponding metadata in order to make…
  • GETShared: Get Details/Images/Details/:idReturns object metadata and information about relative dependent objects
  • PUTImage: Download Image/Images/GetImage/:IdDownload Images extracted from Ooxml Documents
  • GETShared: Get Underlying Xml/Images/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Shared object. The returned xml data conforms to…
  • PUTShared: Modify Underlying Xml/Images/OpenOfficeXml/:idDirectly eidt the underlying xml of a Shared object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETShared: Get Svg file/Images/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Shared as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETImages: Get by Id/Images/:idGet by Id: Use this method to retrieve a Images object by its primary key (id)

Shapes

  • GETSlides: Get Dependent Objects Tree/Shapes/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Slide and retreive their corresponding metadata in order to make…
  • GETSlides: Get Details/Shapes/Details/:idReturns object metadata and information about relative dependent objects
  • GETSlides: Get Underlying Xml/Shapes/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Slide object. The returned xml data conforms to…
  • PUTSlides: Modify Underlying Xml/Shapes/OpenOfficeXml/:idDirectly eidt the underlying xml of a Slide object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETSlides: Get Svg file/Shapes/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Slide as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETShapes: Get by Id/Shapes/:idGet by Id: Use this method to retrieve a Shapes object by its primary key (id)

ShapeTrees

  • GETSlides: Get Dependent Objects Tree/ShapeTrees/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Slide and retreive their corresponding metadata in order to make…
  • GETSlides: Get Details/ShapeTrees/Details/:idReturns object metadata and information about relative dependent objects
  • GETSlides: Get Underlying Xml/ShapeTrees/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Slide object. The returned xml data conforms to…
  • PUTSlides: Modify Underlying Xml/ShapeTrees/OpenOfficeXml/:idDirectly eidt the underlying xml of a Slide object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETSlides: Get Svg file/ShapeTrees/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Slide as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETShapeTrees: Get by Id/ShapeTrees/:idGet by Id: Use this method to retrieve a ShapeTrees object by its primary key (id)

Shared/ColorTransformationAttributes

  • GETColorTransformationAttributes: Get by Id/Shared/ColorTransformationAttributes/:idGet by Id: Use this method to retrieve a ColorTransformationAttributes object by its primary key (id)

Shared/ColorTransformations

  • GETColorTransformations: Get by Id/Shared/ColorTransformations/:idGet by Id: Use this method to retrieve a ColorTransformations object by its primary key (id)

Shared/ColorTypes

  • GETColorTypes: List All Possible Types/Shared/ColorTypesList Types: Use this method to retreive a list of possible options for the ColorTypes type. Use the Id from oneof the returned elements on to make changes to…
  • GETColorTypes: Get By Type Id/Shared/ColorTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETColorTypes: Get by Id/Shared/ColorTypes/:idGet by Id: Use this method to retrieve a ColorTypes object by its primary key (id)

Shared/DashTypes

  • GETDashTypes: List All Possible Types/Shared/DashTypesList Types: Use this method to retreive a list of possible options for the DashTypes type. Use the Id from oneof the returned elements on to make changes to…
  • GETDashTypes: Get By Type Id/Shared/DashTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETDashTypes: Get by Id/Shared/DashTypes/:idGet by Id: Use this method to retrieve a DashTypes object by its primary key (id)

Shared/EffectAttributes

  • GETEffectAttributes: Get by Id/Shared/EffectAttributes/:idGet by Id: Use this method to retrieve a EffectAttributes object by its primary key (id)

Shared/Effects

  • GETEffects: Get by Id/Shared/Effects/:idGet by Id: Use this method to retrieve a Effects object by its primary key (id)

Shared/EffectTypes

  • GETEffectTypes: List All Possible Types/Shared/EffectTypesList Types: Use this method to retreive a list of possible options for the EffectTypes type. Use the Id from oneof the returned elements on to make changes to…
  • GETEffectTypes: Get By Type Id/Shared/EffectTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETEffectTypes: Get by Id/Shared/EffectTypes/:idGet by Id: Use this method to retrieve a EffectTypes object by its primary key (id)

Shared/FillMap

  • GETFillMap: Get by Id/Shared/FillMap/:idGet by Id: Use this method to retrieve a FillMap object by its primary key (id)

Shared/FillTypes

  • GETFillTypes: List All Possible Types/Shared/FillTypesList Types: Use this method to retreive a list of possible options for the FillTypes type. Use the Id from oneof the returned elements on to make changes to…
  • GETFillTypes: Get By Type Id/Shared/FillTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETFillTypes: Get by Id/Shared/FillTypes/:idGet by Id: Use this method to retrieve a FillTypes object by its primary key (id)

Shared/GradientFills

  • GETGradientFills: Get by Id/Shared/GradientFills/:idGet by Id: Use this method to retrieve a GradientFills object by its primary key (id)

Shared/GradientStops

  • GETGradientStops: Get by Id/Shared/GradientStops/:idGet by Id: Use this method to retrieve a GradientStops object by its primary key (id)

Shared/ImageFills

  • GETImageFills: Get by Id/Shared/ImageFills/:idGet by Id: Use this method to retrieve a ImageFills object by its primary key (id)

Shared/LineEndSizes

  • GETLineEndSizes: List All Possible Types/Shared/LineEndSizesList Types: Use this method to retreive a list of possible options for the LineEndSizes type. Use the Id from oneof the returned elements on to make changes…
  • GETLineEndSizes: Get By Type Id/Shared/LineEndSizes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETLineEndSizes: Get by Id/Shared/LineEndSizes/:idGet by Id: Use this method to retrieve a LineEndSizes object by its primary key (id)

Shared/LineEndTypes

  • GETLineEndTypes: List All Possible Types/Shared/LineEndTypesList Types: Use this method to retreive a list of possible options for the LineEndTypes type. Use the Id from oneof the returned elements on to make changes…
  • GETLineEndTypes: Get By Type Id/Shared/LineEndTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETLineEndTypes: Get by Id/Shared/LineEndTypes/:idGet by Id: Use this method to retrieve a LineEndTypes object by its primary key (id)

Shared/Lines

  • GETLines: Get by Id/Shared/Lines/:idGet by Id: Use this method to retrieve a Lines object by its primary key (id)

Shared/Paragraph

  • GETParagraph: Get by Id/Shared/Paragraph/:idGet by Id: Use this method to retrieve a Paragraph object by its primary key (id)

Shared/SolidFills

  • GETSolidFills: Get by Id/Shared/SolidFills/:idGet by Id: Use this method to retrieve a SolidFills object by its primary key (id)

Shared/Text

  • GETText: Get by Id/Shared/Text/:idGet by Id: Use this method to retrieve a Text object by its primary key (id)

Shared/TextContainer

  • GETTextContainer: Get by Id/Shared/TextContainer/:idGet by Id: Use this method to retrieve a TextContainer object by its primary key (id)

Slides

  • GETSlides: Get Dependent Objects Tree/Slides/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Slide and retreive their corresponding metadata in order to make…
  • GETSlides: Get Details/Slides/Details/:idReturns object metadata and information about relative dependent objects
  • GETSlides: Get Underlying Xml/Slides/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Slide object. The returned xml data conforms to…
  • PUTSlides: Modify Underlying Xml/Slides/OpenOfficeXml/:idDirectly eidt the underlying xml of a Slide object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETSlides: Get Svg file/Slides/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Slide as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETSlides: Get by Id/Slides/:idGet by Id: Use this method to retrieve a Slides object by its primary key (id)

Slides/ColorMaps

  • GETColorMaps: Get by Id/Slides/ColorMaps/:idGet by Id: Use this method to retrieve a ColorMaps object by its primary key (id)

Slides/Graphics

  • GETGraphics: Get by Id/Slides/Graphics/:idGet by Id: Use this method to retrieve a Graphics object by its primary key (id)

Slides/GraphicTypes

  • GETGraphicTypes: List All Possible Types/Slides/GraphicTypesList Types: Use this method to retreive a list of possible options for the GraphicTypes type. Use the Id from oneof the returned elements on to make changes…
  • GETGraphicTypes: Get By Type Id/Slides/GraphicTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETGraphicTypes: Get by Id/Slides/GraphicTypes/:idGet by Id: Use this method to retrieve a GraphicTypes object by its primary key (id)

Slides/GroupElements

  • GETGroupElements: Get by Id/Slides/GroupElements/:idGet by Id: Use this method to retrieve a GroupElements object by its primary key (id)

Slides/GroupElementTypes

  • GETGroupElementTypes: List All Possible Types/Slides/GroupElementTypesList Types: Use this method to retreive a list of possible options for the GroupElementTypes type. Use the Id from oneof the returned elements on to make…
  • GETGroupElementTypes: Get By Type Id/Slides/GroupElementTypes/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETGroupElementTypes: Get by Id/Slides/GroupElementTypes/:idGet by Id: Use this method to retrieve a GroupElementTypes object by its primary key (id)

Slides/SlideMasters

  • GETSlideMasters: Get by Id/Slides/SlideMasters/:idGet by Id: Use this method to retrieve a SlideMasters object by its primary key (id)

SmartArts

  • GETSlides: Get Dependent Objects Tree/SmartArts/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Slide and retreive their corresponding metadata in order to make…
  • GETSlides: Get Details/SmartArts/Details/:idReturns object metadata and information about relative dependent objects
  • GETSlides: Get Underlying Xml/SmartArts/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Slide object. The returned xml data conforms to…
  • PUTSlides: Modify Underlying Xml/SmartArts/OpenOfficeXml/:idDirectly eidt the underlying xml of a Slide object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETSlides: Get Svg file/SmartArts/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Slide as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETSmartArts: Get by Id/SmartArts/:idGet by Id: Use this method to retrieve a SmartArts object by its primary key (id)

Tables

  • GETTables: Get Dependent Objects Tree/Tables/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Table and retreive their corresponding metadata in order to make…
  • GETTables: Get Details/Tables/Details/:idReturns object metadata and information about relative dependent objects
  • GETTables: Get Underlying Xml/Tables/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Table object. The returned xml data conforms to…
  • PUTTables: Modify Underlying Xml/Tables/OpenOfficeXml/:idDirectly eidt the underlying xml of a Table object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETTables: Get Svg file/Tables/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Table as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETTable: Get Table Data/Tables/TableUpdate/:idGets a TabletDataDTO object, usually used for downstream updates to table content
  • PUTTables: Update Table Data/Tables/TableUpdate/:idSimplifies table update by allowing users to supply strings to table cells via TableDataDTO
  • GETTables: Get by Id/Tables/:idGet by Id: Use this method to retrieve a Tables object by its primary key (id)

Tables/Borders

  • GETBorders: Get by Id/Tables/Borders/:idGet by Id: Use this method to retrieve a Borders object by its primary key (id)

Tables/Cells

  • GETCells: Get by Id/Tables/Cells/:idGet by Id: Use this method to retrieve a Cells object by its primary key (id)

Tables/Columns

  • GETColumns: Get by Id/Tables/Columns/:idGet by Id: Use this method to retrieve a Columns object by its primary key (id)

Tables/Rows

  • GETRows: Get by Id/Tables/Rows/:idGet by Id: Use this method to retrieve a Rows object by its primary key (id)

Themes

  • GETTheme: Get Dependent Objects Tree/Themes/ChildObjects/:idThis endpoint is helpful for helping users and bots identify dependent objects to this Theme and retreive their corresponding metadata in order to make…
  • GETTheme: Get Details/Themes/Details/:idReturns object metadata and information about relative dependent objects
  • GETTheme: Get Underlying Xml/Themes/OpenOfficeXml/:id?updated=trueReturn the subset of the xml content from within the latest edited version of the OpenXmlDocument from this Theme object. The returned xml data conforms to…
  • PUTTheme: Modify Underlying Xml/Themes/OpenOfficeXml/:idDirectly eidt the underlying xml of a Theme object within an OpenOpenXml (e.g. Excel, Powerpoint) document. This endpoint will validatate the submitted xml…
  • GETTheme: Get Svg file/Themes/Svg/:id?use_cache=falseThis endpoint is helpful for rending this Theme as an svg or image object that can then be rendered in a story, dashboard or website.
  • GETThemes: Get by Id/Themes/:idGet by Id: Use this method to retrieve a Themes object by its primary key (id)

Themes/BackgroundFills

  • GETBackgroundFills: Get by Id/Themes/BackgroundFills/:idGet by Id: Use this method to retrieve a BackgroundFills object by its primary key (id)

Themes/Colors

  • GETColors: Get by Id/Themes/Colors/:idGet by Id: Use this method to retrieve a Colors object by its primary key (id)

Themes/CustomColors

  • GETCustomColors: Get by Id/Themes/CustomColors/:idGet by Id: Use this method to retrieve a CustomColors object by its primary key (id)

Themes/EffectMap

  • GETEffectMap: Get by Id/Themes/EffectMap/:idGet by Id: Use this method to retrieve a EffectMap object by its primary key (id)

Themes/Fills

  • GETFills: Get by Id/Themes/Fills/:idGet by Id: Use this method to retrieve a Fills object by its primary key (id)

Themes/Fonts

  • GETFonts: Get by Id/Themes/Fonts/:idGet by Id: Use this method to retrieve a Fonts object by its primary key (id)

Themes/Intensity

  • GETIntensity: List All Possible Types/Themes/IntensityList Types: Use this method to retreive a list of possible options for the Intensity type. Use the Id from oneof the returned elements on to make changes to…
  • GETIntensity: Get By Type Id/Themes/Intensity/TypeId/:type_idThis endpoint returns Type metadata from an integer type_id that can found on objects throughout the api.
  • GETIntensity: Get by Id/Themes/Intensity/:idGet by Id: Use this method to retrieve a Intensity object by its primary key (id)

Themes/LineMap

  • GETLineMap: Get by Id/Themes/LineMap/:idGet by Id: Use this method to retrieve a LineMap object by its primary key (id)

API details

Base URL
https://api.presalytics.io/ooxml-automation
Authentication
None declared in the description
Operations
148 operations on 135 pathsGET 132PUT 13POST 2DELETE 1
Main resources
Charts 8Tables 8Images 7ConnectionShapes 6Documents 6Groups 6ShapeTrees 6Shapes 6Slides 6SmartArts 6
Response formats
application/json text/json text/plain image/svg+xml
Description format
OpenAPI 3.0.1, API version 0.1.0
Listed from
APIs.guru OpenAPI Directory (CC0-1.0)
Source updated

How to test the OOXML Automation in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the OOXML Automation collection, without the publisher's secrets.
  3. Add your credentialsOpen the collection's variables or an environment and enter your API key or token, if the API needs one.
  4. Send a requestPick an endpoint, for example “Charts: Get Chart Data” (GET /Charts/ChartUpdate/:id), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the OOXML Automation?

This API helps users convert Excel and Powerpoint documents into rich, live dashboards and stories. It is listed under Data & analytics and has 148 endpoints.

Who publishes the OOXML Automation?

It is listed from Presalytics's public API description (an OpenAPI document), not published by Presalytics on Swastik Codes. Anyone who controls presalytics.io can claim the profile by adding a DNS TXT record.

What is the base URL of the OOXML Automation?

Requests go to https://api.presalytics.io/ooxml-automation. Endpoint paths are added to this base URL.

How do I authenticate with the OOXML Automation?

Its OpenAPI description does not declare an authentication scheme. Some endpoints may be open; check the provider's documentation before relying on that.

How many endpoints does the OOXML Automation have?

148 operations on 135 paths (132 GET, 13 PUT, 2 POST, 1 DELETE). The largest groups are Charts, Tables, Images, ConnectionShapes.

Is forking the OOXML Automation free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.