Qodex.ai

Export Cloud Accounts

POST {{cb_url}}/public-cloud/account-management/v1/orgs/{{cb_org_key}}/accounts/_search/download

Export Cloud Accounts

Permissions Required

Permission (.notation name)Operation(s)
public.cloud.accountsREAD

Request Schema

{
  "start": <integer>,
  "rows": <integer>,
  "query": "<string>",
  "criteria": {
    "name": [ "<string>" ],
    "cloud_provider": [ "<string>" ],
    "cloud_provider_account_id": [ "<string>" ],
    "credential.verification_status": [ "<string>" ],
    "environment": [ "<string>" ],
    "parent_account_id": ["<string>"],
    "is_onboarded": <boolean>
  },
  "sort": [
    {
      "field": "<string>",
      "order": "<string>"
    }
  ]
}

See Documentation

Request Body

{"start"=>0, "rows"=>0, "criteria"=>{"name"=>["AWS Account 1"], "cloud_provider"=>["AWS"], "cloud_provider_account_id"=>["1234567890"], "credential.verification_status"=>["IN_PROGRESS", "SUCCESS", "FAIL"], "environment"=>["DEV", "PROD"]}, "sort"=>[{"field"=>"credential.last_verified_time", "order"=>"ASC"}]}

RESPONSES

status: OK

&quot;orgKey,accountId,accountProvider,region,accountName,accountOwnerName,accountOwnerEmail,environment,credentialRoleArn,credentialExternalId,credentialApplicationId,credentialTenantId,credentialSecretId,credentialsecretExpiry,credentialIdentityProviderProjectNo,credentialServiceAccountEmail,credentialIdentityPoolId,credentialIdentityProviderId,credentialVerificationStatus,credentialVerificationCode,credentialVerificationMessage,credentialLastVerifiedTime,createTime,createdBy,updateTime,updatedBy,regionEventChannelTemplateVersion,regionEventChannelConnected,regionEventChannelLastConnectedTime,regionEventChannelCreatedTime,regionEventChannelUpdatedTime,regionInventorySyncStatus,regionInventorySyncMessage,regionInventorySyncCode,regionInventoryLastSyncTime,regionInventoryFullSyncBy,regionCreatedTime,regionCreatedBy\r\nABCD1234,1234567890,AWS,us-east-1,AWS Account 1,Test,test@testorg.com,DEV,arn:aws:iam::1234567890:role/aws-service-role/spot.amazonaws.com/AWSServiceRoleForEC2Spot,afd5813b-e3c6-471a-b30e-3a8577f89111,,,,,,,,,FAIL,CREDENTIAL_ERROR,\&quot;User: arn:aws:sts::605728677111:assumed-role/mcs-psc-dev-cwp-pc-aws-collector-us-east-1-pod/694be2a6-mcs-psc-dev-cwp-pc-aws-collector-us-east-1-pod is not authorized to perform: sts:AssumeRole on resource: arn:aws:iam::1234567890:role/aws-service-role/spot.amazonaws.com/AWSServiceRoleForEC2Spot (Service: Sts, Status Code: 403, Request ID: ac3f0cbc-099a-4657-a6bf-9f2ccc115be2, Extended Request ID: null)\&quot;,2023-09-01T12:09:34.338372Z,2023-09-01T12:09:33.873423Z,ABCD1234,2023-09-01T12:09:33.873423Z,ABCD1234,,false,,,,FAIL,\&quot;User: arn:aws:sts::605728677111:assumed-role/mcs-psc-dev-cwp-pc-aws-collector-us-east-1-pod/694be2a6-mcs-psc-dev-cwp-pc-aws-collector-us-east-1-pod is not authorized to perform: sts:AssumeRole on resource: arn:aws:iam::1234567890:role/aws-service-role/spot.amazonaws.com/AWSServiceRoleForEC2Spot (Service: Sts, Status Code: 403, Request ID: 692c7941-c098-499c-8f64-fc48fa02a2bb, Extended Request ID: null)\&quot;,FULL_SYNC_CREDENTIAL_ERROR,2023-09-01T12:45:10.139753Z,ABCD1234,2023-09-01T12:09:33.884078Z,ABCD1234\r\n&quot;