---
category: [Administration & Integrations, Platform and Product Extensions, Platform and Product Extensions/Integration, Administration & Integrations/Workday API, Administration & Integrations/Data Migration Tools, Administration & Integrations/Data Migration Tools/Prepare Your Data, Analytics and Reporting, Analytics & Reporting, Analytics and Reporting/Prism Analytics]
nav: wcp_docs
parent_url: /wcp_docs/
title: >- 
  Steps: Load Data into a Table Using Data Change with the REST API
layout: subsection
---

### Prerequisites

<a id="prereq_N1005D_N1005A_N10001"></a>
Security:

-   <i>Prism: Manage File Containers</i> domain in the Prism Analytics functional area when uploading a file.
-   Any of these security requirements:

    -   <i>Prism: Tables Owner Manage</i> domain in the Prism Analytics functional area.
    -   <i>Prism: Tables Manage</i> domain in the Prism Analytics functional area.
    -   <i>Table Owner</i> permission on the table.
    -   <i>Table Editor</i> permission on the table.
    -   <i>Can Delete Table Data</i> permission on the table.
    -   <i>Can Insert Table Data</i> permission on the table.
    -   <i>Can Truncate Table Data</i> permission on the table.
    -   <i>Can Update Table Data</i> permission on the table.



### Context

<a id="context_N10065_N1005A_N10001"></a>
The Prism Analytics REST API enables you to programmatically run data change activities created through the UI to change the data in a Prism Analytics table. You can change the data in a table once or on a regular basis. To change the table data, both the table and data change task must already exist in the Data Catalog.

When you create a data change task in the UI, you can run it as a data change activity using the REST API at any time. Use the POST /dataChanges/{id}/activities resource endpoint to run a data change task.

However, when the data change task specifies file upload as the source type, then you also need to create a file container and upload files to it before you run the data change task. These steps describe how to run a data change task that specifies file upload as the source type using the Prism Analytics REST API.

Use this URL when you use the REST API to access the REST resources using version 3:

```
https://{hostname}/api/prismAnalytics/v3/{tenantname}
```

<b>Note:</b>

Specify v3 as the version with the tables, fileContainers, and dataChanges resources.

Integration system users can’t create a table.

See the Workday REST Services Directory on Workday Community for details on the version 3 REST resources.

### Steps

1.  <a id="step_N10059_N10056_N10047_N10001"></a>Register your API client in your tenant using the <b>Register API Client for Integrations</b> task.

    Select <b>Include Workday Owned Scope</b> when you register. For more information, see [Register API Clients for Integrations](/wcp_docs/dan1370797831458.html#).

2.  <a id="step_N10089_N1005C_N10047_N10001"></a>Create a file container.

    Use the POST /fileContainers REST resource. Workday returns the ID of the file container.

3.  <a id="step_N100A6_N1005C_N10047_N10001"></a>Upload 1 or more files to the file container. Specify the file container ID in the URL of the POST request.

    Use the POST /fileContainers/{id}/files REST resource.

    Consider these rules:

    -   You can upload 1 file in each POST request. To upload multiple files into the file container, create multiple POST requests either sequentially or concurrently.
    -   Files must be gzip compressed.
    -   Each filename in a file container must be unique.
    -   The maximum number of concurrent uploads is 10.

    <b>Note:</b> You should retry the request if Workday returns HTTP response status code of 429 Too Many Requests.

4.  <a id="step_N1012B_N100DD_N1005B_N10001"></a>Get the ID of the data change task that you want to run.

    Use the GET /dataChanges REST resource.

5.  <a id="step_N10089_N10076_N1005A_N10001"></a>Run the data change task while specifying the file container that you created.

    Use the POST /dataChanges/{id}/activities REST resource. In the body of the POST request JSON, specify the file container ID:

    ```
    {
      "fileContainerWid": "string"
    }
    ```



### Result

<a id="result_N10096_N1005A_N10001"></a>
Workday:

-   Runs the data change task and starts a data change activity.
-   Returns the ID of the data change activity.
-   Changes the data in the target table based on the data in the file container source.


### Next Steps

<a id="postreq_N100A5_N1005A_N10001"></a>
You can view the data change activity progress and history on:

-   The <b>Activities</b> tab of the <b>View Table</b> report.
-   The <b>Data Change Activities</b> tab of the <b>Data Catalog</b> report.
-   The <b>Prism Management Console</b> report.


### Related Information

[Concept: Prism Analytics REST API](/wcp_docs/ikc1635886919812.html)

[Concept: wBuckets, Buckets, and File Containers](/wcp_docs/jdj1529979460647.html)

[Workday REST Services Directory](https://community.workday.com/sites/default/files/file-hosting/restapi/index.html)

[Reference: Naming Guidelines](/wcp_docs/mbh1617053010020.html)