updateAccessRules

Adaptive Planning

updateAccessRules

Com suporte na API v24+

updateAccessRules requires Conceito: regras de acesso.

Categoria	Modificação das regras de acesso
Descrição	Atualize ou substitua um conjunto de regras de acesso existentes de um arquivo de planilha de regras de acesso.
Permissões obrigatórias para invocar	Usuários atualizado na API v31
Parâmetros obrigatórios na solicitação	Credenciais, importOption

O método permite que o usuário carregue um arquivo de planilha para atualizar as regras de acesso. O tipo de conteúdo da solicitação de método é multipart/form-data.

Formato da solicitação

A chave é request, o valor é conteúdo xml, que contém uma etiqueta de credenciais para identificar e autorizar o usuário que está fazendo a chamada e uma etiqueta importOption para especificar a operação. O usuário deve ter permissão de "Administrador" para atualizar as regras de acesso.

A chave é o conteúdo, arquivo de planilha a ser importado. Arquivos de planilha com as extensões .xls e .xlsx têm suporte. O arquivo é o mesmo que os arquivos usados na importação das regras de acesso de UI.

Exemplo

Dados do formulário do corpo da solicitação HTTP
Chave	Valor	Tipo de conteúdo
solicitação	<?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
conteúdo	access_rules_template.xlsx

Exemplo de solicitação completa


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--

Formato de modelo XLSX

Consulte as seções Complete the Template ou Edit de Etapas: criar regras de acesso para visualizar o formato do arquivo .xlsx do modelo de regras de acesso.

elemento de credenciais
Nome da etiqueta		credenciais
Descrição		Todas as chamadas de API devem conter um único elemento de credenciais para identificar o usuário que invoca a API. A chamada à API é então executada como este usuário (qualquer trilha de auditoria ou histórico de ações no sistema mostrará que este usuário executou a ação) e, portanto, o usuário deve ter as permissões necessárias para executar a ação para que a chamada à API funcione. bem-sucedido.
Atributos do elemento
Nome do atributo	Obrigatório?	Valor	Exemplo
login	S	O nome de logon do usuário que invoca o método de API. Esse usuário deve ter uma função que contenha as permissões necessárias para o método que está sendo invocado.	sampleuser@company.com
senha	S	A senha do usuário que invoca o método de API.	my_password
parâmetros regionais	N	Especifique os parâmetros regionais a serem usados para interpretar números e datas de entrada e para formatar números e datas de saída (usando o separador de milhares, nomes de meses e formatação de data adequados). Os parâmetros regionais também são usados para especificar o idioma em que as mensagens do sistema na resposta devem ser exibidas. Se não especificado, en_US (inglês americano) é usado.	fr_FR
instanceCode	N	Se o usuário especificado nas credenciais tem acesso a mais de uma instância do Adaptive Planning , esse atributo pode ser usado para especificar que o usuário pretende acessar uma instância diferente da instância por padrão. Se não for especificada, a instância por padrão do usuário será usada. Para determinar os códigos de instância disponíveis, use a API exportInstances.	MYINSTANCE1
Conteúdo do elemento
(nenhum)

importOption element
Nome da etiqueta		importOptions
Descrição		Especifica uma operação para atualizar as regras de acesso.
Atributos do elemento
Nome do atributo	Obrigatório?	Valor	Exemplo
operação	S	"atualizar" ou "substituirTodos" "atualizar": Substitui as regras de acesso dos usuários ou grupos mencionados na solicitação. Por exemplo, digamos que você adicione uma regra no modelo para o grupo Contadores. A atualização substitui todas as regras existentes do grupo Contadores pela nova regra. Se você pretende adicionar outra regra a esse grupo, antes é necessário exportar as regras existentes e depois adicionar a regra nova. Dessa forma, a importação inclui as regras existentes e a nova regra. Adiciona regras a novos usuários ou grupos. Por exemplo, digamos que o modelo tenha regras somente para novos usuários ou grupos que antes não tinham regras. A atualização adiciona as novas regras e deixa todas as regras existentes como estão. "replaceAll": exclui todas as regras existentes e adiciona as regras que estão na solicitação.	atualizar
Conteúdo do elemento
(nenhum)

Exemplo de CURL


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

Formato da resposta

Existem dois tipos de conteúdo possíveis para a resposta:

Quando a solicitação é bem-sucedida ou há erros não relacionados ao conteúdo da planilha carregada, o tipo de conteúdo é text/xml.

Quando a planilha carregada contém erros, o tipo de conteúdo é em várias partes/misto. O corpo da resposta contém duas partes:

A primeira parte são os dados xml e representam o status da solicitação.

A segunda parte é o arquivo de planilha de relatório de erros codificado em base64.

Exemplo

Resposta sem erros de planilha


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>

Resposta com erros de planilha


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--

Salvar o arquivo de planilha do relatório de erros

O campo Error Report.xlsx na resposta contém dados codificados em base64. Para abri-lo no Microsoft Excel, converta os dados de base64 em binário e salve-os como um arquivo binário.

Etapas para converter os dados na resposta em uma planilha de relatório de erros com editor de texto:

Abrir um editor de texto oferece suporte à codificação Hexadecimal, como Texto Sublime.

Crie um novo arquivo e salve-o com o nome error_report.xlsx.

Clique em Arquivo > Reabrir com codificação > Hexadecimal.

Use uma ferramenta como o Cryptii para converter os dados de base64 em hexadecimais. Lembre-se de remover o caractere de nova linha à direita.

Copie os dados convertidos no editor de texto e salve.

O arquivo deve ser aberto no Microsoft Excel.

Descrições de mensagens de erro

Tipo	Mensagem	Exemplo/Descrição
Erro	Atributo de operação de importação ausente.	O atributo de operação não foi especificado.
Erro	Atributo de operação inválido.	A operação especificada na solicitação não é válida. O valor válido é "update" ou "replaceAll".
Erro	Formato de solicitação inválido.	A parte da solicitação não contém dados XML válidos.
Erro	O controle de acesso à dimensão não está habilitado nesta instância.	A instância de destino não tem o DAC habilitado.
Erro	Arquivo de planilha inválido	O arquivo carregado não é um arquivo de planilha válido. Certifique-se de que ele é um arquivo .xls ou .xlsx.
Erro	Ocorreu um erro. Consulte a planilha de erros para obter informações detalhadas sobre o erro.	Existem alguns erros de dados no arquivo de planilha carregado.