JSON field names - renaming

Comments

4 comments

  • Avatar
    Adrian Williams

    Hi Martin,

     

    you could set the 'RemoveCommonPrefixes' property in the Optional section of the node's properties to True.

     

    Regards,

    Adrian

    0
    Comment actions Permalink
  • Avatar
    Martin Hamilton

    Hi Adrian - didnt seem to work. Think this could be that some of the fields dont have the prefix e.g,

     

    Input Field Name
    callCentreContactEmail
    callCentreWebAddress
    callCentreOpeningHours
    envelopes.billingMedia.id
    envelopes.billingMedia.description
    envelopes.isCopy
    envelopes.isMarketingExcluded
    envelopes.postalAddress.title

     

    Thanks

    Martin

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Yes, all the fields must have the common prefix (except for the refId fields).

    You could output all the envelopes.* fields to a separate output pin (switch to the Define tab in the properties and, at the end of the property list, add a new output called envelopes). The node would then remove all of the common prefixes for the fields output to the envelopes pin.

    Note that you must ensure that records are output to the data pin else you will get a node execution error.

    Regards,

    Adrian

    0
    Comment actions Permalink
  • Avatar
    Martin Hamilton

    that worked, thanks adrian

     

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk