Skip to main content
Question

Define parameters in database which use as JSON query in JSONExtractor

  • June 4, 2024
  • 1 reply
  • 73 views

leroy
Contributor
Forum|alt.badge.img+1
  • Contributor

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!

1 reply

AliAtSafe
Safer
Forum|alt.badge.img+22
  • Safer
  • June 7, 2024

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!


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