Using 'to_object' for Map attribute data preparation | Community
Skip to main content
_
_abs9900
Level 2
January 10, 2024
Solved

Using 'to_object' for Map attribute data preparation

  • January 10, 2024
  • 2 replies
  • 1326 views

Hi Team,

We have a requirement to ingest data into a map attribute.

Schema have a map attribute field and values will be ingested using Source database dataflows.

I have to use data prep function 'to_object' to ingest data.

While trying out with the sample code provided in document, it is not inserting any values into map field.

Eg: to_object​(“firstName”, “John”, “lastName”, “Doe”) is not ingesting any values.

But, when I used to_object("Test Data",iif(lower(license)=='y',to_object('val','y'),to_object('val','n'))) in ingestion using dataflow, it was showing below result.
Result: [Test Data -> "(NULL,NULL,NULL,y)"]

If I'm referring to documentation, result should be {"Test Data" : {"val":"y"} }

 

Question: Why the result is not showing up for example provided in documentation.

Is there any way that we can validate why to_object​(“firstName”, “John”, “lastName”, “Doe”) is not ingesting any values?

Also, if to_object is not the function that can be used for data prep, which function can be used?

I've referred document https://experienceleague.adobe.com/docs/experience-platform/data-prep/functions.html%3Flang%3Dsv#objects

 

@derekselby , @arpan-garg , please share your thoughts 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by arijitg

    Hi @_abs9900 

     

    Map objects are object of array element so can you try ingesting in this way and see if it works -->

     

    to_object("Test Data",iif(lower(license)=="y",to_array(true,to_object("val","y")),to_array(true,to_object("val","n"))))

    2 replies

    arijitg
    Adobe Employee
    arijitgAdobe Employee
    Adobe Employee
    January 11, 2024

    Hi @_abs9900 

     

    can you please share the schema structure where you want to ingest?

    Also if you don't use if-else logic and hardcode the value for testing are you able to preview the result?

     

      _
      _abs9900Author
      Level 2
      January 11, 2024

      Hi @arijitg ,

      Thanks for your response.

      Currently I'm ingesting data into 'Consent and Preference Details' field group oob attribute - consents.marketing.email.subscriptions

      When I try with hard coded values provided in documentation to_object("firstName", "John", "lastName", "Doe"), I can preview the result, but data not getting ingested against attribute when the flow runs.
      I've validated data in dataset using query service with below command 

      SELECT
      consents.marketing.email.subscriptions
      from
      <datasetname>
      ORDER BY
      consents.marketing.email.time ASC;

      Snapshot of preview screen:

       

        arijitg
        Adobe Employee
        arijitgAdobe EmployeeAccepted solution
        Adobe Employee
        January 11, 2024

        Hi @_abs9900 

         

        Map objects are object of array element so can you try ingesting in this way and see if it works -->

         

        to_object("Test Data",iif(lower(license)=="y",to_array(true,to_object("val","y")),to_array(true,to_object("val","n"))))

          NimashaJain
          Adobe Employee
          NimashaJainAdobe Employee
          Adobe Employee
          January 15, 2024

          @_abs9900 Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

          Terms & ConditionsAccessibility statement

          Loading footer...