Page Comparison

In order to assist with the Data Integration (DI) efforts with 3rd party systems (ex: Prismic, GraphCMS, BigQuery, PlentyMarkets, GCSStrapi, etc), Boxalino is presenting the Data Transformer service https://boxalino-di-transformer-krceabfwya-ew.a.run.app/ . This is an ETL-like service.

Use this service to:

Identify the required request BODY for content integration https://boxalino-di-transformer-krceabfwya-ew.a.run.app/transformer/view
Identify the required request BODY for API request https://boxalino-di-transformer-krceabfwya-ew.a.run.app/api/view
Identify if your project`s connector (headless CMS/BQ/etc) is supported. If not, please provide a service request.

...

Strapi Connector Properties

Expand

title	GraphCMS Strapi Connector Properties

Code Block
"connector": { "type": "strapi", "options": { "token": "", "url": "", "query": "", "locales": [] } }

Review this sample from Strapi`s live demo repository:

Code Block

{
  "connector": {
    "type": "graphql",
    "options": {
      "url": "https://api-0r3lf.strapidemo.com/api/articles",
      "token": "aa9e9646aba66edb7553d523d293cfd4239647d15c32c23de887ceb63dde23b5404f7d73bfbf2055141f93c1bffca5928477cfcc3e53072e796bce7adbf9e94dd1d2b12011fa9fe8f293fb8c3aa5dce191d354bc30d2caa691c30096df165771c0357acb2de6b8af081a23345bdb4b03f3f5d89011b85d36595a4a3e9e0a7861",
      "locales": ["en", "fr-FR"]
    }
  }
}

The query is optional. The query/filters must be escaped (copy-paste the query section into an escape/unescape online tool).

Additional, to the url are added the following default parameters: populate=*&pagination[pageSize]=100

We recommend to sync each collection type (no query/filters) and use the API request to set filters.

Info

The data is loaded for each locale.
In Strapi, each document has an ID for every language.

The relationship between documents is made based on the localizations property. In the output data, the connection between different language documents can be accessed via the bx_locale_ids (JSON) property.

Tip
With the use of the `_bx_locale_status` property (generated automatically) it can be identified if there is any localization available for other locales.

...

Strapi Mapping Sample (doc_content)

Expand

title	Prismic Strapi Mapping Sample (/api/articles)

Code Block

"mapping": {
      "title": "title",
      "link": "slug",
      "description": "ckeditor_content",
      "images": "image.data.attributes.url",
      "parent_content_ids": "category.data.id",
      "localized_string_attributes" : {
        "img_thumbnail":"image.data.attributes.formats.thumbnail.url",
        "img_medium":"image.data.attributes.formats.medium.url",
        "img_small":"image.data.attributes.formats.small.url",
        "seo_meta_title": "seo.metaTitle",
        "seo_meta_description": "seo.metaDescription",
        "seo_keywords": "seo.keywords",
        "seo_canonical_url": "seo.canonicalURL",
        "category_id": "category.data.id",
        "category_name": "category.data.attributes.name",
        "category_slug": "category.data.attributes.slug"
      },
      "raw": {
        "string_attributes": [
          "image",
          "blocks"
        ]
      }
    }

Expand

title	Strapi Mapping Sample (/api/categories)

Code Block
"mapping": { "title": "name", "link": "slug", "numeric_attributes": { "restaurant_ids":"restaurants.data[].id", "article_ids":"articles.data[].id" } }

Info

At Boxalino, we try to map the way our client expects for a headless integration to work.

For this reason, if your connector integration libraries allows for content to be accessed as HTML or text (ex: data.content) - this is as well possible.

In the above (prismic) sample:

data.content is a RichText (editor) input
when using the mapping “description”:data.content - it will be exported as TEXT
when adding the mapping for localized_string_attributes - it will be exported as HTML.
when adding the mapping in raw it will be exported as raw JSON

...

Expand

title	JSON body content for TEST request

Code Block

language	json

