Sample code for 30+ languages & platforms
Visual FoxPro Requires Chilkat v11.0.0+

Jira Cloud: List Accessible Projects

See more Jira Examples

Retrieve every page of projects visible to the account and display each project key, name, and ID. Jira may cap the requested page size; the loop advances by the number of entries returned. An empty list can mean the account lacks project access.

The code uses an Atlassian account email and an API token without scopes with the site URL. For a scoped API token, keep Basic authentication and change baseUrl to https://api.atlassian.com/ex/jira/YOUR_CLOUD_ID. For OAuth2, use that gateway URL, omit Login/Password/BasicAuth, and set http.AuthToken to the access token. See API token authentication and OAuth2 authorization. The account must have permission for the operation; OAuth scopes do not grant additional Jira permissions.

Targets Jira Cloud. Jira Data Center has a separate REST API and may require different paths, authentication, or payloads.

Atlassian REST API documentation

Chilkat Visual FoxPro Downloads

Visual FoxPro
LOCAL lnSuccess
LOCAL loHttp
LOCAL lcBaseUrl
LOCAL loUrl
LOCAL loResp
LOCAL loReply
LOCAL lnPageStart
LOCAL lnPageMore
LOCAL loPageOffset
LOCAL lnPageCount
LOCAL lnPageIndex

lnSuccess = 0

*  Assumes Chilkat is unlocked. See Global Unlock Sample.

loHttp = CreateObject('Chilkat.Http')
loHttp.RequireSslCertVerify = 1
loHttp.BasicAuth = 1
*  Read these credentials from private application configuration.
loHttp.Login = "YOUR_ATLASSIAN_EMAIL"
loHttp.Password = "YOUR_API_TOKEN"
lcBaseUrl = "https://your-domain.atlassian.net"
loHttp.Accept = "application/json"
loUrl = CreateObject('Chilkat.StringBuilder')
loResp = CreateObject('Chilkat.HttpResponse')
loReply = CreateObject('Chilkat.JsonObject')
lnPageStart = 0
lnPageMore = 1
loPageOffset = CreateObject('Chilkat.StringBuilder')
DO WHILE (lnPageMore = 1)
    loPageOffset.Clear()
    loPageOffset.AppendInt(lnPageStart)
    loHttp.SetUrlVar("offset",loPageOffset.GetAsString())
    loUrl.SetString(lcBaseUrl)
    loUrl.Append("/rest/api/3/project/search?startAt={$offset}&maxResults=50")
    lnSuccess = loHttp.HttpNoBody("GET",loUrl.GetAsString(),loResp)
    IF (loResp.StatusCode = 0) THEN
        ? "No HTTP response was received. Check connectivity and TLS settings."
        RELEASE loHttp
        RELEASE loUrl
        RELEASE loResp
        RELEASE loReply
        RELEASE loPageOffset
        CANCEL
    ENDIF

    IF ((lnSuccess <> 1) OR (loResp.StatusCode < 200) OR (loResp.StatusCode >= 300)) THEN
        ? "Request failed. HTTP " + STR(loResp.StatusCode)
        IF (loResp.StatusCode = 429) THEN
            ? "Rate limited. Retry-After: " + loResp.GetHeaderField("Retry-After")
        ENDIF

        *  Inspect this response locally; it can contain private Jira data.
        ? loResp.BodyStr
        RELEASE loHttp
        RELEASE loUrl
        RELEASE loResp
        RELEASE loReply
        RELEASE loPageOffset
        CANCEL
    ENDIF

    lnSuccess = loReply.Load(loResp.BodyStr)
    IF (lnSuccess <> 1) THEN
        ? "Expected a JSON object in the response."
        RELEASE loHttp
        RELEASE loUrl
        RELEASE loResp
        RELEASE loReply
        RELEASE loPageOffset
        CANCEL
    ENDIF

    IF (loReply.JsonTypeOf("values") <> 4) THEN
        ? "Expected an array: values"
        RELEASE loHttp
        RELEASE loUrl
        RELEASE loResp
        RELEASE loReply
        RELEASE loPageOffset
        CANCEL
    ENDIF

    lnPageCount = loReply.SizeOfArray("values")
    lnPageIndex = 0
    DO WHILE (lnPageIndex < lnPageCount)
        loReply.I = lnPageIndex
        ? loReply.StringOf("values[i].key") + "  " + loReply.StringOf("values[i].name") + "  ID: " + loReply.StringOf("values[i].id")
        lnPageIndex = lnPageIndex + 1
    ENDDO
    lnPageStart = lnPageStart + lnPageCount
    lnPageMore = (loReply.BoolOf("isLast") <> 1)
    IF ((lnPageMore = 1) AND (lnPageCount = 0)) THEN
        ? "Pagination made no progress; stopping."
        RELEASE loHttp
        RELEASE loUrl
        RELEASE loResp
        RELEASE loReply
        RELEASE loPageOffset
        CANCEL
    ENDIF

ENDDO

RELEASE loHttp
RELEASE loUrl
RELEASE loResp
RELEASE loReply
RELEASE loPageOffset