Questions tagged [artifactory-query-lang]

Use this tag for questions regarding usage of the Artifactory Query Language (AQL).

Artifactory Query Language (AQL) is a query language intended to use with JFrog Artifactory, designed to let you uncover any data related to the artifacts and builds stored within Artifactory. Its syntax offers a simple way to formulate complex queries that specify any number of search criteria, filters, sorting options, and output parameters. AQL is exposed as a RESTful API which uses data streaming to provide output data resulting in extremely fast response times and low memory consumption. Currently, AQL can only extract data that resides in your instance of Artifactory, so it runs on local repositories, remote repository caches and virtual repositories.

118 questions
11
votes
1 answer

JFrog Artifactory: Difference between item, artifact, build and entry?

I have a question regarding the AQL (Artifactory Query Language) used by JFrog Artifactory to find "things" in the artifactory. The AQL seems to be very powerful, but i'm wondering how to build (correct) search queries, using the correct terms. The…
Matthias Lohr
  • 1,696
  • 2
  • 20
  • 32
7
votes
2 answers

Artifactory AQL delete empty folders

How do I delete empty folders(folders without any content) by using Artifactory AQL? I have the current AQL query to find files that are older than 12w and never downloaded, which I will delete by an script. items.find( { …
ki_
  • 619
  • 1
  • 10
  • 21
6
votes
1 answer

How to find the latest artifact version with Artifactory Query Language?

Until now, I used the Artifactory REST API to determine the last version (last snapshot) of a maven artifact with groupId and artifactIid: /api/search/latestVersion?g={groupid}&a={artifactid} This gives me exactly a string with the highest/last…
Matthias Lohr
  • 1,696
  • 2
  • 20
  • 32
6
votes
1 answer

AQL build domain object does not return results

I'm running into an issue where I'm not able to get any of the queries I'm making on the build domain object to return when using AQL When I make the following curl: curl -X GET -H "X-JFrog-Art-Api: myArtifactroyKey" -H "Cache-Control: no-cache"…
bobalink
  • 61
  • 1
4
votes
1 answer

Artifactory AQL Query Using Python 3 'Requests'

Would anybody be able to help me identify where I am going wrong with a very basic AQL I am trying to execute using Python 3 and the 'Requests' library? No matter what I do I cant seem to get past a 400: Bad Request. It is clearly something to do…
4
votes
2 answers

Artifcatory rest API to list all the Repositories

I am looking for a artifactory REST API that would list down all the repo-keys. If it could provide some more information then that would be really nice. I looked up the Artifactory REST API documentation, but couldn't find one. Did I miss anything…
Asif Kamran Malick
  • 2,409
  • 3
  • 25
  • 47
4
votes
2 answers

Artifactory aql: find builds of job with given property

I am trying to query which build number(s) produced artifacts from build foo with artifact property vcs.Revision=aabbccddee123456. In Artifactory 5.1.3. I was trying like this so far: curl -u user:apikey -i -X POST…
Florian Castellane
  • 1,197
  • 2
  • 14
  • 38
4
votes
1 answer

java HttpClient post text/plain

I have a AQL query that looks like this items.find( { "path":{"$match":"product/*"}, "size":{"$gt" : "10000"}, "type":{"$eq" : "file"} } ) and my java HttpClient looks like this String url =…
Adam Novakovi
  • 759
  • 1
  • 9
  • 18
3
votes
0 answers

List files and their size inside a zip file in JFrog Artifactory

I'm trying to list, a list of files answering a specific pattern ("*.xz" in my case) from within a zip file. The structure of my archive is this: repo_name: folder0: inner_folder: my_archive.zip my_archive_folder: …
Joseph Asaf Gardin
  • 410
  • 1
  • 4
  • 10
3
votes
0 answers

Artifactory latestVersion search for groupId that includes "." (dot)

When searching for artifactory artifact using the latestVersion API, the g= (groupId) parameter specifies the layout where the artifact should be located. If the layout includes dots, then it's unclear how to escape the dots and consider them part…
Roman Blachman
  • 227
  • 6
  • 13
3
votes
1 answer

JFrog Artifactory AQL

I am currently trying to query Artifactory for specific artifacts related to a core project. All artifacts will be prefixed with a project tag. Example: "proj1-core". I use Artifactory aql to query artifacts using name attribute. Now I also have a…
Ganesh Shenoy
  • 619
  • 1
  • 10
  • 28
3
votes
3 answers

Artifactory AQL download artifact

Is there a way to download an artifact using AQL? I have a query sent with: curl -u user:pass \ -X POST https://artifactoryURL/artifactory/api/search/aql \ -H 'content-type: text/plain' \ -T query.aql And my query.aql: items.find( { …
DavidGamba
  • 3,503
  • 2
  • 30
  • 46
3
votes
0 answers

Can I resolve dependencies of maven artifacts in artifactory?

We are currently migrating from Nexus to Artifactory and one thing we are missing is an API call to resolve maven dependencies in artifactory. Nexus has this endpoint…
3
votes
0 answers

Artifactory REST API Latest Release Version

I'm trying to develop a script to query Artifactory for artifact details. The AQL api does the trick for providing me SHA1, SIZE and location. However I need to restrict this information to a specific release. Does Artifactory provide an API…
SpaceMan
  • 126
  • 1
  • 5
3
votes
0 answers

Very slow artifactory query language

I've been trying to implement a artifact cleanup process based on https://www.jfrog.com/blog/advanced-cleanup-using-artifactory-query-language-aql/ ... but found that the AQL is really slow. i've seen queries still running after 24 hours with the…
Peter Lord
  • 51
  • 3
1
2 3 4 5 6 7 8