Contents of notepad added via API cannot be queried
Steven Lopresti
started a topic
over 1 year ago
Hi,
New to the ImportOmatic API and this is my first post.
I'm adding a notepad to a constituent record from the ImportOmatic API using IBBNotepadsAPI. It seemed to work great, but I can't query based on the contents of the Notes field. If I output the field, it's blank:
If I open the note, however, I can see the field's contents:
But then when I close the note, I'm greeted with this message:
If I click Yes, then my problem is fixed, but I'm importing hundreds of notes and can't realistically go into each one to get to this dialog box.
Does anyone know what I need to add to my code so that the Notes field can be queried and outputed?
Thanks!
Best Answer
S
Steve Brewer
said
over 1 year ago
Steven - There actually 2 notes fields on a note record in the API. My guess is that you are only setting one of those in your code. If I remember correctly, one is called Notes and one is called Actual Notes. You would need to add the text of the note to both of these fields and I believe that should solve your problem. Unfortunately when it comes to the RE API there are some quirks that are tricky to get around and this is one of those instances.
Steven - There actually 2 notes fields on a note record in the API. My guess is that you are only setting one of those in your code. If I remember correctly, one is called Notes and one is called Actual Notes. You would need to add the text of the note to both of these fields and I believe that should solve your problem. Unfortunately when it comes to the RE API there are some quirks that are tricky to get around and this is one of those instances.
Good luck with your code.
Steve
1 person likes this
Steven Lopresti
said
over 1 year ago
Wow, thanks a lot Steve! That did it!
The only remaining (minor) issue is that I still get the popup when I save or close the note. Any idea how to get around that?
S
Steve Brewer
said
over 1 year ago
That is one of the quirks that I mentioned. I am not sure the cause but it likely has something to do with that rich text box editor loading the note up and needing to transform/format it in some way for the UI. I think as long as the data is present, you can query on it, etc then you are good. It is only when someone actually opens that notepad to do something with it will they be presented with that message.
Steven Lopresti
said
over 1 year ago
Yes I agree, It's not much of an issue.
I tried creating a RichTextBox object in the API to store the notepad content, as referenced in another topic, Applying formatting to contents of notepad, but the System.Windows.Forms library doesn't seem to be available. Would you happen to know how to import it?
Steven Lopresti
Hi,
New to the ImportOmatic API and this is my first post.
I'm adding a notepad to a constituent record from the ImportOmatic API using IBBNotepadsAPI. It seemed to work great, but I can't query based on the contents of the Notes field. If I output the field, it's blank:
If I open the note, however, I can see the field's contents:
But then when I close the note, I'm greeted with this message:
If I click Yes, then my problem is fixed, but I'm importing hundreds of notes and can't realistically go into each one to get to this dialog box.
Does anyone know what I need to add to my code so that the Notes field can be queried and outputed?
Thanks!
Steven - There actually 2 notes fields on a note record in the API. My guess is that you are only setting one of those in your code. If I remember correctly, one is called Notes and one is called Actual Notes. You would need to add the text of the note to both of these fields and I believe that should solve your problem. Unfortunately when it comes to the RE API there are some quirks that are tricky to get around and this is one of those instances.
Good luck with your code.
Steve
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstSteve Brewer
Steven - There actually 2 notes fields on a note record in the API. My guess is that you are only setting one of those in your code. If I remember correctly, one is called Notes and one is called Actual Notes. You would need to add the text of the note to both of these fields and I believe that should solve your problem. Unfortunately when it comes to the RE API there are some quirks that are tricky to get around and this is one of those instances.
Good luck with your code.
Steve
1 person likes this
Steven Lopresti
Wow, thanks a lot Steve! That did it!
The only remaining (minor) issue is that I still get the popup when I save or close the note. Any idea how to get around that?
Steve Brewer
That is one of the quirks that I mentioned. I am not sure the cause but it likely has something to do with that rich text box editor loading the note up and needing to transform/format it in some way for the UI. I think as long as the data is present, you can query on it, etc then you are good. It is only when someone actually opens that notepad to do something with it will they be presented with that message.
Steven Lopresti
Yes I agree, It's not much of an issue.
I tried creating a RichTextBox object in the API to store the notepad content, as referenced in another topic, Applying formatting to contents of notepad, but the System.Windows.Forms library doesn't seem to be available. Would you happen to know how to import it?
-
Running a query with an ASK operator from IOM API
-
Data Append for Employment
-
How to Display Business Rule Pop-Ups
-
Opening a Query in API
-
Virtual Field Name reference
-
Deleting Aliases
-
Setting constituent attribute conditionally
-
API Documentation
-
Individual Relationships
-
Treating someone differently if they're already an Event Participant
See all 183 topics