Versions Compared

Old Version 1

changes.mady.by.user Sunita Patro

Saved on

compared with

New Version Current

changes.mady.by.user Harshitha Udayashankar (Inactive)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...


Warning
titleRemoval notice:

Please note that the URL user and URL user password parameters were removed in 3.4.2 (see Deprecation notice: URL user and URL user password parameters). We recommend using profiles to access external data.


Note
titleException:

This article is not applicable to the following macros:

  • Space graph
  • Graph from table

This article illustrates how to create a profile using with a URL and for this scenario, the profile is then specified in the Excel Graphviz macro. 

Info

Before you begin:

  • Before you enter the URL for a repository, ensure that it is a raw URL.
    A raw URL is defined as the part of the URL following the domain information and includes the query string, if present. For example, in the URL string http://www.contoso.com/articles/recent.aspx, the raw URL is /articles/recent.aspx. 

    Tip
    titleHow to identify if a file is valid for the macro?

    Paste the file link into your browser's address bar. If the actual code is displayed in the browser, it is considered to be invalid or in an incorrect format. If the file downloads to your system, the macro can process the file and its contents.


  • Know what is a complete URL.
    • A typical path for the raw file on GitLab looks like:
      /projects/:id/repository/files/:file_path/raw
    • Since the host address begins with:
      https://gitlab.com/api/v4
    • The complete URL, in this example, looks like: 
      https://gitlab.com/api/v4/projects/:id/repository/files/:file_path/raw?ref=master

  • For illustrative purposes, a public Bitbucket public repository is used. Use URLs to add to profiles and in macros as per your requirement and your instance. The process for adding a profile and using it in macros remains the same for other repositories and external sources. 

    Note
    titleFor private Bitbucket repositories (from third party applications):

    Use the following URL path to connect to a private Bitbucket repository if logging in from third party applications such as Google:

    https://api.bitbucket.org/2.0/repositories/$workspace/$repo/src/$commit/$filepath

    The path to be specified in the URL parameter of a profile looks like the following example:

    https://api.bitbucket.org/2.0/repositories/appfire/ac-app-dist/src/17f199444d1386c543ac642e9155b396aaeca403/sample.txt



You can work with URLs in two ways where you can:

Anchor
md_URLProfile_absURL
md_URLProfile_absURL
Use an absolute URL

You can create a profile by providing the absolute URL to access the Excel Graphviz content from a remote location.

  1. Navigate to CONFLUENCE ADMINISTRATION > General Configuration Manage Apps > BOB SWIFT CONFIGURATION > Excel > Graphviz > Profiles.

  2. Click Add Profile.

  3. Enter a unique name for the profile in the Profile name text box.
  4. Select URL from the options in Profile type. 

  5. Enter the relevant absolute URL of the location to be accessed in the URL text box.

  6. Click Save profile to create a profile.

...

To use this profile in a Confluence page:

  1. Add the Excel macro Graphviz macro, or edit an existing macro on a page.
  2. Select the newly created profile, in this case BitURL, from the Profile drop-down, and click Save.

...

  1.         

Anchor
md_URLProfile_partialURL
md_URLProfile_partialURL
Use a partial URL

You can create a profile by providing a partial URL for the Excel the Graphviz content, and enter the relative path to the Excel the Graphviz file in the Excel macro Graphviz macro.

  1. Navigate to CONFLUENCE ADMINISTRATION > General Configuration Manage apps > BOB SWIFT CONFIGURATION > Excel > > Graphviz > Profiles.

  2. Click Add Profile.

  3. Enter a unique name for the profile in Profile name.
  4. Select URL from the options in Profile type. 

  5. Enter the base URL in Enter the base URL in the URL text box. A  A base URL is a part of the path that specifies the location that the macro must access.

  6. Click Save profile to create a profile.

...

To use the profile in a Confluence page:

  1. Add the Excel macro Graphviz macro, or edit an existing macro on a page.
  2. Select the newly created profile in Profile in the macro editor. 
  3. Enter the relative path of the Excel file in the Graphviz file in the URL to Excel to Graphviz file parameter. The relative URL is appended to the base URL specified in the profile to create an absolute path to the file to be rendered.
  4. Click Save.

...

  1. For example, consider:
    Base URL given in the profile: https://api.bitbucket.org/2.0 
    Relative path given in the macro editor: /repositories/appfire/ac-app-dist/src/17f199444d1386c543ac642e9155b396aaeca403/sample.txt
    The macro combines the two to refer to the absolute path to the required file as https://api.bitbucket.org/2.0/repositories/appfire/ac-app-dist/src/17f199444d1386c543ac642e9155b396aaeca403/sample.txt.
  2. Click Save.
Info
titlePoints to remember!
  • Only raw URLs must be given in either, the URL field in parameter in profiles or the URL to markdown to Graphviz/Diagraph/Graph/PlantUML file field parameter in the macro.
  • It is recommended to specify absolute URLs to access files from public locations and to use profiles to access files from private sources. For example, a raw URL that can access an Excel an Graphviz file in a public Bitbucket repository is valid. But to render an Excel an Graphviz file located in a private repository, we recommend using a profile.
  • Profiles are a means to access and retrieve contents from external applications such as Bitbucket, GitLab or GitHub. A profile already contains the base URL and the required credentials (user credentials or an access token) to access the relevant application.
  • This method allows multiple users to access a profile across pages and instances of the macros.

Addition

...

references