[
  {
    "connector": {
      "type": "prismic",
      "options": {
        "url": "https://rtux-integration.cdn.prismic.io/api/v2/",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA",
        "query": [
          "[at(document.type, \"category\")]"
        ]
      }
    },
    "document": {},
    "mapping": {},
    "languages": {}
  },
  {
    "connector": {
      "type": "prismic",
      "options": {
        "url": "https://rtux-integration.cdn.prismic.io/api/v2/",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA",
        "query": [
          "[at(document.type, \"blog\")]"
        ]
      }
    },
    "document": {},
    "mapping": {},
    "languages": {}
  },
  {
    "connector": {
      "type": "graphqlgraphcms",
      "options": {
        "endpoint": "https://api-eu-central-1.graphcms.com/v2/ckll4a83ni7og01yzfr3k9yc4/master",
        "token": "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6ImdjbXMtbWFpbi1wcm9kdWN0aW9uIn0.eyJ2ZXJzaW9uIjozLCJpYXQiOjE2MjI1NjIzMzMsImF1ZCI6WyJodHRwczovL2FwaS1ldS1jZW50cmFsLTEuZ3JhcGhjbXMuY29tL3YyL2NrbGw0YTgzbmk3b2cwMXl6ZnIzazl5YzQvbWFzdGVyIiwiaHR0cHM6Ly9tYW5hZ2VtZW50LW5leHQuZ3JhcGhjbXMuY29tIl0sImlzcyI6Imh0dHBzOi8vbWFuYWdlbWVudC5ncmFwaGNtcy5jb20vIiwic3ViIjoiZjZlMTcyNGYtOTI2NS00OTFjLWEwMzktYzFkNGI2ZDExZDA5IiwianRpIjoiY2twZTdweDVoZGR2bzAxejU1NjNwZjc1cCJ9.MjYP8I7OvwyOkiHiB22LPwOfRzEt_ilvp6jHTVufkQEs6UTxJeuOEDvcojbMAgiEa3lStbc3mOVDezOQhMoLdD-UYoSzGyKmzIBI76vsVv5xbkhKwnLBnmX2ssRHMfOgIuyEpG16SwNiyKuBOZdhC39dapEWwSn2bzWqSi4Y-LvIdsANlHfgdwzVzkJNfNAO-2oOMQC4h-QfBlUVoSEQPYLPmGDOUpcawnHXc60Lyg9rCdxooG9YVzXUeqoi4SIc8feHH4My4s_Eb9mprP6sewezTIb4ldPCVwAlh2xl5BrWYDLLNbhgVMmUVaNZjXSS40egT4xxIWiNPw4axCAKZbgsk78lgHo51t0hz8j6qIfn9G_ZNzMagKQRupx4guuMQXiXg30WjSE09HBv6QjDLQRz9A89eRAKCiGVddKGAvXy_cZrAi2OZ_gtsX993wR-kt6AtNZ7s2U5IZPribvLbiNBMtwh1kRfz_t_bUFLCJs7J332odSDkxL38LqR7oRNStZv6EqAXmelWYqBsUvnwZWI3DYqjysYfjb4JALSTwOa4zfDHDkzlaKOiIZwZkI0GroSed_fmL6cfkpmN63CRY3qNQfwG7cXT0mOuOTJSzRBw1QigfCVnM_M2881eBaBdpdwXw3zF7FlxJL1Y0uMSQ0RZ2l3WC81xH7KqUUlUPw",
        "type": "blogs",
        "filters": "active:true"
      }
    },
    "document": {
      "type": "content"
    },
    "mapping": {},
    "languages": {}
  }
]

TEST SAMPLE REQUEST `/test/sample`

You can also use the SAMPLE trigger in order to access one element of the requested types.

The JSON response will be the JSONL structure as it is exported to Boxalino GCS.

Tip
Use this service to validate & check that all your data is exported as desired.

Code Block

