helix-query.yaml

version: 1

indices:
  blog:
    source: html
    fetch: https://{repo}-{owner}.hlx.page/{path}
    include:
      - '/express/learn/blog/*'
    target: /express/learn/blog/query-index.xlsx
    properties:
      author:
        select: head > meta[name="author"]
        value: |
          attribute(el, 'content')
      title:
        select: head > meta[property="og:title"]
        value: |
          attribute(el, 'content')
      date:
        select: head > meta[name="publication-date"]
        value: |
          parseTimestamp(attribute(el, 'content'), 'MM/DD/YYYY')
      image:
        select: head > meta[property="og:image"]
        value: |
          match(attribute(el, 'content'), 'https:\/\/[^/]+(\/.*)')
      teaser:
        select: head > meta[name="description"]
        value: |
          attribute(el, 'content')
      category:
        select: head > meta[name="category"]
        value: |
          attribute(el, 'content')
      tags:
        select: head > meta[property="article:tag"]
        values: |
          attribute(el, 'content')
      description:
        select: head > meta[name="description"]
        value: |
          attribute(el, 'content')
      lastModified:
        select: none
        value: |
          parseTimestamp(headers['last-modified'], 'ddd, DD MMM YYYY hh:mm:ss GMT')

  website: &default
    source: html
    fetch: https://{repo}-{owner}.hlx.page/{path}
    include:
      - '/express/**'
    exclude:
      - '/express/learn/blog/*'
    target: /express/query-index.xlsx
    properties:
      title:
        select: head > meta[property="og:title"]
        value: |
          attribute(el, 'content')
      image:
        select: head > meta[property="og:image"]
        value: |
          match(attribute(el, 'content'), 'https:\/\/[^/]+(\/.*)')
      lastModified:
        select: none
        value: |
          parseTimestamp(headers['last-modified'], 'ddd, DD MMM YYYY hh:mm:ss GMT')
      shortTitle:
        select: head > meta[name="short-title"]
        value: |
          attribute(el, 'content')
      robots:
        select: head > meta[name="robots"]
        value: |
          attribute(el, 'content')

  germany:
    <<: *default
    include:
      - '/de/express/**'
    target: /de/express/query-index.xlsx

  spain:
    <<: *default
    include:
      - '/es/express/**'
    target: /es/express/query-index.xlsx

  france:
    <<: *default
    include:
      - '/fr/express/**'
    target: /fr/express/query-index.xlsx

  italy:
    <<: *default
    include:
      - '/it/express/**'
    target: /it/express/query-index.xlsx

  japan:
    <<: *default
    include:
      - '/jp/express/**'
    target: /jp/express/query-index.xlsx

  korea:
    <<: *default
    include:
      - '/kr/express/**'
    target: /kr/express/query-index.xlsx

  netherlands:
    <<: *default
    include:
      - '/nl/express/**'
    target: /nl/express/query-index.xlsx

  brasil:
    <<: *default
    include:
      - '/br/express/**'
    target: /br/express/query-index.xlsx

  taiwan:
    <<: *default
    include:
      - '/tw/express/**'
    target: /tw/express/query-index.xlsx

  china:
    <<: *default
    include:
      - '/cn/express/**'
    target: /cn/express/query-index.xlsx

  denmark:
    <<: *default
    include:
      - '/dk/express/**'
    target: /dk/express/query-index.xlsx

  finland:
    <<: *default
    include:
      - '/fi/express/**'
    target: /fi/express/query-index.xlsx

  norway:
    <<: *default
    include:
      - '/no/express/**'
    target: /no/express/query-index.xlsx

  sweden:
    <<: *default
    include:
      - '/se/express/**'
    target: /se/express/query-index.xlsx

  # templates:
  #   source: html
  #   fetch: https://{repo}-{owner}.hlx.page/{path}
  #   include:
  #     - 'express/**/*.(docx|md)'
  #     - '*/express/**/*.(docx|md)'
  #   exclude:
  #     - '**/Document.*'
  #     - 'express/learn/blog/**'
  #   target: https://adobe.sharepoint.com/:x:/r/sites/SparkHelix/Shared%20Documents/website/express/templates.xlsx?d=wf10c84f59e744163bf0a957a459177cd&csf=1&web=1&e=CSr8lx
  #   properties:
  #     sourceHash:
  #       select: head > meta[name=x-source-hash
  #       value: |
  #         attribute(el, 'content')
  #     lastModified:
  #       select: none
  #       value: |
  #         parseTimestamp(headers['last-modified'], 'ddd, DD MMM YYYY hh:mm:ss GMT')
  #     templates:
  #       select: main div.template-list a
  #       values: |
  #         match(attribute(el, 'href'), 'https://adobesparkpost.app.link/(.*)')