updateAccessRules

最後の更新
PDFとして保存

Supported in API v24+

updateAccessRules requires Access Rule Security.

Category	Access Rules modification
Description	Update or replace a set of existing access rules from an access rules spreadsheet file.
Permissions Required To Invoke	Admin
Parameters Required On Request	Credentials, importOption

The method allows user to upload a spreadsheet file to update access rules. The content-type of the method request is multipart/form-data.

Request Format

Key is request, value is xml content, which contains a credentials tag to identify and authorize the calling user and an importOption tag to specify the operation. The user must have "Admin" permission to update access rules.
Key is content, Spreadsheet file to be imported. Spreadsheet files with extension .xls and .xlsx are supported. The file is the same with the files used in the UI access rules import.

Example

HTTP Request Body Form Data
Key	Value	Content Type
request	<?xml version='1.0' encoding='UTF-8'?> <call method="updateAccessRules" callerName="a string that identifies your client application"> <credentials login="sampleuser@example.com" password="my_pwd" locale="en_US"/> <importOption operation="update"/> </call>	text/xml
content	access_rules_template.xlsx

Full Request Example

POST https://api.adaptiveinsights.com/api/v24
Content-Type: multipart/form-data; boundary=WebAppBoundary
 
--WebAppBoundary
Content-Disposition: form-data; name="request"
Content-Type: text/xml
 
<?xml version='1.0' encoding='UTF-8'?>
<call method="updateAccessRules" callerName="a string that identifies your client application">
    <credentials login="sampleuser@example.com" password="my_pwd" locale="en_US"/>
    <importOption operation="update"/>
</call>
--WebAppBoundary
Content-Disposition: form-data; name="content"; filename="access_rules_template.xlsx"
 
< access_rules_template.xlsx
--WebAppBoundary--

View the format for the access rules template .xlsx file in the Complete the Template or Edit the Export section of this article.

credentials element
Tag Name		credentials
Description		All API calls must contain a single credentials element to identify the user invoking the API. The API call is then performed as this user (any audit trail or history of actions in the system will show that this user performed the action), and therefore the user must have the required permissions to perform the action in order for the API call to succeed.
Attributes of the Element
Attribute Name	Required?	Value	Example
login	Y	The login name of the user invoking the API method. This user must have a role containing the permissions required for the method being invoked.	sampleuser@company.com
password	Y	The password of the user invoking the API method.	my_password
locale	N	Specify the locale to be used to interpret incoming numbers and dates, and to format outgoing numbers and dates (using the proper thousands separator, month names, and date formatting). The locale is also used to specify the language in which any system messages in the response should appear. If not specified, en_US (American English) is used.	fr_FR
instanceCode	N	If the user specified in the credentials has access to more than one instance of Adaptive Planning, this attribute can be used to specify that the user is intending to access an instance other than their default instance. If not specified, the user's default instance will be used. To determine the available instance codes, use the exportInstances API.	MYINSTANCE1
Contents of the Element
(none)

CURL Example

curl -F "request=<updateAccessRules.xml;type=text/xml" -F "content=@access_rules_template_jp.xlsx" https://api.adaptiveinsights.com/api/v24

Response Format

There are two possible content-type for the response:

When the request succeeds or there are errors not related to the content of the uploaded spreadsheet, the content-type is text/xml.
When the uploaded spreadsheet contains errors, the content-type is multi-part/mixed. The response body contains two parts:
1. The first part is the xml data and represents the request status.
2. The second part is the base64 encoded error report spreadsheet file.

Example

Response Without Spreadsheet Errors

HTTP/1.1 200 OK
Content-Type: text/xml;charset=UTF-8
 
<?xml version="1.0" encoding="UTF-8"?>
<response success="false">
    <messages>
        <message type="ERROR" key="error-dac-not-enabled">Dimension Access Control is not enabled in this instance.
        </message>
    </messages>
</response>

Response with Spreadsheet Errors

HTTP/1.1 200 OK
Content-Type: multipart/mixed; boundary=----AdaptivePlanningAPIBoundary173bb6faa3d
 
------AdaptivePlanningAPIBoundary173bb6faa3d
Content-type: text/xml; charset=UTF-8
 
<?xml version="1.0" encoding="UTF-8"?>
<response success="false">
  <messages>
    <message type="ERROR" key="error-contains-data-error">Error occurred, refer the error sheet for detailed error.</message>
  </messages>
</response>
 
------AdaptivePlanningAPIBoundary173bb6faa3d
Content-Disposition: attachment; filename="Error Report.xlsx"
Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Content-Transfer-Encoding: base64
 
UEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V307CMBTGX2XprdkKmBhjGFyIXiqJ+AB1PWMN/Ze2wHh7Tzd2Ac5EhSXerF2/0+/39WzZpvNayWQHzgujczLORiQBXRgu9Don76vn9J4kPjDNmTQacqINmc+mq4MFn+BW7XNShWAfKPVFBYr5zFjQqJTGKRbw1q2pZcWGrYFORqM7WhgdQIc0RA8ymy6gZFsZksd2PVrnhFkrRcECpqI7zc9M06Nh5kA2Nb4S1t9gAUmeanRpT4OqJ/RvBFOWogBuiq3CLdlOyYVje+zKCQGXfwQ4T1a3+16x8U5wuCQZRFcOPLUOC10QcGzEkrnwwhQaUixeouopWmeXsLu+F8bBj4Cx8CLi2Wm9dcC4rwCCkhhDxdWv/FrSThtfE8/bd6CPd5R8N7kq9/TYvmIO+FtwkdeX5aRgwBzhIHsefgzQKNckB/y4QB+qEdrroC3HMVNM6L4Me+M2H8ZshuNHQjP/Dt+InjbDgH34VY7JP8lx2+WgzX9r9glQSwcIwAKQx3gBAAD1BgAAUEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAALAAAAX3JlbHMvLnJlbHOtksFqwzAMhl/F6N447WCMUbeXMuhtjO4BNFtJTGLL2NqWvf3MLltLChvsKCR9/4fQdj+HSb1RLp6jgXXTgqJo2fnYG3g+PazuQBXB6HDiSAYiw363faIJpW6UwaeiKiIWA4NIute62IECloYTxdrpOAeUWuZeJ7Qj9qQ3bXur808GnDPV0RnIR7cGdcLckxiYJ/3OeXxhHpuKrY2PRL8J5a7zlg5sXwNFWci+mAC97LL5dnFsHzPXTcuZ/mZz/QQ6kKBDwS/qKtUAyuKpXBO6WRDClP77OjQLRUfuwkif/cDuE1BLBwhuQ/oi4wAAAEkCAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAABAAAABkb2NQcm9wcy9hcHAueG1snVLLTsMwELzzFZHv1KEghCrHCPEQSFRU6oOzcTaNRWJb3m1U+HqcVE1TekDiEs3OTsbj9YrbbV0lDQQ0zmbsYpSyBKx2ubHrjC0XT+c37FaeiVlwHgIZwCT+YDFjJZGfcI66hFrhKLZt7BQu1IpiGdbcFYXR8OD0pgZLfJym1xy2BDaH/Nz3hmznOGnov6a5020+XC2+fPST4s77ymhF8U5yanRw6ApKpkobSw7L5HGroRJ8KBPRcg56Ewx9yVTwYSnmWlVwH4+QhaoQBD8Q4hlUO6yZMgGlaGjSgCYXEjTfkLExSz4UQhssY40KRlliO9mu6HDlkYJ8d+ETSwBCwXuyg0PtEJsrOe4EERwLeR8k4uOIC0MV4FsxU4H+StxlYIOMLzZ+N7od2VHKg6D2LtDJBfZRfh3+auwnLv3CPSiC/XCPSTEvVYA8vkc//J4QzzFlqFr9fansGvK95rTRLsVqt+fy4nqUXqZptwF7TvDDjssfUEsHCAJGEdt0AQAAFwMAAFBLAwQUAAgICACsdQRRAAAAAAAAAAAAAAAAEQAAAGRvY1Byb3BzL2NvcmUueG1sjZFda8MgFIb/inifqOnYOklS9kFhsNLCWjZ2J+aklSUq6pb2389kbfZ5MfBCz3nPc17PyWf7tkFv4LwyusAspRiBlqZSelvgzXqeTDHyQehKNEZDgbXBszKXlkvjYOWMBRcUeBQx2nNpC7wLwXJCvNxBK3waFToma+NaEeLTbYkV8kVsgWSUnpMWgqhEEKQHJnYk4iOykiPSvrpmAFSSQAMt6OAJSxn51AZwrf+zYMiMyr1Xo6rrurSbDLroiJGnxf3DYD5Ruv+6BFzmRzSXDkSACkUADwcbJ3LKPE5ubtdzXGY0owm9iGedUX425Yw95+RHfQ/8uBtXXsWB7ACtlne9bgz3U26ED4u4jVpBdX0oF0o6400d0LKulQS08eBy8ls4+m2PsX8aZpwyzi6/GD4ByqHN962X71BLBwhbwK4NOQEAAD8CAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAABAAAAB4bC9jb21tZW50czEueG1sjVE9b+MwDN37KwgtnRI5RVEcAtsZCgQo0KFDb+io2HQsVB8GRQdOi/vvpWKnN3SpIBmPFPn49FzuJu/ghJRsDJXarAsFGJrY2nCs1N/X/eqP2tU3ZRO9x8AJfLN9OoZI5uCwUhMpEIKQKtUzD1utU9OjN2kdBwxy00XyhiWko04DoWlTj8je6buieNDe2LAwbH3zGxJv6H0cVqJnMGwP1lk+X7iuNBP9oPG2oZhix2tp07HrbIM/1GzuNeHJZh9UXZqR+0jpCnRd6u/U4sWzTfwdAGFXqf29grnsqa2UWJl6M+CCJ9qOVuBnsayVnIfVjDZzWGSQ1z/RwDjJAJL9Ip/0ASfj5BdtlM5jXSSg40GG7ueWnKZ9FC2Xukfj7IFsznbGW3ee03c5oS+MXL/FEbw5Q4sOGYF7BCEefQDbwVku2xhuGQZnAnAEGxo3tnOdj9IE0pdfX2rOpHJmzXpx5T+azbpGqf4CUEsHCK+2f7toAQAAeAIAAFBLAwQUAAgICACsdQRRAAAAAAAAAAAAAAAAGAAAAHhsL2RyYXdpbmdzL2RyYXdpbmcxLnhtbCWMSwqDMBBA9z1FmH2d2EUpwehGeoL2AMFMjWA+zITq8Rvo8vEeb5jOuKsvsWw5Weg7DYrSkv2WVgvv1/P6gGm8DKdnc8jMquVJTEMLodZiEGUJFJ10uVBq9pM5utqQV/TsjjaKO960vqMUJuclENX5bwDHH1BLBwh207COdQAAAIIAAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAABsAAAB4bC9kcmF3aW5ncy92bWxEcmF3aW5nMS52bWyNUsFu2zAMvfcrBPUaL066ZIVquxg69LYNWDvsWCgWE6uVRcNiXKdfP8p2imQDhhmwRJGPT3wUs9u+dqKDNlj0uVx8SKUAX6KxfpfLn4/3ybW8LS6yiOLfB4W53LdehbKCWoektmWLAbeUlFgr3G5tCdMmp4zuXxld7Y64/j+YoS/BySJDFSrdgNMH3JPo2E+5BGNJFhdCcNiaWjfCaNKsSp4h5gzJ5mcMRdaNRzo0IErE1gT7BrlcLtZpOhtWKazJ5VOf8vdEy3QpBXM0zDrYjaYql/XMjeh2zHTj1sNYF99CLb6AeEbrAx0cX1FbgnYoKsYjjdi12ljwNJSEL7mkeFeJ3kNJscRctmxNSk5Kf9chtta5Eh22ubzc8geLs/rDIl2uIimXAVSjYUq9J5RiqqrBYIlnQulNQLcnuBFC1LrdWZ842JJaLz82dDN5CBt1tebzqzVUqcUyZbsCu6tIfVqx/ZZYb6BXi0jT2WA31lk6qMoaA16KUdTlaXePDau0wVcxadk4Xb5w3ZtQ7lswY2d83M4a+EezPHp4BxBPwgb7o9A6YGJsbCerTbQjNfQhgkVmbHfExTQO251XUf9EN3/nG469unPx4b7w3Invm2dmfRwq+IYEE2evvmIHvyxVd+BcmB+9Dzxwf3s/+7LCdjiJ1UykM3E1rOthveY1m5+hYg4LuOf3L+61CzDEj54J8QNfi6sYiMbku+Nnrn2xiu7JHhSeajqdt4JDtSt+A1BLBwhSWjEMMAIAAEIEAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAABQAAAB4bC9zaGFyZWRTdHJpbmdzLnhtbLVYS2/bOBC+768gdNgmWNdOWqAoso7bbJqmAdI2TZzeaWlsESuRKkk58R72t+8MScmyJDsOgj3kYXLe3zfk0OMPj3nGlqCNUPI0Oh4eRQxkrBIhF6fR/fTz6/fRh8lvY2Msi1Up7Wn0/jhipRS/Sjj3C+/eRgytSHMapdYWJ6ORiVPIuRmqAiTuzJXOucWPejEyhQaemBTA5tnozdHRu1HOhYwmYyMmYzs5i2Mwht2WGbAraawuY4uhmfHITsYjkvFyn65uL86nV9+/3bV3jofss9IMeJwy7q1ptDbAvCxoxtm9AS15DgylLrUqC+Y+cZngDwsBTFcFDNum3wzZBZlNRA6SKsZSbtDipebSOgP+v7MsYxePMRRUtKzMZSOkhfOIn0oMY8AygZUFYVMMDX/hNhowtA/OAOXOsIBus/ZrhuyTkq+sV1/yrATDhGQzZdPgEm3MnZKh5GrNTk5vh+wswcyZgYJrboFp9eA8unCdbbZSpXPV0b4DYOeIKKo1kPMR50qjY7BcZKajeP79+v5rF7wbZYyYIfY/XU4d1MHEWriqtLcauLW3PpeIx08BDwN2LXJhIQmfMMiLRNi2/C38KoWGZMjOU6UMEkUCKxAg4tHQqZwQxurBOBSZVQxwkSXccoS6ctcRWuJiEGoGcsJuNCyBcHeSc61yJ4tNyEyRCdwgcsVKWi1mpaX1bYWt2N1enyIV4JHHyM6EYwWXrr/EIg1e+3SqQjAxD53yjcgkDJtlXP7d8b2W2e7dd56nZjeSRaZmPPNlcJ2yK6S6kbcGdI1lzQw7cG15uD2ojORcaAN28O8hEePgj4587buUGXGt6gqv7hqQsrr0LdxzCFzXbswJu8TETXVCITlIlayh/WCPMMdVoRFsE4NMyO6QAuxqqwdZKw4p+K4Ix4Aqgau5i35Bxe+TwN6Q2crFZFXRqA/jRQFc18n6HZ8g6ri1xqnLCr7onqMbsDQKtRdCL0GlH4lbyNUTWAwCEFyiiFUaF/rR6TmW6JZ8moI8COLdC+5kCpV0i4v6mho8l5vBRKsOPeSkUAKONcaeJSlHlhiIS7Jf2cPDESPdzePat7tb0WUPm9c3cI+toNNJwtVjB83XQW4neiUz2Kj0bibXlek/bjbB3o/Ye+L+QrxfCnK3RVoQD7rYNluk7psW4N7u3oi3q/B7Zv9cD2Nkc/J0pzVvIDfeVD3l/77ev7fWg9dzO6uer+ISy5I3JkoyHmDA6rd3vccu6UMkFShY9wYQBPHG+EgXZipAcx2nIubZjk7a0HtlgqNdfdUO1vfXs/qKQOi54qobqZQxDpwLpcU/mKzz8gxm7NeWHZK8iBT/IxN2Xl4NtJp4M92ntMf1hpKq+wY4+3pzfdEZ5aebOLspsznZ1GdMn+JcaCylfVBBNwPLpph/PWa7ujWPcaLWen4Jr6fwAMq4XjmfMyVLs6FCAnecXLiRoDcYmwqdeLJiHNgEFInBl8+G/+AxeAvR1CMSTjsziDnV4MsP6r+N0erQU8Nl1+yNQCJkgcLo6WGG6CMhSJ37isT4ZjVWoC+K6K72vk4s603MT0BbDsvm5q5+6Xs9IU0/8jDYizDXD2OVd2hDwbUXeyYbn1J79S9CcutDr73x5Udrhb6wODEFj+E0KrCeoJcQNb98MKzz9qwf3523LBFAr25hQY25paR9QrtK6xsen0Hb7G3u7zJ1o1VSxltn0M3tXYawhVYfE2J8H6BnxoDtFGd3VfYuR+QlI2wd+t6D16PK+puNapgg5tfi4bR1T2raEHmhtMXzJfPXvjdTyzfaZGSMnfwHUEsHCKGAXnNIBQAAIBMAAFBLAwQUAAgICACsdQRRAAAAAAAAAAAAAAAADQAAAHhsL3N0eWxlcy54bWzNWFtvozgUft9fgXinBgKZJAoZTZqirTQ7GqlZaV8dMIlVYyNjOmRW+9/HNiQ490yaStuH2j4+5/N3LviS8ec6J9Yb4iVmNLK9B9e2EE1Yiukysv+ex87A/jz5Y1yKNUEvK4SElSej5yVlHC4IiuzaC2Bi1V6f+1bNbUvC0TKyV0IUIwDKZIVyWD6wAlE5kzGeQyGHfAnKgiOYlgoyJ8B33T7IIaYtwihPrgHJIX+tCidheQEFXmCCxVpjbWA0vQOkHCeclSwTD9ISsCzDCTokNARDAJMOSbp4G5IXAtff8a7mNyIFgKM3rJJlT8a0yuNclFbCKioi27XBZJwx2kk8mU0dgdErZT9orOak1G7UJuPyp/UGiZR4yjRhhHEL0xTVKI3sgZJRmKNG5xESvOBYrwFzTNaN2FcC7UOrl2NZG0oImjWa/xW4sJrnn1xuB2hhAvVvsPGutzkk/f/hdyqgQmVCZ/6O2Tu2EF8uIjuOXf13/WI7uEdNusUe3GOF4howuiklHCZkW/Wh3QgmY7kpCMRpLAdW25+vCxkeyihqYLTeBe0lh2vPD683KBnBqWKxfNwl7zcxMAyvhdSMjyAGvVsRT5I8A6kbGe8F46k8M8yIN6LJmKBMSHOOlyvVClYANSmE3NUm4xTDJaOQqAU2Fl2rlCx91ES2WMnt8piaRNzXudJSUdtXui+a9vr9S7QdGegEEfKitP7JttH2ZbTrzGp2/+dUbfyW+g42XZmittvANANw2ujTSSMLFgVZf6vyBeKxPnc7qSqMbjTVVt34C8FLmiNqGHznTKBE6ItG8xGb3jW+Gm56wU1+WnV20WHvsnXrI9NMzmH5d8Tq3REr+Bhe/lVYZoWcRb4ijwf1pO4vcDO0fnBYzFG9cQHU2enV+u/z4wKTFeP4pzRUh1ciBYhfJBT+bpLuT+F9X9KZraOx/si6un8whh2hwCQUHBDSFASv0N7+Z4h2t01jovFGCy7wNapbq/9GMj+E/5XhBe1WbpxfO6fXVmqpG2Bk/ykvJJxg+tpVjbWoMBGYPm9eIvs23xQvYvhlGOydLpJHWme77yShnq+7zCRGijJYETHfTkZ21/8LpbjK/a3Wd/zGRKvV9b+qK0Bz85d5+1oK3VoVx5H979P003D2FPvOwJ0OnKCHQmcYTmdOGDxOZ7N46Pru43/G2/UdL1f93JSV4gWjkkgt3jrbkn/pZJFtDBr6On6Stsl96PfdL6HnOnHP9ZygDwfOoN8LnTj0/Fk/mD6FcWhwD2984brA8zry4UjgHMnSQLv056ZUJkkOzzgBNpkA3e8Yk19QSwcIxq0AAdgDAAD7EAAAUEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1azW/bNhS/768QdHf17Y+gTmHLdtM2aYLG7dAjLdMWY0o0SCqJURQY2tMuAwZ0wy4DdtthGFZgBVbssj8mQIut+yNGSf4QbapN2rTYsNiALZK/9/jje4+Pz5Kv3ziNsHYMKUMkburWNVPXYByQIYrHTf1+v1ep6ze2P7sOtngII6jFIIJNfX80QgHU+mmXrgkNMdsCTT3kfLplGCwQ/YBdI1MYi7ERoRHgoknHxpCCE6E5woZtmlUjAijWtxfKu1h8xJylHQGmh8HGjBl2OLHSLzZjPqbaMcBNXegckpM+POW6hgHjYqCpm9lLN7avG0shzEtkC3K97DWXmwsMJ3YmR8eDpaDrem61tdRv5/o3cd1at9qtLvVlABAEYqWWQmfN9t05tgDKLxW6O7WOY0n4gn5nA9/y0reEd1Z4dwPf6/krGxZA+aW3gffajXZH1u+t8NUNfM1sddyahM9AIUbxZANtelXHX6x2CRkRvKOENzy3V7Pn8BXKKERXLh/zsliLwBGhPQHInAs4ijU+m8IRCATOBxgNKNJ20TgUgTcFMWGi27TNnumIz/TtZleZR8EWBAXpvCtgG10pH40FFE15U78ttOoFyKuXL8+evDh78tvZ06dnT36Zz70ptwPicVHuzY9f//39F9pfv/7w5tk3ajwr4l///OXr3/94m3ou0fr2+esXz19999WfPz1TwFsUDIrwPoog0+7CE+0eicQCFRPAAb2YRD8ESJIAoUAqgF0eSsC7M4BVuDaUTfiAikyhAt5MjiSuhyFNOFIA74SRBNwjBLcJVS7nTjpXcTlJPFZPTpMi7h4Ax6q5/TUHd5OpCHmkUumHUKJ5gIW3wRjGkGvpGJlAqBB7iJBk1z0UUMLIiGsPkdYGSGmSPhpwtdAOioRfZiqCwtWSbfYeaG2CVeo78FhGim0BsEolxJIZb4KEg0jJGES4iNwFPFSRPJzRQDI448LTY4iJ1h1CxlQy+3Qm0b0jMoza7Xt4FslIytFEhdwFhBSRHTLxQxBNlZxRHBaxt9hEhCjQDghXkiDyDknbwg8gLnX3AwT5xbb1fZGB1AGSjiRUtSUgkffjDI8AVClv0UjKri2KlNHRTsZSaO9CiMEJGEKo3b+lwpMpUZO+HYqssgNVtrkN5FhN2zFkosxK6xqFYxGTQvYQjkkJn73ZWuKZgTgCtEzz3YkcMl1xyilT6T4OJlIqRTTdtGoS+ywC59J6EAIprNI2U8frjMYX3WNC5ug9ZOCFZURiP7dt+gBDdcD0gSgwVOlWiCRqkXQ7ZWKJUm4kb9qVG4y1eidC8TuLn7Wyx/s0Zc9HK3guv9QpSynrBU4Z7j9Y1nRAEh9AcZJcVTVXVc3/saop28tXtcxVLXNVy3yyWmZVvhjFuzyZlqj0ls8IYXzIZxjusqzwYWLvD3uiM2tkQss7TNNQXM6nk3BjCrJrjRL+OeLhYQimYhorm2HM5qrHTJsSJkonvVR3Vnol0R4Z5r2WtbipKQQAX/WL0mvRLwo1nvdWa6u7d0v1WWvMigS8TOn5SRQmk0k4ChI153wkLPOyWDQULOrW21gYBa+Iw0kD6d1vz80ZiXATIT1M/ZTLL7x76Z4uM6a8bFuxvIZ7aZ6WSBTCTSZRCMNQHB7r3Zfs60ZD7WpbSaNW/xi+NjZzA47llnYi9pzjCTUBmDb1kfjRJC6jqdDH0kwF8Dhu6gGfG/p9MsuUMt4BLMxh2VC+/ghxSDWMIhHrRTfgeMXNsmvmv5dcw/z3Wc5YdzIcjWDAS3pWTTGWK1GOfiA4bZBEkD4MhyfaACf0HhCG8mpWasAhYnxpzSGiheBeWXEtXc23ovSwZbVFAZ6GYH6iFJN5Ds+ul3QK68iYrq/KUJlwMO5dxqn7bqG1pFlygNRKs9jHO+QLrBw1K0+Z6xp18+2nxIcfCAVqdTU1R02t7Oy4xIKgMF21xG52qTc/8DRYj1qjUFdmrY2n2mRwJCK/I6rVBHOW3xw7FeW3v3gemWeCrHeRXU65llDU1B+ZXsv1bc+vmHWvW3Ed16zUvZZTaXmeY3U9y+y07cfCKDyMLC+fuyd+7OOZ8qE9Eqt6VLV7DafRrlYaTqtXcTvteqXhV9uVTtWvdXod36s3eo917TgDuy3Hd6vdeqVq+X7FrZrp1PVGpebadsuttepdt/V48W+AjMTGPwKiRV1/LSCRQTJCRsY0+0eAZef/CJgnw1O++F6YN4Nu/wNQSwcIbppOcoUGAAC0IAAAUEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAAPAAAAeGwvd29ya2Jvb2sueG1spVRdb9owFH3fr4j8DomTECBqqKB0GtI2VVs/HivjGGLVsTPbAaqq/33XgfBR+tB1VnB8fa8P59x7nYvLTSm8FdOGK5kh3A2QxyRVOZfLDN3dfu0M0OXoy8Va6ae5Uk9eSdPZUipN5oJlaIN73kbDk8APBzCFyANEaTJUWFulvm9owUpiuqpiEjwLpUtiwdRL31SakdwUjNlS+GEQJH5JuNwhpPojGGqx4JRNFa1LJu0WRDNBLOgxBa9Mi1bSj8CVRD/VVYeqsgKIORfcPjegLQwoPsMpOdXKqIXtwrkdozNxOPAxPtG3ORf4MaQYFK64q9gBKvkkVrLHOkiESv43Gg4OcOEn0Xp7tBCNLhZcsPtto3qkqn6S0jWgQJ4gxl7n3LI8Q30w1ZqdbOi6mtRcgIGDBMfIH+3b+UZ7OVuQWthbINbCQ2CSDMOei4R+HwvLtCSWXSlpocmazatCAWfvF/tTc81McxWAJMyEpmRubogtvFqLDPl3BmD9Z94VvPanai2FApn+UUeR8978h54i1BH196S263PWG522+byx2oP1bPodcvebrCCTUK98d4tmLlXRo6Q6xY8v0WQyHk6TSScZTqJObxqPO+N+FHbi6aB/1Z8MMR4Er8h9A1KqSG2LXRYddIbi3juuH2TTenCQ1jw/0HgJdqPzztSOVyfY1e+es7U5lNOZ3uaBy1ytG0XP7TpOwFo3xgPPbZGhKEqC/d43xpcFsMWDQQybhFq+YrdkDjuOZOg4vuE23dL6CqOZTrj5R+SacrVvTzZtO5PG6po2HynkNZ4m6dCsqfsnPcuxwzk5U1ZK26Po8Cg6fBt9rbXS5igiOToZNRxbYpQIChfBvZwzaJxtSkd/AVBLBwihvwtvjAIAACIGAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72Ty2rDMBBFf0XMvpbttKGUKNmUQrZt+gFCGlsmtmQ000f+vsKFxoEIunC7kRCDzj2Iq83uc+jFO0bqgldQFSUI9CbYzrcKXg9PN/cgiLW3ug8eFfgAu+3mGXvN6Qa5biSREJ4UOObxQUoyDgdNRRjRp0kT4qA5HWMrR22OukVZl+VaxjkDLplibxXEva1AHHRskRV8hHgkh8gkp60qEjyNTyP+Jjo0TWfwMZi3AT1fMZA/ASCvy9R5mfrfZVZnGU45KKd18UeZqDmH27MD8alHWjr9m5qLv5vFOx3RvnBMtV3eYg7Pyazz5Vj9aTnkxV/cfgFQSwcI3UKoF/QAAADRAwAAUEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1snZhdc+ooGIDv91dkcl8TIJ+Oeuacuu32YmfO7OzHNUbUTBPJkFjb2dn/voDREgiJaafaRODhIby8VBbf3svCeSOszulx6YKZ7zrkmNFtftwv3b/+fHpI3G+rXxZnyl7rAyGNU2bzl/2RMrwpyNJ9BwHOnHfGfyF/IZe/zU/5dun+67c/D/wFHq5Xl7frz3+8flkc66V7aJpq7nl1diAlrme0IkdesqOsxA2/ZXuvrhjBWylRFh70/cgrcX5sCXN2D4PudnlG1jQ7leTYXCCMFLjho68PeVVfaWV2D67E7PVUPWS0rDhikxd58yGhV4x8PAapzDNGa7prZrxl62QOL/VSD2c3kjm+uzAg4AN8y8X0fqLgF1nhjQU/YeiLsOgGQ+5qsc35jIgbh5Hd0v0O5s/Id73VQrb4OyfnWrl2RDxuKH0VNy882mRVz6j7JCfrJ3M2uCaPtPgn3zYHHuY8yrdkh09F8/lhMksQ9BGA4a3wD3r+jeT7Q8Ob8E/lbM63H2tSZzx8eK8zKPrNaFHLd6fMxSJynRK/y7/ZqW5o2XbQsBNxnfPlJvDFUuNtClzVhI9gh4uatLQLB7YcOMQJ41EOajloiBON+wQtJxjigHCUE7accIgDk1FO1HKiQZ9xTtxy4iEOAjaOd5l+GW9r3ODVgtGzw+T81xUWyQ3M+bMXUQRBfxSFfAVkos130UhOOS+o+advK3/hvYle+IuDb3TYpffG5hUKJTRQoKAfiiZAkYKD/bhgAk61Q/24cAIuVHBBPy6egIvlEwQKNOyHJhOgiTEtUT80vR/6IzWg8Q0qazyaNZL+bkWa1CM4SEYGJRvJSLrh067AD1HlMxJ9Ta8FRGodS7iCniUGojFBYAgCqBuqMw2QbghMQ0uMAfgVQ2gahrqhmiJApBtC0zC2GCLTMArGDJFpmOiGndJUN0SGIbRkOhCYhgiOGQaGIQS6oboGINQNA9PQkphAaBom/phhaBoGuqGaxmCoG4amoSWDiJibPsuRaRjrhp3eE90wMg1Ti6GajuOLYTq6UmLDEPm6YayWAt0wNgyRZTcDiWk4/gwT0xDpholaGuiGiWlo2Xyg3zUc/qfAN/YBZIkeCKZw1dyJLFkHwilENdchy2YF0RRiZz4sEQnDKcTLWgwHtr2eKvrG89hXR1v26546gRb0v/bV0UL/qaeOnoCe++rYpjSa8rjUcA707bdbivSxdUoDfVSdUttCiae4xoOu8YDrultqPN1OqW3xJfe7PkM1lQS2mUqnjD5Vifom3y01Rt8pTfXRp3eMHk1IaeLEYGD0nvIV7fBREVbkx9dauW6PHngvbC6OsNjLFlgOtALrgZb4RqjSK7wnv2O2z4+1U5CdNBY9XI4V5HVDK3nFV9mGNvwL6PXuQPCWMHHH89WO0uZ6Izq5Hcmt/gdQSwcIMxpi8ysEAADFEwAAUEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDEueG1sLnJlbHON0M1qwzAMB/BXMb4vTncYYyRpxz6gh11K9wDCVhwTWzKW23VvP8MYrLDDjpLQD/01bC8pqjMWCUyj3nS9VkiWXSA/6vfj6829VlKBHEQmHDWx3k7DASPUtiFLyKIaQTLqpdb8YIzYBRNIxxmpTWYuCWorizcZ7AoezW3f35ny29DXptq7UZe922h1hOKxfuvS+JX4I6Lz2IGDXMMZcwSidm9nOZmdZ2ODM08FoeKjtShyOEWUH+mNXYvxcqlYCGLrfmb8z+08z8HiM9tTQqp/RDBLk0oMtGozDebqRdMXUEsHCDOQkQPfAAAAaAEAAFBLAwQUAAgICACsdQRRAAAAAAAAAAAAAAAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbK2XW2/qOBDH3/dTRHmH3LkJOOohpNAWabXXZ5MYiJrEWTtQqtX57jt2QggDBbY9qFD778lvxmNP4gy/7dNE21EuYpaNdKtt6hrNQhbF2Xqk//lH0Orp38a/DN8YfxUbSgstDQfzdcY4WSZ0pO8tl4TansOfDV9Hh5/BNo5G+r9m9WnB12qVLavs1p8fYJ8mmRjpm6LIB4Yhwg1NiWiznGYwsmI8JQV0+doQOackUkGkiWGbZsdISZxVhAG/h8FWqzikPgu3Kc2KEsJpQgqYvdjEuTjQ9tFdvIiTN8jUIZ5GiH45UvMs94yXxiFngq2KdsjSKrTzWfaN/sk80/CewFLCX7d5C8A5TG4ZJ3HxrmJsBETOSfeHRMKadJ6puzCWC6nfxXLjHVH2J1lezbKPMOeTsE4Nc/TxMIphr8iOxulqpD9Yg4WnG+OhuuCvmL6JRlsryPJ3mtCwoFADlq7Jwlky9ioH5yCZQBTKQBIJ/NvRCU0SAMPaiH9KHx3pwKipzfbBW6BW+1euLYmgE5b8HUfFBlxCAUd0RbZJcRR77Z5jm45le/Xgb+xtRuP1poBLQFXbYRC9+1SEUBkQZ9uWMYQsEepXS+NMTSgl+5Hu6lq4FQVLKwcF31KYa9mxTXkXgWsSkguZhhVJBK1oJcerON5VjnuT06k4nS/G06043auczk1Or+L0rnKsm5x+xelf4zj2TY7cDQokG1/KkHVYetm4QureJtkHkv3VmJwDyfncuhnl9i5v2KQg4yFnbxpX+1zkRD6XrIGEqzKx2916v9a180HpQJSS8yBBajuALkDdjT1zaOyk68rke2nSVzOTwgQL/gWIdQqZ4msCLDxiYYaFORaesPCMhRcsLBqCAbmsE2r/rITayON3LEyw4GNhioUAC49YmGFhjoUnLDxj4QULC/uDZDk/K1kOThYWJljwsTDFQoCFRyzMsDDHwhMWnrHwgoWF80GyXJSsqwlxFaTbqKQ+qsZzC8s+NZlcMPFOTfxzExeV/fSCCSrqoDSRN9zapoMwj5dsEGd27spDc5pfMHFOTZ4umLinJs8XTFBmXi6YdE5NFhdMurXJydp7/2ftvWaqe2jZvTKNZtMpsvFPAGjfBM1Br4/CNRpPmJTytTrxCXgkbWWQMsRarQ+ZUJrGme7D4VPpxhEzHm7ec8qTOHtttssL5MT4QL6P8XlkNd7OptNe1wl8sxVMLK9lWW7Qeuj1Oq2g5/TNiR90Jw/OD+WpSc/Jmi4IX8eZ0BK6UhmGheLl7Ui1C5arFjhesgJuVofeBg7ZlMserNSKseLQASfVe9QxVFeqCV2T8N3HY+pgatRvpOP/AFBLBwhZyvJH6gMAAMQOAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc62SwWoDIRBAf0W8V3fTUkqISQ9pIYdeSvoBg052JeosatPN39dSlu3CBnrY2+jg4/Fws+u9YxeMyVJQvBYVZxg0GRsaxT+Or3dPnKUMwYCjgIoH4rvt5h0d5PIitbZLrCBCUrzNuVtLmXSLHpKgDkPZnCh6yOUYG9mBPkODclVVjzL+ZfApkx2M4vFgas6OEBvMinuwLtO6mFyfDWhNQpMf1m9kittLnzEGcOX22uF/hOh0shr3pD89hjzjJdtCis6GM5fziqtRUQhpInyVdElevNv/zrUo85JKI/qW0/3EqXT6QaVa9MuKDOBbGg/zaczQZWEdM0aRkw+6/QZQSwcIDfecMv0AAADmAgAAUEsDBBQACAgIAKx1BFEAAAAAAAAAAAAAAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDMueG1srZdtc6o4FMff76dgeK88IzrqnV6RaltndvbxdYSoTIGwCT50du533yQghSNVt71OtcmfP7+cHM5BHH87pYlywJTFJJuoRl9XFZyFJIqz7UT984+g56nfpr+Mj4S+sh3GhZKGo+U2IxStEzxRT4aNQuVE+Z/J35bKP0b7OJqo/+rVq8ffRq8cGeW0fv3g/jTJ2ETdFUU+0jQW7nCKWJ/kOONHNoSmqOBTutVYTjGKZBBpopm67mopirOKMKL3MMhmE4fYJ+E+xVlRQihOUMF3z3Zxzs60U3QXL6LoyDN1jqcRol8eqXmGfcFL45ASRjZFPyRpFdrlLofasLXPNLwnsBTR133e4+Ccb24dJ3HxJmNsBIQuSfeHhMKadJmpuzCGzVN/iEXhvaPMT7KcmmW+w6xPwtwaZqnTcRTzWhETheLNRH0wRitH1aZjecJfMT6yxlgp0Pp3nOCwwLwHNihhWFVE86wJeRWGJZd1TmXSJKiI/zvgGU4SDufXh/1TruOKRbSa3ByfVwzkFf+VKmvE8Iwkf8dRseNdzJs4whu0T4p30et7lqlbhunUB38jxwWOt7uCn8JVWRKj6M3HLOTdwePsmyKGkCRMfippLO4RqpKi00S1VSXcs4Kk1QIF3Yu9lhNTF3cSfk6CciZSIY9qDYxTYZyrGPsWxq0w7teiGVSYwVWMewvjVRjvKsa4hRlWmOE1jGXewog6kBwx+Ep2jPM1F4MroMFNkHkGmV+MyDqDrE9dMa0s6vJWjQo0HVNyVKisbpYj8Y1kjARbNofZH9RlWnfMBw3DgxScBwGShcB1xtXD1NHH2kEsXVm+l5ah3JgQZlDwOyBGGzKH5wRQeITCAgpLKDxB4RkKL1BYNQSN57JOqPmzEmqCFb9DYQYFHwpzKARQeITCAgpLKDxB4RkKL1BYmR8ky/pZybJgsqAwg4IPhTkUAig8QmEBhSUUnqDwDIUXKKysD5Jlg2RdTYgtIcJWt9IQtGOHxTDbnlmXx2l7/A6PDVp/3uUBnR1UHrPhcUE8jx0cF3AWHR4HcJZdHqvteery2G3Pc5cH5Oely+O2Pasuz6D2tMrA+T9l4DQT7oECcMpF9eaiwOO3AKCCguZBZwjC1RpfNimmW/nIx/iX014EKUKs1fpJk3epdqH7/AlU6to7ZjreveWYJnH22hyXJ4iN0ZH4UUaXkdH4iTafewMr8PVeMDOcnmHYQe/B89xe4FlDfeYHg9mD9UOu1KTnaItXiG7jjCkJ3sgM8+cmWt6Z5LgguRzxhdek4Pet82zHn7QxFTN+pTaEFOeJWKT+kTn9D1BLBwiZjxVM2QMAAJcOAABQSwMEFAAICAgArHUEUQAAAAAAAAAAAAAAACMAAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0My54bWwucmVsc63SzWoCMRDA8VcJc2+ya6EUMerBFjz0UuwDDMm4G0wyS5La9e0bKWIXLPTgLR/kz48hi9UYvDhSyo6jhlY2ICgati52Gj52rw/PIHLBaNFzJA2RYbVcvJPHUl/k3g1Z1ETMGvpShrlS2fQUMEseKNabPaeApW5TpwY0B+xIzZrmSaXfDZg2xdZqSFvbgthh6qhoCOh84XmVnNYWjWFpOFyu39hW28tYKEX09fQ00H9AvN87Qxs2n4FiueFSfS0l7+IB1G3i7EqUUtmEX3V0WR2D3/ysW1nX9yRd03+ZHiemOqdzKrdyvC/kEj4z1ORLLL8BUEsHCIiJ6rHyAAAAWAIAAFBLAQIUABQACAgIAKx1BFHAApDHeAEAAPUGAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAICAgArHUEUW5D+iLjAAAASQIAAAsAAAAAAAAAAAAAAAAAuQEAAF9yZWxzLy5yZWxzUEsBAhQAFAAICAgArHUEUQJGEdt0AQAAFwMAABAAAAAAAAAAAAAAAAAA1QIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAgICACsdQRRW8CuDTkBAAA/AgAAEQAAAAAAAAAAAAAAAACHBAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAgICACsdQRRr7Z/u2gBAAB4AgAAEAAAAAAAAAAAAAAAAAD/BQAAeGwvY29tbWVudHMxLnhtbFBLAQIUABQACAgIAKx1BFF207COdQAAAIIAAAAYAAAAAAAAAAAAAAAAAKUHAAB4bC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECFAAUAAgICACsdQRRUloxDDACAABCBAAAGwAAAAAAAAAAAAAAAABgCAAAeGwvZHJhd2luZ3Mvdm1sRHJhd2luZzEudm1sUEsBAhQAFAAICAgArHUEUaGAXnNIBQAAIBMAABQAAAAAAAAAAAAAAAAA2QoAAHhsL3NoYXJlZFN0cmluZ3MueG1sUEsBAhQAFAAICAgArHUEUcatAAHYAwAA+xAAAA0AAAAAAAAAAAAAAAAAYxAAAHhsL3N0eWxlcy54bWxQSwECFAAUAAgICACsdQRRbppOcoUGAAC0IAAAEwAAAAAAAAAAAAAAAAB2FAAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQACAgIAKx1BFGhvwtvjAIAACIGAAAPAAAAAAAAAAAAAAAAADwbAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAgICACsdQRR3UKoF/QAAADRAwAAGgAAAAAAAAAAAAAAAAAFHgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAgICACsdQRRMxpi8ysEAADFEwAAGAAAAAAAAAAAAAAAAABBHwAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAICAgArHUEUTOQkQPfAAAAaAEAACMAAAAAAAAAAAAAAAAAsiMAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQxLnhtbC5yZWxzUEsBAhQAFAAICAgArHUEUVnK8kfqAwAAxA4AABgAAAAAAAAAAAAAAAAA4iQAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLAQIUABQACAgIAKx1BFEN95wy/QAAAOYCAAAjAAAAAAAAAAAAAAAAABIpAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc1BLAQIUABQACAgIAKx1BFGZjxVM2QMAAJcOAAAYAAAAAAAAAAAAAAAAAGAqAAB4bC93b3Jrc2hlZXRzL3NoZWV0My54bWxQSwECFAAUAAgICACsdQRRiInqsfIAAABYAgAAIwAAAAAAAAAAAAAAAAB/LgAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDMueG1sLnJlbHNQSwUGAAAAABIAEgDMBAAAwi8AAAAA
------AdaptivePlanningAPIBoundary173bb6faa3d--

Save the Error Report Spreadsheet File

The Error Report.xlsx in the response is base64 encoded data. To open it in Microsoft Excel, convert the data from base64 to binary and then save it as a binary file.

Steps to convert the data in the response to an error report spreadsheet with text editor:

Open a text editor supports Hexadecimal encoding, like Sublime Text.
Create a new file, save it with name error_report.xlsx.
Click File > Reopen with Encoding > Hexadecimal.
Use a tool like Cryptii to convert the base64 data to hex. Remember to remove the tailing newline character.
Copy the converted data to the text editor, then save.
The file should open with Microsoft Excel.

Error Message Descriptions

Type	Message	Example/Description
Error	Missing import operation attribute.	The operation attribute is not specified.
Error	Invalid operation attribute.	The operation specified in the request is not valid. Valid value is "update" or "replaceAll".
Error	Invalid request format.	The request part is not valid XML data.
Error	Dimension Access Control is not enabled in this instance.	The target instance doesn't have DAC enabled.
Error	Invalid spreadsheet file	The uploaded file is not a valid spreadsheet file, make sure that is a .xls or .xlsx file.
Error	Error occurred, refer to the error sheet for detailed error.	There are some data errors in the uploaded spreadsheet file.