curl https://boxalino-di-transformer-stage-krceabfwya-ew.a.run.app/test/sample \
-X POST \
-d "[{\"connector\":{\"type\":\"prismic\",\"options\":{\"url\":\"https:\/\/rtux-integration.cdn.prismic.io\/api\/v2\/\",\"access_token\":\"MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA\",\"query\":[\"[at(document.type, \\\"category\\\")]\"]}},\"document\":{\"type\":\"content\"},\"mapping\":{\"id\":\"id\",\"type\":\"type\",\"creation\":\"first_publication_date\",\"last_update\":\"last_publication_date\",\"persona_type\":\"\",\"persona_id\":\"\",\"title\":\"data.name\",\"short_description\":\"\",\"description\":\"data.description\",\"images\":\"data.header_image.url\",\"link\":\"uid\",\"tags\":{\"default\":\"tags\"},\"parent_content_ids\":\"data.parent_category.id\",\"contents\":[],\"products\":[],\"customers\":[],\"stores\":\"\",\"status\":\"data.status\",\"string_attributes\":{\"default_tags\":\"tags\",\"version\":\"version\"},\"localized_string_attributes\":{\"category_title\":\"data.category_title\",\"slugs\":\"slugs\",\"linked_language_id\":\"alternate_languages[*].id\"},\"numeric_attributes\":{\"position\":\"data.position\",\"show_in_navigation\":\"data.show_in_navigation\"},\"localized_numeric_attributes\":{},\"datetime_attributes\":{},\"localized_datetime_attributes\":{}},\"languages\":{\"de\":\"en-de\",\"fr\":\"fr-ch\"}},{\"connector\":{\"type\":\"prismic\",\"options\":{\"url\":\"https:\/\/rtux-integration.cdn.prismic.io\/api\/v2\/\",\"access_token\":\"MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA\",\"query\":[\"[at(document.type, \\\"blog\\\")]\"]}},\"document\":{\"type\":\"content\"},\"mapping\":{\"id\":\"id\",\"type\":\"type\",\"creation\":\"first_publication_date\",\"last_update\":\"last_publication_date\",\"persona_type\":\"\",\"persona_id\":\"\",\"title\":\"data.title\",\"short_description\":\"\",\"description\":\"data.content\",\"images\":\"data.header_image.url\",\"link\":\"uid\",\"tags\":{\"default\":\"tags\",\"category\":\"data.category.tags\"},\"parent_content_ids\":\"data.category.id\",\"contents\":[],\"products\":[],\"customers\":[],\"stores\":\"\",\"status\":\"data.status\",\"string_attributes\":{\"tags\":\"tags\",\"category_uid\":\"data.category.uid\"},\"localized_string_attributes\":{\"slugs\":\"slugs\",\"alternate_languages\":\"alternate_languages[*].id\",\"meta_title\":\"data.meta_title\",\"content\":\"data.content\"},\"numeric_attributes\":{\"position\":\"data.position\"},\"localized_numeric_attributes\":{\"product_ids\":\"data.product_ids[*].id\"},\"datetime_attributes\":{},\"localized_datetime_attributes\":{}},\"languages\":{\"de\":\"en-de\",\"fr\":\"fr-ch\"}},{\"connector\":{\"type\":\"graphql\",\"options\":{\"endpoint\":\"https:\/\/api-eu-central-1.graphcms.com\/v2\/ckll4a83ni7og01yzfr3k9yc4\/master\",\"token\":\"eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6ImdjbXMtbWFpbi1wcm9kdWN0aW9uIn0.eyJ2ZXJzaW9uIjozLCJpYXQiOjE2MjI1NjIzMzMsImF1ZCI6WyJodHRwczovL2FwaS1ldS1jZW50cmFsLTEuZ3JhcGhjbXMuY29tL3YyL2NrbGw0YTgzbmk3b2cwMXl6ZnIzazl5YzQvbWFzdGVyIiwiaHR0cHM6Ly9tYW5hZ2VtZW50LW5leHQuZ3JhcGhjbXMuY29tIl0sImlzcyI6Imh0dHBzOi8vbWFuYWdlbWVudC5ncmFwaGNtcy5jb20vIiwic3ViIjoiZjZlMTcyNGYtOTI2NS00OTFjLWEwMzktYzFkNGI2ZDExZDA5IiwianRpIjoiY2twZTdweDVoZGR2bzAxejU1NjNwZjc1cCJ9.MjYP8I7OvwyOkiHiB22LPwOfRzEt_ilvp6jHTVufkQEs6UTxJeuOEDvcojbMAgiEa3lStbc3mOVDezOQhMoLdD-UYoSzGyKmzIBI76vsVv5xbkhKwnLBnmX2ssRHMfOgIuyEpG16SwNiyKuBOZdhC39dapEWwSn2bzWqSi4Y-LvIdsANlHfgdwzVzkJNfNAO-2oOMQC4h-QfBlUVoSEQPYLPmGDOUpcawnHXc60Lyg9rCdxooG9YVzXUeqoi4SIc8feHH4My4s_Eb9mprP6sewezTIb4ldPCVwAlh2xl5BrWYDLLNbhgVMmUVaNZjXSS40egT4xxIWiNPw4axCAKZbgsk78lgHo51t0hz8j6qIfn9G_ZNzMagKQRupx4guuMQXiXg30WjSE09HBv6QjDLQRz9A89eRAKCiGVddKGAvXy_cZrAi2OZ_gtsX993wR-kt6AtNZ7s2U5IZPribvLbiNBMtwh1kRfz_t_bUFLCJs7J332odSDkxL38LqR7oRNStZv6EqAXmelWYqBsUvnwZWI3DYqjysYfjb4JALSTwOa4zfDHDkzlaKOiIZwZkI0GroSed_fmL6cfkpmN63CRY3qNQfwG7cXT0mOuOTJSzRBw1QigfCVnM_M2881eBaBdpdwXw3zF7FlxJL1Y0uMSQ0RZ2l3WC81xH7KqUUlUPw\",\"type\":\"blogs\",\"fields\":\"{ title __typename locale createdAt active id metaDescription metaTitle publishedAt seoLink updatedAt content {  html text } headerImage { url id } stage background { css hex } brands { id name } createdBy { id name } history { createdAt } publishedBy { id name } updatedBy { id name } }\",\"filters\":\"active:true\",\"locales\":[\"de_CH\",\"fr_CH\"]}},\"document\":{\"type\":\"content\"},\"mapping\":{\"id\":\"id\",\"type\":\"__typename\",\"creation\":\"createdAt\",\"last_update\":\"updatedAt\",\"persona_type\":\"createdBy.name\",\"persona_id\":\"createdBy.id\",\"title\":\"title\",\"short_description\":\"\",\"description\":\"content.text\",\"images\":\"headerImage.url\",\"link\":\"seoLink\",\"tags\":{\"brands\":\"brands[*].name\"},\"parent_content_ids\":\"\",\"contents\":[],\"products\":[],\"customers\":[],\"stores\":\"\",\"status\":\"state\",\"string_attributes\":{\"background\":\"background.hex\",\"background_css\":\"background.css\",\"brand_ids\":\"brands[*].id\"},\"localized_string_attributes\":{\"meta_title\":\"metaTitle\",\"meta_description\":\"metaDescription\",\"content\":\"content.html\",\"slugs\":\"seoLink\"},\"numeric_attributes\":{},\"localized_numeric_attributes\":{\"display\":\"active\"},\"datetime_attributes\":{\"published_at\":\"publishedAt\"},\"localized_datetime_attributes\":{}},\"languages\":{\"de\":\"de_CH\",\"fr\":\"fr_CH\"}}]" \
-H "Content-Type: application/json" \
-H "mode: F" \
-H "type: content"

In the sample above, the following BODY is used:

Expand

title	JSON body content for the SAMPLE request

Code Block

language	json

