updateAccessRules
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:
- The first part is the xml data and represents the request status.
- 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. |