Mapping “null” values

  • Resolved ilcaroleader

    (@ilcaroleader)


    5 months, 3 weeks ago

    Hello, I’m trying to create a field mapping rule that displays “0” when Apimo pushes “null” as price/value

    “price”: {
    “value”: null,
    ….}
    What is the right syntax? I’ve tried
    If price.value Is equal to null then set Sale or Rent Price to 0
    If price/value Is equal to null then set Sale or Rent Price to 0
    If /price/value Is equal to null then set Sale or Rent Price to 0

    as well as other combinations with no results. Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Steve

    (@propertysteve)

    5 months, 3 weeks ago

    Please update to version 2.5.23 of Houzez Property Feed that I’ve just released and you’ll see the option of new ‘Is Null’ and ‘Is Not Null’ operators when creating field mapping rules.

    Hopefully that satisfies this request but any questions or issues do let me know,

    Steve

    Thread Starter ilcaroleader

    (@ilcaroleader)

    5 months, 3 weeks ago

    Thank you for the update.
    However it seems that the importer still ignores the Apimo “price/value” data:

    "rooms": 0,
    "bedrooms": 0,
    "sleeps": 0,
    "price": {
    "value": null,
    "max": null,

    Is this syntax correct?

    Thank you again

    Plugin Support Steve

    (@propertysteve)

    5 months, 3 weeks ago

    You can use JSONPath syntax:

    If $.price.value is null then set Sale or Rent Price to Price on demand

    Let me know how you get on with that.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.