Ask Your Question
0

L_Status field, download failure

asked 2021-11-18 15:28:49 -0600

Good day, our credentials are as follows:

Login URL: http://nwokmls.rets.paragonrels.com/r... Login ID: ZipRealty

We are currently getting an Exception error when attempting incremental data downloads for source OK_NWOAR. The following message, alluding to the field 'L_Status', indicates that we are getting characters in that field that are uncommon, perhaps even invalid. The failures began approx. 11/17/2021 13:30:04.

Error message as follows: "An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]"

Please advise if any invalid values may have made it into the L_Status field for this source.

Thank you for your time and efforts.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-11-18 18:38:15 -0600

It looks like you must have fixed this already.
I see some failures earlier where you were passing query strings like:
(L_Status=|${STATUS_LOOKUP_SOLD_@_AUCTION_CI_3}),(L_AskingPrice=1000-999999999),(L_UpdateDate=2021-11-17T06:56:26+)
Which is why the errors were returned.
The status values being passed should look like: (L_Status=|1_0,1_1)
It looks like you switched to using queries like: (L_UpdateDate=2021-11-18T00:20:29+),(L_StatusCatID=|1,2,3)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-11-18 15:28:49 -0600

Seen: 120 times

Last updated: Nov 18 '21