Get the specified publications object.

Version:  v4

Required Permissions


Request Type: GET



Request URI - Example:



Query parameter reference:

The following query parameters can be submitted with this endpoint:

For more information, see API Common Query Parameters v4.

Request Body:



Response Status Code - Success:  200 - OK

Response Body Example:

    "path": [
    "id": 1,
    "tableName": "POS_r01",
    "targetType": "hive",
    "action": "dropAndLoad",
    "createdAt": "2018-11-08T18:52:43.871Z",
    "updatedAt": "2018-11-08T18:52:43.871Z",
    "creator": {
        "id": 1
    "updater": {
        "id": 1
    "outputObject": {
        "id": 3
    "connection": {
        "id": 1


pathPath to the database where the table is to be written.
idInternal identifier of the publications object
tableNameName of the table to write

Type of table that you are writing. Example values:

    • hive

  • redshift
  • sqldatawarehouse
For more information, see Connection Types.


The write action to apply to the table, in the event that the table exists:

  • create - create a new table with each publication
  • createAndLoad - append your data to the table
  • truncateAndLoad - truncate the table and load it with your data
  • dropAndLoad - drop the table and write the new table in its place
createdAtTimestamp for when the publications object was created
updatedAtTimestamp for when the publications object was last updated
creator.idInternal identifier of the user who created the object
updater.idInternal identifier of the user who last updated the object
outputObject.idInternal identifier of the outputobject with which the publication object is associated
connection.idInternal identifier of the connection to use when publishing