---
title: "How to create a profile with a URL"
canonical: "https://support.appfire.com/space/TBL/74814748/How%20to%20create%20a%20profile%20with%20a%20URL"
format: markdown
---
## <span style="color: #000000">Description</span>

<span style="color: #000000">This article illustrates how to create a profile for use with the</span><span style="color: #000000"> </span><span style="color: #000000">*CSV Table*</span><span style="color: #000000"> and </span><span style="color: #000000">*JSON Table*</span><span style="color: #000000"> macros using a URL.</span>

> ℹ️ ## <span style="color: #000000">Before you begin:</span>
> ℹ️ 
> ℹ️ - <span style="color: #000000">Before you enter the URL for a repository, ensure that it complies with the REST standards published by GitHub or GitLab.</span>
> ℹ️   - [Click here](https://docs.gitlab.com/ee/api/repository_files.html) <span style="color: #000000">for more information on REST Pattern for GitLab.</span>
> ℹ️   - [Click here](https://developer.github.com/v3/) <span style="color: #000000">for more information on REST Pattern for GitHub.</span>
> ℹ️ - <span style="color: #000000">Know what is a complete URL. A typical path for the raw file on GitLab looks like:</span>
> ℹ️ 
> ℹ️ <sup>    /projects/:id/repository/files/:file_path/raw</sup>
> ℹ️ 
> ℹ️ - <span style="color: #000000">Since the host address begins with:</span>
> ℹ️ 
> ℹ️ <sup>     https://gitlab.com/api/v4</sup>
> ℹ️ 
> ℹ️ - <span style="color: #000000">The complete URL, in this example, looks like: </span>
> ℹ️ 
> ℹ️ <sup> https://gitlab.com/api/v4/projects/:id/repository/files/:file_path/raw?ref=master</sup>
> ℹ️ 
> ℹ️ - <span style="color: #000000">For illustrative purposes, we have used a public</span> [Bitbucket public repository](https://bitbucket.org/bob_swift/gint/src/default/README.md). <span style="color: #000000">The process for adding a profile and using it in macros remains the same for other repositories and external sources.</span>
> ℹ️ - <span style="color: #000000">Verify that the URL conforms to the Confluence Whitelist; provided, whitelisting is enabled in </span><span style="color: #000000">[Configuration](https://appfire.atlassian.net/wiki/x/qp51B#at810_config_RestrictURLs)</span><span style="color: #000000"> settings.</span>

  
<span style="color: #000000">There are three ways to work with URLs where you can use:</span>

- <span style="color: #000000">An </span><span style="color: #000000">[absolute URL](#at810_HowTo_CompleteURL)</span><span style="color: #000000"> in a profile</span>
- <span style="color: #000000">A </span><span style="color: #000000">[base URL](#at810_HowTo_FixedURL)</span><span style="color: #000000"> in a profile</span>
- <span style="color: #000000">An </span><span style="color: #000000">[absolute URL directly](#at810_HowTo_AbsoluteURL)</span><span style="color: #000000"> instead of via a profile </span>

> ℹ️ <span style="color: #000000">The examples on this page use the </span><span style="color: #000000">*CSV Table*</span><span style="color: #000000"> macro. Refer to the</span> [JSON Table macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74813238) <span style="color: #000000">documentation to know more about the macro's parameters relevant to profiles.</span>

# > Macro (anchor)

<span style="color: #000000">Using an absolute URL in a profile</span>

<span style="color: #000000">You can create a profile by providing the complete URL to access the CSV or JSON content.</span>

1. <span style="color: #000000">Navigate</span><span style="color: #000000"> to </span><span style="color: #000000">***CONFLUENCE ADMINISTRATION > Settings > Manage apps > Advanced Tables > Profiles.***</span>
2. <span style="color: #000000">Click </span><span style="color: #000000">**Add Profile**</span><span style="color: #000000">.</span>
3. <span style="color: #000000">Enter a unique name for the profile in the </span><span style="color: #000000">*Profile name*</span><span style="color: #000000"> text box. For this example, enter </span><span style="color: #000000">**BitbucketFullURL**</span><span style="color: #000000"> in the text box.</span>
4. <span style="color: #000000">Select </span><span style="color: #000000">*URL*</span><span style="color: #000000"> from the options in </span><span style="color: #000000">*Profile type*</span><span style="color: #000000">. </span>
5. <span style="color: #000000">Enter</span> <span style="color: #000000">**https://bitbucket.org/bobswift-test/testfiles/raw/66f9cf5ba2bfe3890caf9dc2d89e81b59210a5e6/Rows-5k.csv**</span> <span style="color: #000000">in the </span><span style="color: #000000">*URL*</span><span style="color: #000000"> text box. </span>
6. <span style="color: #000000">Click </span><span style="color: #000000">**Save profile**</span><span style="color: #000000"> to create the profile.</span>

<span style="color: #000000">To use this profile in a Confluence page:</span>

1. <span style="color: #000000">Search for the </span><span style="color: #000000">*CSV Table*</span><span style="color: #000000"> macro</span><span style="color: #000000"> and edit it.</span>
2. <span style="color: #000000">Select </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> in </span><span style="color: #000000">***Data source > Method of locating script***</span><span style="color: #000000">.</span>
3. <span style="color: #000000">Select </span><span style="color: #000000">**BitbucketFullURL**</span><span style="color: #000000"> from the </span><span style="color: #000000">*Profiles*</span><span style="color: #000000"> drop-down list, and then, click </span><span style="color: #000000">**Save**</span><span style="color: #000000">.</span>

# > Macro (anchor)

<span style="color: #000000">Using a base URL in a profile</span>

<span style="color: #000000">You can create a profile by providing a base URL and then, enter the relative path to the relevant files in the </span><span style="color: #000000">*CSV Table*</span><span style="color: #000000"> macro.</span>

1. <span style="color: #000000">Navigate to </span><span style="color: #000000">***CONFLUENCE ADMINISTRATION > Settings > Manage apps > Advanced Tables > Profiles.***</span>
2. <span style="color: #000000">Click </span><span style="color: #000000">**Add Profile**</span><span style="color: #000000">.</span>
3. <span style="color: #000000">Enter a unique name for the profile in the </span><span style="color: #000000">*Profile name*</span><span style="color: #000000"> text box. For this example, enter </span><span style="color: #000000">**BitbucketProfile**</span><span style="color: #000000"> in the text box.</span>
4. <span style="color: #000000">Select </span><span style="color: #000000">*URL*</span><span style="color: #000000"> from the options in </span><span style="color: #000000">*Profile type*</span><span style="color: #000000">. </span>
5. <span style="color: #000000">Enter</span> <span style="color: #000000">**https://bitbucket.org/bobswift-test/**</span> <span style="color: #000000">in the </span><span style="color: #000000">*URL*</span><span style="color: #000000"> text box.</span>
6. <span style="color: #000000">Click </span><span style="color: #000000">**Save profile **</span>to create the profile.

<span style="color: #000000">To use this profile in a Confluence page:</span>

1. <span style="color: #000000">Search for the </span><span style="color: #000000">*CSV Table*</span><span style="color: #000000"> macro and edit it.</span>
2. <span style="color: #000000">Select </span><span style="color: #000000">*Profile*</span><span style="color: #000000"> in </span><span style="color: #000000">***Data source > Method of locating script***</span><span style="color: #000000">.</span>
3. <span style="color: #000000">Select </span><span style="color: #000000">**BitbucketProfile**</span><span style="color: #000000"> from the </span><span style="color: #000000">*Profiles*</span><span style="color: #000000"> drop-down list in the editor.</span>
4. <span style="color: #000000">Enter the relative path to the</span> CSV<span style="color: #000000"> file in the </span><span style="color: #000000">*URL of CSV data*</span><span style="color: #000000"> parameter.</span>
5. <span style="color: #000000">Click</span> **Save**<span style="color: #000000">.</span>

> ℹ️ <span style="color: #000000">This method allows multiple users to access a profile across pages and instances of the </span><span style="color: #000000">*CSV Table *</span><span style="color: #000000">and</span><span style="color: #000000">* JSON Table *</span><span style="color: #000000">macros.</span>

# > Macro (anchor)

<span style="color: #000000">Using an absolute URL directly</span>

<span style="color: #000000">You can skip creating a profile entirely and enter an absolute URL in the </span><span style="color: #000000">*URL of CSV *</span><span style="color: #000000">*data*</span><span style="color: #000000"> parameter.</span>

1. <span style="color: #000000">In a Confluence page, search for the </span><span style="color: #000000">*CSV Table*</span><span style="color: #000000"> macro and edit it.</span>
2. <span style="color: #000000">Enter</span> <span style="color: #000000">**https://bitbucket.org/bobswift-test/testfiles/raw/4e437c71635ac79f796456495807fb6c65218c84/Rows-5k.csv**</span> <span style="color: #000000">in the the </span><span style="color: #000000">*URL of CSV*</span><span style="color: #000000"> </span><span style="color: #000000">*data*</span><span style="color: #000000"> parameter.</span>
3. <span style="color: #000000">Click </span><span style="color: #000000">**Save.**</span>