Update schema for batch upload | Community
Skip to main content
J
jooyeon_han
Level 2
November 14, 2024
Solved

Update schema for batch upload

  • November 14, 2024
  • 1 reply
  • 771 views

Hi everyone, 

We don't have anyone using API at our company and doing things in AEP UI. 

 

We have existing schema, dataset, and scheduled batch files. (Field A,B,C)

 

Now we want to onboard a different file based on a same primary key. (Field D,E,F)

 

What we did was 1. Update existing schema by adding field D,E,F. 2) Created dataset based on that schema 3) upload sample data into the dataset. 

 

When we try step 3, I am keep getting 'A required field [_bellca] of type object is missing from the input data. Please add the required field and try again' Why is this? I am attaching screenshot of our network schema. 

The individual fields are the subset of each object. (_bellca being the highest hierarchy) Is there a step I am forgetting from the UI?

 

 

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 DavidRoss91

@jooyeon_han sorry for the late reply here. In regard to creating a new dataset, I don't believe that would be necessary as it seems you are only trying to add a new object to an already existing schema. I.e. _bellca.bellUDFField is now included in the new file along with the original 3 objects. Could you provide an example of you input file? You can exclude any confidential information please.

1 reply

DavidRoss91
Community Advisor
DavidRoss91Community Advisor
Community Advisor
November 14, 2024

@jooyeon_han 

Does your input data file have the correct format? I.e. are your fields in this format?

 

_bellca.bellCustomerAttributes

_bellca.bellCustomerEligilityList

_bellca.bellCustomerIdentities

_bellca.bellUDFField

    J
    jooyeon_hanAuthor
    Level 2
    November 14, 2024

    Hi @davidross91 

    Thank you for your reply. 

     

    The existing batch fileA captures the fields that are associated to the first three hierarchy. (Each individual hierarchy has subset of fields and those are all captured).

    _bellca.bellCustomerAttributes

    _bellca.bellCustomerEligilityList

    _bellca.bellCustomerIdentities

     

    Now for the new batch fileB I would like to setup, the all fields that are associated to the last hierarchy (_bellca.bellUDFField) are included, including the primary key.

     

    I thought when adding a new data source (new batch file), I should update the existing schema by adding the new fields that are coming in, and setup a separate dataset so when the new batch file is uploaded, it will do the mapping based on the primary key. 

    I am very new to updating this and I am lost 😞

     

    DavidRoss91
    Community Advisor
    DavidRoss91Community AdvisorAccepted solution
    Community Advisor
    December 6, 2024

    @jooyeon_han sorry for the late reply here. In regard to creating a new dataset, I don't believe that would be necessary as it seems you are only trying to add a new object to an already existing schema. I.e. _bellca.bellUDFField is now included in the new file along with the original 3 objects. Could you provide an example of you input file? You can exclude any confidential information please.

      Terms & ConditionsAccessibility statement

      Loading footer...