Unable to automate QuickSight Export job

Q&A
, ,
1

Hi, I am trying to automate the export job using start asset bundle. Here are the steps

  1. aws quicksight list-folder-members --aws-account-id $account_id --folder-id $folder_id |jq -r ‘.FolderMemberList.MemberArn’ > arns.txt
  2. readarray -t arns <arns.txt
  3. aws quicksight start-asset-bundle-export-job --aws-account-id $account_id --asset-bundle-export-job-id XXXXXXXXXXXXXXXX
    –include-all-dependencies
    –export-format QUICKSIGHT_JSON
    –resource-arns “$arns”

I am getting an error that it is unable to recognize the arn.

Any HELP or guidance will be highly appreciated.

Thanks

1 Like
2

Hi @larry,

Thanks for posting your question. When I ran your commands, I get a jq error for the first one:
jq: error (at <stdin>:10): Cannot index array with string "MemberArn"

When I change the first command to:
aws quicksight list-folder-members --aws-account-id 123456789012 --folder-id d30f79c9-6b0c-4909-9c08-9dc892b84db8 |jq -r '.FolderMemberList[].MemberArn' > arns.txt

This succeeds and then I was able to run commands 2 and 3 as shown.

Are you able to try the above command, using ‘.FolderMemberList[].MemberArn’ instead?

Many Thanks,
Andrew

1 Like
3

@abacon It was my bad in posting my commands as I had fixed that already. However, the last command still does not work.

Actually, it returns with a status 202 but when I run

aws quicksight describe-asset-bundle-export-job …

**I get as FAILED **

Message : " 1 validation error …

Can you please confirm that it is not failing for you.

Thanks

4

Hi @larry, it’s not failing for us. I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

You could look to opening up a case with AWS and see if they can provide a solution.

Here are the steps to open a support case . If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!

1 Like
5

Thanks @Xclipse It is not solved. I will try to open a support cas OR I can start using Python.

1 Like
6

Thanks @larry. Consider creating a new post with more detailed information to invite more community members to join the discussion. After a few days, posts can get lost in the feed. Clarity is key—ensure you explain the problems clearly, include screenshots and sample code, and maybe even provide a sample in Arena.