how to build a data model in ServiceNow

Kavitha2901
Tera Contributor

Hi , 

I am given a requirement to build a data model using email attachment(loaded with import set) and payload(REST API) in ServiceNow table.

Could anybody please provide some scenarios/use cases on how to build a data model in ServiceNow?

1 ACCEPTED SOLUTION

BillMartin
Mega Sage

Hi @Kavitha2901 , 

 

The data model in ServiceNow is readily available depending on what you are looking for. The platform has out-of-the-box capabilities that you can fully utilize.

 

You can explore the attachments table (sys_attachment.list) and find the related table that will be holding your data.

 

Screenshot 2024-05-07 at 10.00.13 PM.png

 

Once you have identified the table (data model) from the screenshot you will see the attachment relevant to your table.

 

Now, to answer your question on how to add an attachment with rest-api, i recommend to utilize the base64 conversion on both ends (outbound and inbound).

 

Finally, use gliderecord to manage the table and its fields in relevance to your objective with the use of Flow Designer Actions, ScriptInclude or Rest-API Outbound.

 

Hopefully, you find my response lucrative. Please mark as helpful and accept as solution if you see the purpose has been achieved.

 

Thanks,

Bill

View solution in original post

1 REPLY 1

BillMartin
Mega Sage

Hi @Kavitha2901 , 

 

The data model in ServiceNow is readily available depending on what you are looking for. The platform has out-of-the-box capabilities that you can fully utilize.

 

You can explore the attachments table (sys_attachment.list) and find the related table that will be holding your data.

 

Screenshot 2024-05-07 at 10.00.13 PM.png

 

Once you have identified the table (data model) from the screenshot you will see the attachment relevant to your table.

 

Now, to answer your question on how to add an attachment with rest-api, i recommend to utilize the base64 conversion on both ends (outbound and inbound).

 

Finally, use gliderecord to manage the table and its fields in relevance to your objective with the use of Flow Designer Actions, ScriptInclude or Rest-API Outbound.

 

Hopefully, you find my response lucrative. Please mark as helpful and accept as solution if you see the purpose has been achieved.

 

Thanks,

Bill