Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I am trying to generate attachment with JSON file using REST API

Summary: How to add multiple rows in the excel file being attached to the request


Content (please ensure you mask any confidential information):

I am new to REST API and JSON, trying to use api "Generate a request attachment" (/epm/rest/v1/requests/{requestId}/attachments/generate)

the example body provided by oracle below, creates 1 single, record 1 header and 1 value, how to append more records/values in the file? As I want to have more than 1 rows in the column Name.

{

    "fileName": "Request101.xlsx",
    "items": [
        {
            "viewpoint": "All Depts",
            "data": [
                {
                    "header": "Name",
                    "value": "New name"
                }
            ]
        }
    ]

}

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!