Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
How to make web service with links from items?
MortenSteengaard
Member Posts: 131
Hi experts,
This is regarding Business Central cloud.
On an item, you can make several links to files on some public server.
I would like to make these records available for a web service. How do I do that?
I can see that this has something to do with the table "Record Link" (number 2000000068). But I need to show the item number, description and the link to the file.
Hope, someone can help.
This is regarding Business Central cloud.
On an item, you can make several links to files on some public server.
I would like to make these records available for a web service. How do I do that?
I can see that this has something to do with the table "Record Link" (number 2000000068). But I need to show the item number, description and the link to the file.
Hope, someone can help.
0
Best Answer
-
Options
txeriff
Member Posts: 492
Those tables are system internal tables, are not shown in SQL.
I havent done anything for recordlink in ages but it used to be a common thing to customise.
You should create some page for items list and then you can use recordID to find its related entries in recordlink table.
something like:
variable type:
vrecordref: recordref;
vRecordRef.Open(2000000068); //table no.
if vRecordRef.Get(T27.RecordId) then ;
vRecordref.close;
...
for listing the record links and all related tables you can try the other way around (open T27 and try get with recordid from recordlink.)
0
Answers
I havent done anything for recordlink in ages but it used to be a common thing to customise.
You should create some page for items list and then you can use recordID to find its related entries in recordlink table.
something like:
variable type:
vrecordref: recordref;
vRecordRef.Open(2000000068); //table no.
if vRecordRef.Get(T27.RecordId) then ;
vRecordref.close;
...
for listing the record links and all related tables you can try the other way around (open T27 and try get with recordid from recordlink.)
Thank you very much. That was great.
I did this on a page-extension:
On the table "Record Link" there is a field called URL1. That contains the URL. I simply missed that.
Furthermore there is a field called "Record ID". I use that to get the Item-record like this where Rec is the "Record Link" table:
trigger OnAfterGetRecord()
var
RecordRef: RecordRef;
MyFieldRef: FieldRef;
begin
if Rec.Type = Rec.Type::Link then begin
RecordRef.Open(Database::Item);
if RecordRef.Get(Rec."Record ID") then begin
MyFieldRef := RecordRef.Field(1); // 1 = "No."
ItemNumber := MyFieldRef.Value;
end;
end;
end;