I feel like the SKY API does not successfully bridge the gap for functions and processes that are done in Raiser's Edge Database.... For one we can't apply Gifts to specific Pledges paying down a pledge balance through the SKY Gift API. Also there is no way to post a gift or gifts without having the system ID of the constituent. The only way to get this is to run a search on the constituent using the Lookup ID that we have in both our systems to return the system ID in SKY API Constituent (search) endpoint. Why can't we post using the ID we have setup in database.... Makes no sense from a developer standpoint in my opinion.... I also feel like we should also be able to access the database information in some type of ecosystem and export data through some variation of SQL to integrate our organizations information systems easier. Whether it is getting data out of Raiser's Edge or Into Raiser's Edge for "bidirectional database synchronization" the tools that are provided make this process cumbersome and inadequate to perform essential processes. Leaving the only solution for developers and administrators with is to painstakingly enter the information manually in database view.... Or purchase some additional software to achieve this.