updateAccessRules

Adaptive Planning

updateAccessRules

Supported in API v24+

updateAccessRules requires Concept: Access Rules.

Category	Access Rules modification
Description	Update or replace a set of existing access rules from an access rules spreadsheet file.
Permissions Required To Invoke	Users updated in API v31
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.adaptiveplanning.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--

XLSX Template Format

See the Complete the Template or Edit sections of Steps: Create Access Rules to view the format for the access rules template .xlsx file.

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)

importOption element
Tag Name		importOptions
Description		Specifies an operation to update access rules..
Attributes of the Element
Attribute Name	Required?	Value	Example
operation	Y	"update" or "replaceAll" "update": Replaces the access rules of the users or groups who are mentioned in the request. For example, say you add one rule in the template for the Accountants group. Update replaces all the existing rules for the Accountant group with the one new rule. If you intend to add an additional rule to this group, export the existing rules and then add one more rule. The import then includes the existing rules as well as the new rule. Adds rules for new users or groups. For example, say the template only has rules for new users or groups that before had no rules. Update adds the news rules and leaves all existing rules as-is. "replaceAll": Deletes all existing rules and adds the rules that are in the request.	update
Contents of the Element
(none)

CURL Example


curl -F "request=<updateAccessRules.xml;type=text/xml" -F "content=@access_rules_template_jp.xlsx" https://api.adaptiveplanning.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.