Skip to main content
Question

Define parameters in database which use as JSON query in JSONExtractor

  • June 4, 2024
  • 1 reply
  • 75 views

leroy
Contributor
Forum|alt.badge.img+1

Hi folks,

In my situation, I am using JSONExtractor but the JSON queries differ between the testing and production environments. Rather than creating and maintaining two separate FME scripts, I prefer to define the target attributes and JSON queries in a database. This way, the correct configuration is used based on the environment's database.

However, the challenge is that multiple rows of configuration records are retrieved (with target attributes and JSON queries as table columns). Is there an example that shows how to convert these database records and assign them to the JSONExtractor in a generic way?

Thank you very much!

AliAtSafe
Safer
Forum|alt.badge.img+23

Hi @leroy,

Thanks for posting your question. To best assist you, could you share the database format you're using and possibly provide a general workflow breakdown with screenshots? Your input will be super helpful. Thanks a lot!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings