helix-query.yaml

version: 1

indices:
  blog: &blog
    include:
      - '/express/learn/blog'
      - '/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')

  blog-jp:
    <<: *blog
    include:
      - '/jp/express/learn/blog'
      - '/jp/express/learn/blog/**'
    target: /jp/express/learn/blog/query-index.xlsx

  blog-de:
    <<: *blog
    include:
      - '/de/express/learn/blog'
      - '/de/express/learn/blog/**'
    target: /de/express/learn/blog/query-index.xlsx

  blog-fr:
    <<: *blog
    include:
      - '/fr/express/learn/blog'
      - '/fr/express/learn/blog/**'
    target: /fr/express/learn/blog/query-index.xlsx

  blog-es:
    <<: *blog
    include:
      - '/es/express/learn/blog'
      - '/es/express/learn/blog/**'
    target: /es/express/learn/blog/query-index.xlsx

  blog-in:
    <<: *blog
    include:
      - '/in/express/learn/blog'
      - '/in/express/learn/blog/**'
    target: /in/express/learn/blog/query-index.xlsx

  blog-it:
    <<: *blog
    include:
      - '/it/express/learn/blog'
      - '/it/express/learn/blog/**'
    target: /it/express/learn/blog/query-index.xlsx

  blog-uk:
    <<: *blog
    include:
      - '/uk/express/learn/blog'
      - '/uk/express/learn/blog/**'
    target: /uk/express/learn/blog/query-index.xlsx

  blog-br:
    <<: *blog
    include:
      - '/br/express/learn/blog/**'
    target: /br/express/learn/blog/query-index.xlsx

  website: &website
    include:
      - '/express/**'
      - '/education/express/**'
    exclude:
      - '/express/learn/blog'
      - '/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:
    <<: *website
    include:
      - '/de/express/**'
      - '/de/education/express/**'
    exclude:
      - '/de/express/learn/blog'
      - '/de/express/learn/blog/**'
    target: /de/express/query-index.xlsx

  spain:
    <<: *website
    include:
      - '/es/express/**'
      - '/es/education/express/**'
    exclude:
      - '/es/express/learn/blog'
      - '/es/express/learn/blog/**'
    target: /es/express/query-index.xlsx

  france:
    <<: *website
    include:
      - '/fr/express/**'
      - '/fr/education/express/**'
    exclude:
      - '/fr/express/learn/blog'
      - '/fr/express/learn/blog/**'
    target: /fr/express/query-index.xlsx

  indonesia:
    <<: *website
    include:
      - '/id_id/express/**'
      - '/id_id/education/express/**'
    exclude:
      - '/id_id/express/learn/blog'
      - '/id_id/express/learn/blog/**'
    target: /id_id/express/query-index.xlsx

  italy:
    <<: *website
    include:
      - '/it/express/**'
      - '/it/education/express/**'
    exclude:
      - '/it/express/learn/blog'
      - '/it/express/learn/blog/**'
    target: /it/express/query-index.xlsx

  japan:
    <<: *website
    include:
      - '/jp/express/**'
      - '/jp/education/express/**'
    exclude:
      - '/jp/express/learn/blog'
      - '/jp/express/learn/blog/**'
    target: /jp/express/query-index.xlsx

  korea:
    <<: *website
    include:
      - '/kr/express/**'
      - '/kr/education/express/**'
    exclude:
      - '/kr/express/learn/blog'
      - '/kr/express/learn/blog/**'
    target: /kr/express/query-index.xlsx

  netherlands:
    <<: *website
    include:
      - '/nl/express/**'
      - '/nl/education/express/**'
    exclude:
      - '/nl/express/learn/blog'
      - '/nl/express/learn/blog/**'
    target: /nl/express/query-index.xlsx

  brasil:
    <<: *website
    include:
      - '/br/express/**'
      - '/br/education/express/**'
    exclude:
      - '/br/express/learn/blog'
      - '/br/express/learn/blog/**'
    target: /br/express/query-index.xlsx

  taiwan:
    <<: *website
    include:
      - '/tw/express/**'
      - '/tw/education/express/**'
    exclude:
      - '/tw/express/learn/blog'
      - '/tw/express/learn/blog/**'
    target: /tw/express/query-index.xlsx

  china:
    <<: *website
    include:
      - '/cn/express/**'
      - '/cn/education/express/**'
    exclude:
      - '/cn/express/learn/blog'
      - '/cn/express/learn/blog/**'
    target: /cn/express/query-index.xlsx

  denmark:
    <<: *website
    include:
      - '/dk/express/**'
      - '/dk/education/express/**'
    exclude:
      - '/dk/express/learn/blog'
      - '/dk/express/learn/blog/**'
    target: /dk/express/query-index.xlsx

  finland:
    <<: *website
    include:
      - '/fi/express/**'
      - '/fi/education/express/**'
    exclude:
      - '/fi/express/learn/blog'
      - '/fi/express/learn/blog/**'
    target: /fi/express/query-index.xlsx

  norway:
    <<: *website
    include:
      - '/no/express/**'
      - '/no/education/express/**'
    exclude:
      - '/no/express/learn/blog'
      - '/no/express/learn/blog/**'
    target: /no/express/query-index.xlsx

  sweden:
    <<: *website
    include:
      - '/se/express/**'
      - '/se/education/express/**'
    exclude:
      - '/se/express/learn/blog'
      - '/se/express/learn/blog/**'
    target: /se/express/query-index.xlsx

  india:
    <<: *website
    include:
      - '/in/express/**'
      - '/in/education/express/**'
    exclude:
      - '/in/express/learn/blog'
      - '/in/express/learn/blog/**'
    target: /in/express/query-index.xlsx

  unitedkingdom:
    <<: *website
    include:
      - '/uk/express/**'
      - '/uk/education/express/**'
    exclude:
      - '/uk/express/learn/blog'
      - '/uk/express/learn/blog/**'
    target: /uk/express/query-index.xlsx