[
{
  "connector": {
    "type": "prismic",
    "options": {
      "url": "https://rtux-integration.cdn.prismic.io/api/v2/",
      "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA",
      "query": ["[at(document.type, \"category\")]"]
    }
  },
  "document" : {
    "type" : "content"
  },
  "mapping": {
    "title": "data.name",
    "description": "data.description",
    "images": "data.header_image.url",
    "parent_content_ids": "data.parent_category.id",
    "status": "data.status",
    "localized_string_attributes": {
      "category_title": "data.category_title",
      "slugs": "slugs",
      "linked_language_id": "alternate_languages[*].id"
    },
    "numeric_attributes": {
      "position": "data.position",
      "show_in_navigation": "data.show_in_navigation"
    },
  },
  "languages": {,
  {
    "connector": {
      "type": "strapi",
      "options": {
        "url": "https://api-0r3lf.strapidemo.com/api/articles",
        "token": "aa9e9646aba66edb7553d523d293cfd4239647d15c32c23de887ceb63dde23b5404f7d73bfbf2055141f93c1bffca5928477cfcc3e53072e796bce7adbf9e94dd1d2b12011fa9fe8f293fb8c3aa5dce191d354bc30d2caa691c30096df165771c0357acb2de6b8af081a23345bdb4b03f3f5d89011b85d36595a4a3e9e0a7861",
        "locales": ["en", "fr-FR"]
      }
    },
    "document": {
      "type": "content"
    },
    "mapping": {},
    "languages": {}
  }
]

Warning
The sample CURL request does not include the STRAPI connector details because the STRAPI connector is accessing a demo setup.

TEST SAMPLE REQUEST `/test/sample`

You can also use the SAMPLE trigger in order to access one element of the requested types.

The JSON response will be the JSONL structure as it is exported to Boxalino GCS.

Tip
Use this service to validate & check that all your data is exported as desired.

Code Block

curl https://boxalino-di-transformer-stage-krceabfwya-ew.a.run.app/test/sample \
-X POST \
-d "[{\"connector\":{\"type\":\"prismic\",\"options\":{\"url\":\"https:\/\/rtux-integration.cdn.prismic.io\/api\/v2\/\",\"access_token\":\"MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA\",\"query\":[\"[at(document.type, \\\"category\\\")]\"]}},\"document\":{\"type\":\"content\"},\"mapping\":{\"id\":\"id\",\"type\":\"type\",\"creation\":\"first_publication_date\",\"last_update\":\"last_publication_date\",\"persona_type\":\"\",\"persona_id\":\"\",\"title\":\"data.name\",\"short_description\":\"\",\"description\":\"data.description\",\"images\":\"data.header_image.url\",\"link\":\"uid\",\"tags\":{\"default\":\"tags\"},\"parent_content_ids\":\"data.parent_category.id\",\"contents\":[],\"products\":[],\"customers\":[],\"stores\":\"\",\"status\":\"data.status\",\"string_attributes\":{\"default_tags\":\"tags\",\"version\":\"version\"},\"localized_string_attributes\":{\"category_title\":\"data.category_title\",\"slugs\":\"slugs\",\"linked_language_id\":\"alternate_languages[*].id\"},\"numeric_attributes\":{\"position\":\"data.position\",\"show_in_navigation\":\"data.show_in_navigation\"},\"localized_numeric_attributes\":{},\"datetime_attributes\":{},\"localized_datetime_attributes\":{}},\"languages\":{\"de\":\"en-de\",\"fr\":\"fr-ch\"}},{\"connector\":{\"type\":\"prismic\",\"options\":{\"url\":\"https:\/\/rtux-integration.cdn.prismic.io\/api\/v2\/\",\"access_token\":\"MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA\",\"query\":[\"[at(document.type, \\\"blog\\\")]\"]}},\"document\":{\"type\":\"content\"},\"mapping\":{\"id\":\"id\",\"type\":\"type\",\"creation\":\"first_publication_date\",\"last_update\":\"last_publication_date\",\"persona_type\":\"\",\"persona_id\":\"\",\"title\":\"data.title\",\"short_description\":\"\",\"description\":\"data.content\",\"images\":\"data.header_image.url\",\"link\":\"uid\",\"tags\":{\"default\":\"tags\",\"category\":\"data.category.tags\"},\"parent_content_ids\":\"data.category.id\",\"contents\":[],\"products\":[],\"customers\":[],\"stores\":\"\",\"status\":\"data.status\",\"string_attributes\":{\"tags\":\"tags\",\"category_uid\":\"data.category.uid\"},\"localized_string_attributes\":{\"slugs\":\"slugs\",\"alternate_languages\":\"alternate_languages[*].id\",\"meta_title\":\"data.meta_title\",\"content\":\"data.content\"},\"numeric_attributes\":{\"position\":\"data.position\"},\"localized_numeric_attributes\":{\"product_ids\":\"data.product_ids[*].id\"},\"datetime_attributes\":{},\"localized_datetime_attributes\":{}},\"languages\":{\"de\":\"en-de\",\"fr\":\"fr-ch\"}},{\"connector\":{\"type\":\"graphql\",\"options\":{\"endpoint\":\"https:\/\/api-eu-central-1.graphcms.com\/v2\/ckll4a83ni7og01yzfr3k9yc4\/master\",\"token\":\"eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6ImdjbXMtbWFpbi1wcm9kdWN0aW9uIn0.eyJ2ZXJzaW9uIjozLCJpYXQiOjE2MjI1NjIzMzMsImF1ZCI6WyJodHRwczovL2FwaS1ldS1jZW50cmFsLTEuZ3JhcGhjbXMuY29tL3YyL2NrbGw0YTgzbmk3b2cwMXl6ZnIzazl5YzQvbWFzdGVyIiwiaHR0cHM6Ly9tYW5hZ2VtZW50LW5leHQuZ3JhcGhjbXMuY29tIl0sImlzcyI6Imh0dHBzOi8vbWFuYWdlbWVudC5ncmFwaGNtcy5jb20vIiwic3ViIjoiZjZlMTcyNGYtOTI2NS00OTFjLWEwMzktYzFkNGI2ZDExZDA5IiwianRpIjoiY2twZTdweDVoZGR2bzAxejU1NjNwZjc1cCJ9.MjYP8I7OvwyOkiHiB22LPwOfRzEt_ilvp6jHTVufkQEs6UTxJeuOEDvcojbMAgiEa3lStbc3mOVDezOQhMoLdD-UYoSzGyKmzIBI76vsVv5xbkhKwnLBnmX2ssRHMfOgIuyEpG16SwNiyKuBOZdhC39dapEWwSn2bzWqSi4Y-LvIdsANlHfgdwzVzkJNfNAO-2oOMQC4h-QfBlUVoSEQPYLPmGDOUpcawnHXc60Lyg9rCdxooG9YVzXUeqoi4SIc8feHH4My4s_Eb9mprP6sewezTIb4ldPCVwAlh2xl5BrWYDLLNbhgVMmUVaNZjXSS40egT4xxIWiNPw4axCAKZbgsk78lgHo51t0hz8j6qIfn9G_ZNzMagKQRupx4guuMQXiXg30WjSE09HBv6QjDLQRz9A89eRAKCiGVddKGAvXy_cZrAi2OZ_gtsX993wR-kt6AtNZ7s2U5IZPribvLbiNBMtwh1kRfz_t_bUFLCJs7J332odSDkxL38LqR7oRNStZv6EqAXmelWYqBsUvnwZWI3DYqjysYfjb4JALSTwOa4zfDHDkzlaKOiIZwZkI0GroSed_fmL6cfkpmN63CRY3qNQfwG7cXT0mOuOTJSzRBw1QigfCVnM_M2881eBaBdpdwXw3zF7FlxJL1Y0uMSQ0RZ2l3WC81xH7KqUUlUPw\",\"type\":\"blogs\",\"fields\":\"{ title __typename locale createdAt active id metaDescription metaTitle publishedAt seoLink updatedAt content {  html text } headerImage { url id } stage background { css hex } brands { id name } createdBy { id name } history { createdAt } publishedBy { id name } updatedBy { id name } }\",\"filters\":\"active:true\",\"locales\":[\"de_CH\",\"fr_CH\"]}},\"document\":{\"type\":\"content\"},\"mapping\":{\"id\":\"id\",\"type\":\"__typename\",\"creation\":\"createdAt\",\"last_update\":\"updatedAt\",\"persona_type\":\"createdBy.name\",\"persona_id\":\"createdBy.id\",\"title\":\"title\",\"short_description\":\"\",\"description\":\"content.text\",\"images\":\"headerImage.url\",\"link\":\"seoLink\",\"tags\":{\"brands\":\"brands[*].name\"},\"parent_content_ids\":\"\",\"contents\":[],\"products\":[],\"customers\":[],\"stores\":\"\",\"status\":\"state\",\"string_attributes\":{\"background\":\"background.hex\",\"background_css\":\"background.css\",\"brand_ids\":\"brands[*].id\"},\"localized_string_attributes\":{\"meta_title\":\"metaTitle\",\"meta_description\":\"metaDescription\",\"content\":\"content.html\",\"slugs\":\"seoLink\"},\"numeric_attributes\":{},\"localized_numeric_attributes\":{\"display\":\"active\"},\"datetime_attributes\":{\"published_at\":\"publishedAt\"},\"localized_datetime_attributes\":{}},\"languages\":{\"de\":\"de_CH\",\"fr\":\"fr_CH\"}}]" \
-H "Content-Type: application/json" \
-H "mode: F" \
-H "type: content"

In the sample above, the following BODY is used:

Expand

title	JSON body content for the SAMPLE request

Code Block

language	json

[
  {
    "connector": {
      "type": "prismic",
      "options": {
        "url": "https://rtux-integration.cdn.prismic.io/api/v2/",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA",
        "query": [
          "[at(document.type, \"category\")]"
        ]
      }
    },
    "document": {
      "type": "content"
    },
    "mapping": {
      "title": "data.name",
      "description": "data.description",
      "images": "data.header_image.url",
      "parent_content_ids": "data.parent_category.id",
      "status": "data.status",
      "localized_string_attributes": {
        "category_title": "data.category_title",
        "slugs": "slugs",
        "linked_language_id": "alternate_languages[*].id"
      },
      "numeric_attributes": {
        "position": "data.position",
        "show_in_navigation": "data.show_in_navigation"
      }
    },
    "languages": {
      "de": "en-de",
      "fr": "fr-ch"
    }
  },
  {
    "connector": {
      "type": "prismic",
      "options": {
        "url": "https://rtux-integration.cdn.prismic.io/api/v2/",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA",
        "query": [
          "[at(document.type, \"blog\")]"
        ]
      }
    },
    "document": {
      "type": "content"
    },
    "mapping": {
      "title": "data.name",
      "description": "data.description",
      "images": "data.header_image.url",
      "parent_content_ids": "data.parent_category.id",
      "status": "data.status",
      "string_attributes": {
        "default_tags": "tags",
        "categories": "data.parent_category.id"
      },
      "localized_string_attributes": {
        "category_title": "data.category_title"
      },
      "numeric_attributes": {
        "position": "data.position"
      },
      "localized_numeric_attributes": {
        "enabled": "data.status",
        "show_in_navigation": "data.show_in_navigation"
      },
      "raw": {
        "localized_string_attributes": [
          "data.header_img",
          "data.description",
          "data.category_title",
          "data.parent_category"
        ]
      }
    },
    "languages": {
      "de": "en-de",
      "fr": "fr-ch"
    }
  },
  {
    "connector": {
      "type": "prismic",
      "options": {
        "url": "https://rtux-integration.cdn.prismic.io/api/v2/",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IA",
        "query": [
          "[at(document.type, \"newsletter\")]"
        ]
      }
    },
    "document": {
      "type": "content"
    },
    "mapping": {
      "title": "data.name",
      "short_description": "",
      "description": "data.description",
      "images": "data.header_img.url",
      "parent_content_ids": "",
      "status": "data.status",
      "string_attributes": {},
      "localized_string_attributes": {
        "description_bottom": "data.description_bottom",
        "contact": "data.contact",
        "benefits": "data.benefits",
        "footer_disclaimer": "data.footer_disclaimer",
        "footer_address": "data.footer_address"
      },
      "raw": {
        "localized_string_attributes": [
          "data.header_img",
          "data.shop_link",
          "data.description",
          "data.description_bottom",
          "data.benefits",
          "data.footer_address"
        ]
      }
    },
    "languages": {
      "de": "en-de",
      "fr": "fr-ch"
    }
  },
  {
    "connector": {
      "type": "graphcms",
      "options": {
        "endpoint": "https://api-eu-central-1.graphcms.com/v2/ckll4a83ni7og01yzfr3k9yc4/master",
        "token": "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6ImdjbXMtbWFpbi1wcm9kdWN0aW9uIn0.eyJ2ZXJzaW9uIjozLCJpYXQiOjE2MjI1NjIzMzMsImF1ZCI6WyJodHRwczovL2FwaS1ldS1jZW50cmFsLTEuZ3JhcGhjbXMuY29tL3YyL2NrbGw0YTgzbmk3b2cwMXl6ZnIzazl5YzQvbWFzdGVyIiwiaHR0cHM6Ly9tYW5hZ2VtZW50LW5leHQuZ3JhcGhjbXMuY29tIl0sImlzcyI6Imh0dHBzOi8vbWFuYWdlbWVudC5ncmFwaGNtcy5jb20vIiwic3ViIjoiZjZlMTcyNGYtOTI2NS00OTFjLWEwMzktYzFkNGI2ZDExZDA5IiwianRpIjoiY2twZTdweDVoZGR2bzAxejU1NjNwZjc1cCJ9.MjYP8I7OvwyOkiHiB22LPwOfRzEt_ilvp6jHTVufkQEs6UTxJeuOEDvcojbMAgiEa3lStbc3mOVDezOQhMoLdD-UYoSzGyKmzIBI76vsVv5xbkhKwnLBnmX2ssRHMfOgIuyEpG16SwNiyKuBOZdhC39dapEWwSn2bzWqSi4Y-LvIdsANlHfgdwzVzkJNfNAO-2oOMQC4h-QfBlUVoSEQPYLPmGDOUpcawnHXc60Lyg9rCdxooG9YVzXUeqoi4SIc8feHH4My4s_Eb9mprP6sewezTIb4ldPCVwAlh2xl5BrWYDLLNbhgVMmUVaNZjXSS40egT4xxIWiNPw4axCAKZbgsk78lgHo51t0hz8j6qIfn9G_ZNzMagKQRupx4guuMQXiXg30WjSE09HBv6QjDLQRz9A89eRAKCiGVddKGAvXy_cZrAi2OZ_gtsX993wR-kt6AtNZ7s2U5IZPribvLbiNBMtwh1kRfz_t_bUFLCJs7J332odSDkxL38LqR7oRNStZv6EqAXmelWYqBsUvnwZWI3DYqjysYfjb4JALSTwOa4zfDHDkzlaKOiIZwZkI0GroSed_fmL6cfkpmN63CRY3qNQfwG7cXT0mOuOTJSzRBw1QigfCVnM_M2881eBaBdpdwXw3zF7FlxJL1Y0uMSQ0RZ2l3WC81xH7KqUUlUPw",
        "type": "blogs",
        "fields": "{ title __typename locale createdAt active id metaDescription metaTitle publishedAt seoLink updatedAt content {  html text } headerImage { url id width height fileName} stage background { css hex } brands { id name locale } createdBy { id name } history { createdAt } publishedBy { id name } updatedBy { id name } localizations { id locale } }",
        "locales": [
          "de_CH",
          "fr_CH"
        ]
      }
    },
    "document": {
      "type": "content"
    },
    "mapping": {
      "title": "title",
      "description": "content.text",
      "images": "headerImage.url",
      "link": "seoLink",
      "tags": {
        "brands": "brands[*].name"
      },
      "status": "stage",
      "string_attributes": {
        "background_hex": "background.hex",
        "background_css": "background.css",
        "brand_ids": "brands[*].id",
        "brands": "brands[*].name"
      },
      "localized_numeric_attributes": {
        "active": "active"
      },
      "localized_string_attributes": {
        "meta_title": "metaTitle",
        "meta_description": "metaDescription",
        "content": "content.html"
      },
      "raw": {
        "localized_string_attributes": [
          "content",
          "background",
          "brands",
          "headerImage"
        ]
      }
    },
    "languages": {
      "de": "en-de_CH",
      "fr": "fr-ch_CH"
    }
  },
  {
    "connector": {
      "type": "prismicstrapi",
      "options": {
        "url": "https://rtuxapi-integration0r3lf.cdn.prismicstrapidemo.iocom/api/v2/articles",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IAaa9e9646aba66edb7553d523d293cfd4239647d15c32c23de887ceb63dde23b5404f7d73bfbf2055141f93c1bffca5928477cfcc3e53072e796bce7adbf9e94dd1d2b12011fa9fe8f293fb8c3aa5dce191d354bc30d2caa691c30096df165771c0357acb2de6b8af081a23345bdb4b03f3f5d89011b85d36595a4a3e9e0a7861",
        "querylocales": ["[at(document.typeen", \"blog\fr-FR")]"]
      }
    },
    "document" : {
      "type" : "content"
    },
    "mapping": {
      "title": "title",
      "link": "data.nameslug",
      "description": "data.descriptionckeditor_content",
      "images": "image.data.header_imageattributes.url",
      "parent_content_ids": "category.data.parent_category.id",
      "statuslocalized_string_attributes" : "data.status",{
        "string_attributes": {img_thumbnail":"image.data.attributes.formats.thumbnail.url",
        "defaultimg_tagsmedium": "tags"image.data.attributes.formats.medium.url",
        "categoriesimg_small": "image.data.parent_category.id"
   attributes.formats.small.url",
  },       "localizedseo_stringmeta_attributestitle": {"seo.metaTitle",
        "categoryseo_meta_titledescription": "dataseo.category_titlemetaDescription",
      },       "numericseo_attributeskeywords": {"seo.keywords",
        "positionseo_canonical_url": "dataseo.positioncanonicalURL"
  ,
   },       "localizedcategory_numeric_attributesid": {"category.data.id",
        "enabledcategory_name": "category.data.attributes.statusname",
        "showcategory_in_navigationslug": "category.data.show_in_navigationattributes.slug"
      },
      "raw": {
        "localized_string_attributes": [
          "data.header_imgimage",
          "data.descriptionblocks",
        ]
 "data.category_title",           "data.parent_category"
        ]}
      },
  },   "languages":{
{      "de": "en-de",
      "fr": "fr-chFR"
    }
  },
  {
    "connector": {
      "type": "prismicstrapi",
      "options": {
        "url": "https://rtuxapi-integration0r3lf.cdnstrapidemo.prismic.iocom/api/v2/reviews",
        "access_token": "MC5ZSkU4SnhBQUFDSUFXSXZR.77-9QO-_vWR577-977-9HO-_ve-_ve-_vXPvv73vv71LeO-_vUNi77-9Ii3vv73vv73vv71sC2Xvv71A77-9IAaa9e9646aba66edb7553d523d293cfd4239647d15c32c23de887ceb63dde23b5404f7d73bfbf2055141f93c1bffca5928477cfcc3e53072e796bce7adbf9e94dd1d2b12011fa9fe8f293fb8c3aa5dce191d354bc30d2caa691c30096df165771c0357acb2de6b8af081a23345bdb4b03f3f5d89011b85d36595a4a3e9e0a7861",
        "querylocales": ["en", "fr-FR"]
      }
    "[at(document.type, \"newsletter\")]"},
    "document" : {
 ]     "type" : }"content"
    },
    "documentmapping": {
      "typedescription": "content",
      }"persona_id": "author.data.id",
      "mappingpersona_type": {"author.data.attributes.email",
      "titleparent_content_ids": "restaurant.data.nameid",
      "string_attributes" : {
        "shortauthor_descriptionname": "author.data.attributes.username",
        "descriptionauthor_job": "author.data.attributes.description"job"
      },
      "imageslocalized_string_attributes" : "data.header_img.url", {
        "parentrestaurant_content_idsname": "restaurant.data.attributes.name",
        "statusrestaurant_slug": "restaurant.data.attributes.statusslug",
      "string_attributes": {},
      "localizednumeric_string_attributes": {
        "descriptionauthor_bottomconfirmed": "author.data.description_bottomattributes.confirmed",
        "contactauthor_blocked": "author.data.attributes.contactblocked",
        "benefitsnote": "data.benefits"note"
      }
    },
    "languages":{
      "footer_disclaimerde": "data.footer_disclaimeren",

       "footer_addressfr": "data.footer_address"fr-FR"
    }
  },
  {
    "rawconnector": {
      "type": "strapi",
      "localized_string_attributesoptions": [{
         "url": "data.header_imghttps://api-0r3lf.strapidemo.com/api/restaurants",
        "token":  "data.shop_linkaa9e9646aba66edb7553d523d293cfd4239647d15c32c23de887ceb63dde23b5404f7d73bfbf2055141f93c1bffca5928477cfcc3e53072e796bce7adbf9e94dd1d2b12011fa9fe8f293fb8c3aa5dce191d354bc30d2caa691c30096df165771c0357acb2de6b8af081a23345bdb4b03f3f5d89011b85d36595a4a3e9e0a7861",
        "locales":  ["data.descriptionen", "fr-FR"]
         "data.description_bottom",}
     },
    "data.benefitsdocument", : {
      "type" : "data.footer_addresscontent"
    },
   ] "mapping": {
    }  "title": "name",
 },     "languageslink": {"slug",
      "deimages": "en-deimage.data.attributes.url",
      "frparent_content_ids": "fr-ch"category.data.id",
     }
  }, "string_attributes" : {
   {     "connectorprice": "price",
{        "typeplace": "graphcms" "place.data.attributes.name",
      },
      "optionslocalized_string_attributes" : {
        "endpointinformation": "https://api-eu-central-1.graphcms.com/v2/ckll4a83ni7og01yzfr3k9yc4/masterinformation.description",
        "tokencategory_name": "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCIsImtpZCI6ImdjbXMtbWFpbi1wcm9kdWN0aW9uIn0category.data.eyJ2ZXJzaW9uIjozLCJpYXQiOjE2MjI1NjIzMzMsImF1ZCI6WyJodHRwczovL2FwaS1ldS1jZW50cmFsLTEuZ3JhcGhjbXMuY29tL3YyL2NrbGw0YTgzbmk3b2cwMXl6ZnIzazl5YzQvbWFzdGVyIiwiaHR0cHM6Ly9tYW5hZ2VtZW50LW5leHQuZ3JhcGhjbXMuY29tIl0sImlzcyI6Imh0dHBzOi8vbWFuYWdlbWVudC5ncmFwaGNtcy5jb20vIiwic3ViIjoiZjZlMTcyNGYtOTI2NS00OTFjLWEwMzktYzFkNGI2ZDExZDA5IiwianRpIjoiY2twZTdweDVoZGR2bzAxejU1NjNwZjc1cCJ9.MjYP8I7OvwyOkiHiB22LPwOfRzEt_ilvp6jHTVufkQEs6UTxJeuOEDvcojbMAgiEa3lStbc3mOVDezOQhMoLdD-UYoSzGyKmzIBI76vsVv5xbkhKwnLBnmX2ssRHMfOgIuyEpG16SwNiyKuBOZdhC39dapEWwSn2bzWqSi4Y-LvIdsANlHfgdwzVzkJNfNAO-2oOMQC4h-QfBlUVoSEQPYLPmGDOUpcawnHXc60Lyg9rCdxooG9YVzXUeqoi4SIc8feHH4My4s_Eb9mprP6sewezTIb4ldPCVwAlh2xl5BrWYDLLNbhgVMmUVaNZjXSS40egT4xxIWiNPw4axCAKZbgsk78lgHo51t0hz8j6qIfn9G_ZNzMagKQRupx4guuMQXiXg30WjSE09HBv6QjDLQRz9A89eRAKCiGVddKGAvXy_cZrAi2OZ_gtsX993wR-kt6AtNZ7s2U5IZPribvLbiNBMtwh1kRfz_t_bUFLCJs7J332odSDkxL38LqR7oRNStZv6EqAXmelWYqBsUvnwZWI3DYqjysYfjb4JALSTwOa4zfDHDkzlaKOiIZwZkI0GroSed_fmL6cfkpmN63CRY3qNQfwG7cXT0mOuOTJSzRBw1QigfCVnM_M2881eBaBdpdwXw3zF7FlxJL1Y0uMSQ0RZ2l3WC81xH7KqUUlUPwattributes.name",
        "typecategory_slug": "blogscategory.data.attributes.slug",
        "fieldsimg_thumbnail" : "{ title __typename locale createdAt active id metaDescription metaTitle publishedAt seoLink updatedAt content {  html text } headerImage { url id width height fileName} stage background { css hex } brands { id name locale } createdBy { id name } history { createdAt } publishedBy { id name } updatedBy { id name } localizations { id locale } }:"image.data.attributes.formats.thumbnail.url",
        "img_medium":"image.data.attributes.formats.medium.url",
        "img_small":"image.data.attributes.formats.small.url",
        "seo_meta_title": "seo.metaTitle",
        "seo_meta_description": "seo.metaDescription",
        "localesseo_keywords": ["de_CH"seo.keywords",
"fr_CH"]        }"seo_canonical_url": "seo.canonicalURL"
      },
      "documentnumeric_attributes" : {
        "typeplace_id" : "content"place.data.id"
      },
      "mappingraw": {
        "titlestring_attributes": "title", [
         "description": "content.textinformation",
    
 "images": "headerImage.url",       "link": "seoLinkblocks",
          "tagsseo": {
        "brands":"brands[*].name"
      },
      "status": "stage"},
      "string_attributeslanguages": {
        "background_hexde": "background.hexen",

       "background_cssfr": "background.css","fr-FR"
    }
   "brand_ids" : "brands[*].id"},
  {
     "brandsconnector": : "brands[*].name"{
       }"type": "strapi",
      "localized_numeric_attributesoptions": {
        "activeurl" : "active"
      },https://api-0r3lf.strapidemo.com/api/categories",
        "localized_string_attributestoken": {"aa9e9646aba66edb7553d523d293cfd4239647d15c32c23de887ceb63dde23b5404f7d73bfbf2055141f93c1bffca5928477cfcc3e53072e796bce7adbf9e94dd1d2b12011fa9fe8f293fb8c3aa5dce191d354bc30d2caa691c30096df165771c0357acb2de6b8af081a23345bdb4b03f3f5d89011b85d36595a4a3e9e0a7861",
        "meta_titlelocales": ["metaTitleen", "fr-FR"]
      }
    },
   "meta_description": "metaDescriptiondocument", : {
      "contenttype" : "content.html"
      },
      "rawmapping": {
 
        "localized_string_attributes"title": ["name",
            "content",
     "link": "slug",
      "backgroundnumeric_attributes",: {
           "brands"restaurant_ids":"restaurants.data[*].id",
            "headerImage"
          ]"article_ids":"articles.data[*].id"
        }
    },
    "languages": {
      "de": "de_CHen",
      "fr": "fr_CH-FR"
    }
  }
]

Warning
The sample CURL request does not include the STRAPI connector details because the STRAPI connector is accessing a demo setup. As an integrator, you can create your own demo setup (https://strapi.io/demo ) in order to check their available data.

Versions Compared

Old Version 22

New Version Current

Key

Strapi Connector Properties

Strapi Mapping Sample (doc_content)

TEST SAMPLE REQUEST `/test/sample`

TEST SAMPLE REQUEST `/test/sample`

Page Comparison

Versions Compared

Old Version 22

New Version Current

Key

Strapi Connector Properties

Strapi Mapping Sample (doc_content)

TEST SAMPLE REQUEST /test/sample

TEST SAMPLE REQUEST /test/sample

TEST SAMPLE REQUEST `/test/sample`

TEST SAMPLE REQUEST `/test/sample`